Category Archives: Uncategorized

Date: Saturday, September 24th – Session starts at: 2:45PM Session Level: Intermediate I’ll be covering some of the different way we can use PowerShell to extend our T-SQL scripting.  This session will include a mix of using SMO, .NET classes, … Continue reading →

Yes, is out!!  Download at: https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx You must have a valid Live ID account to be able to proceed downloading the SQL Server Denali CTP3, and must allow to install the Activex control or use the Java Applet for the Download … Continue reading →

Post in Twitter: From @SQLvariant: Pretty Cool: Microsoft SQL Server Code-Named “Denali” CTP3 Release Noteshttp://social.technet.microsoft.com/wiki/contents/articles/3711.aspx #SQLDenali  (07/12/2011 – updated release note link) (Updated: 07/09/2011 – Microsoft decided to remove the link to this Release Notes.) From me (@MaxTrinidad): #SQLDenali #PowerShell – … Continue reading →

Here’s a good example of how useful is SMO in your SQL Server Developement environment.  As I the task repopulating data in a quarterly basis, I need to clear all my staging tables in databases before my import processes.   OK! … Continue reading →

This script hold a total of 4 functions to help setup your missing PowerShell User profiles which are not created when installing Window Management Framework, nor setup during then new Windows 7/2008R2 Operating Systems. Get this script at the Microsoft … Continue reading →

First, at today PowerShell Deep Dive sessions, Jeffrey Snover (Microsoft Father of PowerShell) has tweeted: “ANNOUNCING: #PowerShell Licensed under the Community Promise http://tinyurl.com/3d5vcf3 WHOOOOT!!” Then, SAPIEN Technologies tweeted: (Check their blog!!) “New: : It’s All New! http://www.sapien.com/blog/2011/04/18/its-all-new/” Finally, PowerShell MVP … Continue reading →

I created the function “Get-dbTableRecordCount” to get both the tables record and data space used from a selected table.  A the same time, if you can’t remember the databasename, then you can use the parameter ” -ShowAllDatabases Y ” to only … Continue reading →

I just posted a new PowerShell function to help get information about your SQL Server(s).  Following Don Jones recent post about “Inventory SQL Server Versions on Multiple Computers” this is just to show you, if you have SQL Server 2008 … Continue reading →

I love the PowerShell collaboration in the IT community.  One of my twitter followers reminded me about the “Format-Table” command  that allows you to group your collection using the parameter “-GroupBy” which work beautifully.  There’s no need to add the “ForEach” command.  I trully forgot to the … Continue reading →

OK!  Calling all Florida West and Central Coast IT professionals.  The first Florida ITCampSaturday is coming to Tampa, Florida on Saturday March 19th.  It’s an all day free event you don’t want to miss. Topics can be anything applicable to … Continue reading →