Building a Workstation for SQL Server 2012 Development and Testing

With the current crop of high-performance and very affordable desktop computer components, it is not very difficult to assemble an extremely high performance workstation for SQL Server 2012 development and testing at a very reasonable cost. Depending on how much of a purist you are and what your available budget is, you can take several […]

More Courses from SQLskills on Pluralsight!

Late this afternoon, two more SQLskills authored courses went live on Pluralsight. The first one is from me, which is SQL Server 2012: Installation and Configuration, while the second one is from my colleague Joe Sack, who authored SQL Server: Troubleshooting Query Plan Quality Issues . With these two courses being available, that makes 13 […]

Important Hotfix for SQL Server 2008 and Newer

Microsoft recently released a hotfix for a memory leak leak issue that affects SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. This memory leak only occurs if the have the AUTO_UPDATE_STATISTICS_ASYNC database level setting enabled for any of your databases. Here is how Microsoft describes the issue in the hotfix KB article: […]