Category Archives: SQL Server

About SQL Server.

T-SQL & PowerShell – Another way to Identify Database Snapshots

Posted on February 21, 2012 by admin

Just a quick blog on spotting your Database Snaphots. I just couldn’t believe that I’ve been missing creating SQL database snapshots but sometimes having so much work make you blind.  I’ve been using a lot Hyper-V Snapshot features and recently … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

“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

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

Windows 8 Hyper-V 3.0 – My Personal 8 Tips for the Newbie

Posted on October 31, 2011 by admin

Well, Here’s some tips to those who are first timers with Windows 8 Server (or Client) Preview edition.  I have to say, after been using the previous version of Hyper-V, I’m very happy for what i’ve seen so far in … Continue reading →

Posted in Hyper-V, PowerShell, SQL Server, Windows 8 | Comments Off