Rotating Header Image

Posts under ‘Release Information’

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 […]

SQL 2008 Adoption Rate Poll Results and Thoughts

To start with I’m not going to begin to argue that my poll is of adequate industry sample size for a true adoption rate but there is a definite trend in the results. 51% of the people who voted indicated that they currently have no SQL Server 2008 instances running in production. 37% indicated that […]

Cumulative update package 1 for SQL Server 2005 Service Pack 3

Microsoft has releases CU1 for Service Pack 3 for SQL Server 2005.  Service Pack 3 did not include CU10 and CU11 for Service Pack 2 so this update has those hotfixes (and no additional fixes). http://support.microsoft.com/kb/959195/en-us and with the usual disclaimer of making sure to test in your dev and UAT enviornments before applying to […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.