Performance and Stability-Related Fixes in Recent SQL Server 2008 SP3 Cumulative Updates

Even though I like to talk about the most recent major releases of SQL Server, there are still plenty of organizations running SQL Server 2008, which was a good, solid release of the product, with many improvements over SQL Server 2005. Lets assume that you have been pretty diligent about keeping your SQL Server 2008 […]

Performance Related Fixes in Post-SQL Server 2012 RTM Builds

There have already been five Cumulative Updates (CU) for the RTM branch of SQL Server 2012. Microsoft has also released SQL Server 2012 Service Pack 1, along with SQL Server 2012 SP1 Cumulative Update 1, with Cumulative Update 2 being due in the near future. There have been a high number of hotfixes in every […]

Performance Related Fixes in Post-SQL Server 2008 R2 Service Pack 1 Builds

As you may be aware if you have been reading my blogs or books over the years, I am a pretty strong advocate of staying current with both SQL Server Service Packs and SQL Server Cumulative Updates. This is also something that SQLskills recommends on our customer engagements. Despite this, it is still quite common […]

Top 10 Learning Resources for Accidental DBAs

So what should you do if you are an “accidental DBA”, who ends up dealing with SQL Server in some capacity on a regular basis without the benefit of any training or experience?  What if you are what I like to call a “captive DBA”, because you must install, maintain, and support some other Microsoft […]