It’s like Christmas in November I’m really looking forward to getting a sneak peak as to what SQL Server 2011 will look like. I love this “not having to wait 5 years” for the next major version upgrade stuff Microsoft SQL Server 2011 CTP1 Code Name Denali: Download Here Enjoy!! (Follow me on Twitter: @ColinStasiuk )
Posts under ‘Release Information’
SQL Server 2008 SP2 Released
SQL Server 2008 SP2 has been released and I must be living under a rock because I had no idea it was coming. Fellow SQL blogger (and Canadian) Aaron Bertrand broke the news on his blog here Link to the Service Pack Link to the bugs that are fixed in SQL Server 2008 SP2 Note (from Aaron [...]
I Love Fights That I Can’t Lose…. (Separated Environments and Security)
Part of your job as a DBA is to ensure the stability and integrity of your environment. In assuming this role you’ve also probably had to have the fight about separated development (DEV), User Acceptance Testing (UAT), and Production (PROD) environments. Now your environment might also include a Staging (STG) and maybe even a Training [...]
Check SQL Server Agent status on all SQL Servers
Every company I’ve worked at had some type of standard schedule to apply (non critical) Windows patching. Most (if not all) of the time this ends up requiring a reboot of the whole environment which no matter how good your shutdown/startup documentation is tends to be a worrysome time. If you haven’t played around with SQL [...]
SQL 2008 Upgrade – Slow down there cowboy…
So now that Service Pack 1 is out for SQL Server 2008 and the excuse reason of wanting to wait till Service Pack 1 before upgrade is out of the way let’s talk about some advice when doing an upgrade to SQL Server 2008. (This is NOT a comprehensive list just a braindump of some [...]


