Building a Desktop Workstation for SQL Server Development and Testing

Back in March of 2014, I wrote a fairly long blog post called Building a Workstation for SQL Server 2014 Development and Testing, which still generates quite a bit of hits and e-mail. Since it is about eighteen months later, I thought it was about time to update this information to cover the latest available […]

SQL Server Diagnostic Information Queries for September 2015

This month, I spent quite a bit of time synchronizing the scripts between the SQL Server 2016, 2014, and 2012 versions, making sure the small differences that were cropping up between the versions were cleaned up as much as possible. The SQL Server 2016 version will continue to be improved with more SQL Server 2016-specific […]

Samsung 950 PRO M.2 PCIe NVMe SSD

Samsung has announced their new 950 PRO M.2 PCIe NVMe solid state drive, which is potentially great news if you are considering building a new system (or have a new enough system that has M.2 slots that support PCIe 3.0 x4 speeds) According to the press release: The 950 PRO will be available in 512 […]

SQL Server 2012 SP2 Cumulative Update 8 Available

Microsoft has released SQL Server 2012 Service Pack 2 Cumulative Update 8, which is Build 11.0.5634.1. This CU has 23 fixes in the public fix list, and a number of them look pretty significant. If you are on SQL Server 2012, you need to be on the Service Pack 2 branch by now (especially since […]

Analyzing and Improving I/O Subsystem Performance Precon in Denver

On September 18, 2015, I will be presenting Analyzing and Improving I/O Subsystem Performance as an all day pre-conference session the day before SQLSaturday #441 in Denver. This session should be a lot of fun and will be very useful for SQL Server database administrators and other I.T. professionals who work with SQL Server. Here […]