Feb 1st, 2010
by Colin Stasiuk.
The more I work with PowerShell the more I love it
So what do you do if you’re in a VM environment and you want/need to reboot your server but you can’t connect via RDP and you can’t connect to the console using the VM Infrastructure Client, and all other attempts to connect just [...]
Sep 22nd, 2009
by Colin Stasiuk.
Translation: Fail Whale for SQL Server Management Studio and Central Management Server for Policy Based Managment using PowerShell…. lol simple eh?
So this is a Microsoft Connect Item in the making…
I had created a PowerShell script to run a bunch of policies against a list of servers that I defined in a ServerList.txt file. I decided [...]
Aug 26th, 2009
by Colin Stasiuk.
OK so the last time I handed out a SQL Bacon Nugget of Excellence Award was July 8th for @SQLAgentMan ’s article on Determining Free Space, Consumed Space, and Total Space Allocated for Microsoft SQL Server Databases
and this time around @SQLGal has put something together that can only be described as a SQL Bacon Nugget of [...]
Aug 14th, 2009
by Colin Stasiuk.
So I’m a firm believer in the KISS theory.
No not THAT KISS… the Keep It Simple Stupid theory.
So when it comes to backups… if I’m not needing to “trick them out” or do anything custom I don’t have any problems with setting up a nice and easy maintenance plan and calling it a day. I [...]