Author Archives: admin

“PowerShell Query for the T-SQL Developer” Slide deck and samples

Posted on February 15, 2012 by admin

Once again, Thanks! to Patrick LeBlanc for allowing me to present at today’s (02/15/2012) SQLLunch.com.  It was a Great! turned out with over 60 people attending.  To You All THANKS!!  (Recorded session will be available) Well, here’s my slide deck … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

PowerShell Start-Demo now allows multi-lines one-liner

Posted on February 10, 2012 by admin

Well, I just couldn’t stop making necessary changes to this great presenter tool.  So, now Start-Demo will process your multi-lines one-liners which this couldn’t be done in the previous version. So, a good example of a one-liner having line continuation, … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

PowerShell Start-Demo makeover for StudioShell

Posted on February 10, 2012 by admin

I blogged about a nice Visual Studio addon “StudioShell” that fits very well with SSMS “SQL Server Management Studio 2012“, and I found this tool very useful for presenting.  But, when I try running the (long time) famous “Start-Demo” script, it … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

Codeplex StudioShell in SSMS 2012 – Try it!!

Posted on February 9, 2012 by admin

If you haven’t yet try it, go ahead download and install this Visual Studio Extension to your SQL Server Management Studio 2012.  This tool will integrate a PowerShell host into your SSMS which you will love for presentations and quick … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

PowerShell quick list of SQL Users with SysAdmin Role

Posted on February 3, 2012 by admin

Here’s a quick way to start getting a list of SQL Server users having “SysAdmin” Role.  Basically, I’m using SQLPS module (now available with SQL Server 2012) which loads all the SMO needed to help you script against your SQL … Continue reading →

Posted in Office, PowerShell, SQL Server | Comments Off

QuickBlog – Use PowerShell to submit SQLServicePack job to multiple Server

Posted on January 25, 2012 by admin

This was an interesting discussion in the LinkedIn “How to Install SQL Service Pack by PowerShell?”.  I got the chance to create and test this one out. I scratched the previous script I posted trying to show probe a concept, and … Continue reading →

Posted in PowerShell, SQL Server, Windows 8 | Comments Off

PowerShell – Trap cmdlet errors.

Posted on December 29, 2011 by admin

Sometimes working with data can be challenging.  As a SQL Developer, creating ETL solutions, is our responsibility all this data makes it to our users.  Sometime data manipulation might be limited in SSIS, we are force to look for other … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

PowerShell – Sum items in a CSV file.

Posted on December 21, 2011 by admin

The fact that PowerShell gives you the ability to a build tasks in many different ways, it’s sometimes intimidating.  But, you’ll find the way to improve your coding as time goes.  I try, the best I can, to keep things simple. So, … Continue reading →

Posted in PowerShell | Comments Off

QuickBlog – Finding a value in a PowerShell Hash table – Simple!!

Posted on December 16, 2011 by admin

For this quick blog, let’s create a month hash object table containing the number and name of the month.  Then, we are going to query this Hash Table object for a specific month. 1. Creating our Month Hash Table: Notice in this … Continue reading →

Posted in PowerShell | Comments Off

SQLPASS PowerShell Virtual Chapter – “Extending T-SQL with PowerShell” Posted Slides & Scripts..

Posted on December 5, 2011 by admin

For all whom attended the SQLPASS PowerShell Virtual Chapter – “Extending Your T-SQL Scripting with PowerShell” session on Wednesday November 16th, I finally got it posted here. My sincere Apologies for the long delay in posting my session slides and … Continue reading →

Posted in PowerShell, SQL Server | Comments Off