SQL Server Agent Does Not Start After Uninstalling/Reinstalling SQL Server 2012

A little while back, I ran into an interesting little problem after uninstalling and then reinstalling SQL Server 2012 on the same machine. In order to record a nice, pretty demonstration of installing SQL Server 2012 on a test machine for one of my Pluralsight courses, I decided to completely uninstall SQL Server 2012, and […]

Speaking at PASS Summit 2013 in Charlotte

I found out last week that I will be presenting two sessions at the PASS Summit 2013 in Charlotte, NC. The first one will be a full-day pre-conference session on Scaling SQL Server 2012. This will be an updated and reorganized version of the preconference session that I have given this year in Lisbon Portugal, […]

Performance and Stability-Related Fixes in All SQL Server 2008 SP2 Cumulative Updates

SQL Server 2008 Service Pack 2 was retired and became an “unsupported service pack” back on September 17, 2012. Despite this, I have been running into a lot of systems lately that are still running SQL Server 2008 Service Pack 2 or older lately, so I thought it made sense to follow up my previous […]

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

Even though there are two newer, major releases of SQL Server available, there are still many organizations running SQL Server 2008, which was a good, solid release of the product, with many improvements over SQL Server 2005. SQL Server 2008 (and SQL Server 2008 R2) are scheduled to fall out of mainstream support on July […]

SQL Server 2008 Service Pack 3 Cumulative Update 11

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 11, which is Build 10.0.5840.00. There are six hotfixes in the public fix list. There is no corresponding cumulative update for earlier service pack levels for SQL Server 2008, since they are retired. If you are on SQL Server 2008, you really should be […]

A SQL Server Hardware Tidbit a Day – Day 30

For the final post in this series, I want to list a few resources that you can use to help stay current with what is happening in the world of server hardware and storage. I really think that a database professional has a professional responsibility to know the details of their database server hardware and […]