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 [...]
Glenn Berry
Semi-random musings about SQL Server performance
Building a Workstation for SQL Server 2012 Development and Testing
Posted on: January 20, 2013 4:28 pm
More Courses from SQLskills on Pluralsight!
Posted on: January 11, 2013 5:42 pm
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
Posted on: January 10, 2013 1:46 pm
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: [...]
