Query #3 is Server Properties. This query simply makes multiple calls to the T-SQL SERVERPROPERTY metadata function to retrieve quite a bit of useful information
Since I have not learned my lesson from doing a daily blog post for a month from the previous several times that I have done
As I discussed yesterday, I have done some fairly significant reorganization work for the SQL Server 2016, SQL Server 2014, and SQL Server 2012 versions
On December 21, 2015, Microsoft released SQL Server 2014 Service Pack 1 Cumulative Update 4, which is Build 12.0.4436.0. This CU has 34 hotfixes in
After much thought, and some procrastination, I have decided to implement a fairly significant reorganization of my SQL Server Diagnostic Information Queries, starting with the
Back in April of 2012, I built an Intel Z77 workstation that used a 512GB OCZ Vertex 4 SATA III SSD, plugged into a SATA
Microsoft recently (Nov 19, 2015) released Windows Server 2016 Technical Preview 4, which is the fourth pre-release version of Windows Server 2016. You can download
This month, I revised several queries, mainly based on suggestions from readers. The SQL Server 2016 version will continue to be improved with more SQL
(New: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who ends
This month, I spent some time adding columns for the new SERVERPROPERTY options, along with adding more comments and links to the scripts. The SQL
On October 19, 2015, Microsoft released SQL Server 2014 Service Pack 1 Cumulative Update 3 (Build 12.0.4425.19). This CU has 36 updates in the public
Back when I started at SQLskills in May of 2012, I built myself a pretty nice Z77 chipset system with an Intel Core i7-3770K Ivy
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.