Monthly Archives: February 2012

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

“Windows 8 PowerShell and Hyper-V 3.0 Preview” Slide deck and samples

Posted on February 20, 2012 by admin

Last weekend at the “ITPro Camp Saturday” in Sarasota Forida was great event.  Thanks to everyone for participating, and taking the precious time on a Saturday to learn about new and current technologies.  It was a GREAT!! Here’s my “Windows … Continue reading →

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

It’s Just Random: PowerShell – Mistery of Redrum Solved!!

Posted on February 17, 2012 by admin

It’s Friday and I’m following Jeffery Hicks idea to have fun with PowerShell.  Well, here’s the mistery of Redrum solved one more time.  Some time ago, I remember seen some code for reversing a string of characters.  Well, here’s the … Continue reading →

Posted in PowerShell | Comments Off

QuickBlog: PowerShell Automating your Credentials

Posted on February 16, 2012 by admin

Back in January, I did a quick blog about “Use PowerShell to submit SQLServicePack job to multiple Server“, in that script I have PowerShell to always prompt me for credentials.  But, after a while of typing over and over my … Continue reading →

Posted in PowerShell | 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