Two Recent Laptops Compared

I have two fairly recent-vintage 13” personal laptops that I use primarily for teaching and presentations that I thought would be interesting to compare from some common performance perspectives. The first one, which is slightly over a year old is a Lenovo Yoga 900, which has a 14nm Intel Core i7-6500U Skylake-U processor, 16GB of […]

SQL Server 2012 Cumulative Updates Available

Microsoft has released SQL Server 2012 SP3 CU7 (Build 11.0.6579.0). According to the associated cumulative KB article, KB3205051, 12 issues have been resolved with this update. Microsoft has also released SQL Server 2012 SP2 CU16 (Build 11.0.5678.0). According to the associated cumulative KB article, KB3205054, 5 issues have been resolved with this update. If you […]

SQL Server 2016 Cumulative Updates Available

Microsoft has released SQL Server 2016 SP1 CU1 (Build 13.0.4411.0). According to the associated cumulative KB article, KB3208177, 63 issues have been resolved with this update. A number of them look to be pretty significant. Microsoft has also released SQL Server 2016 RTM CU4 (Build 13.0.2193.0). According to the associated cumulative KB article, KB3205052, 65 […]

Hardware Selection for a Home Lab – Part 1

I have long believed that if you want to be more successful as a developer, database professional, or in any technically-oriented I.T. career, it is a very good idea to have some sort of home lab environment to use for experimentation and learning. Depending on your goals, needs, budget, available space, etc., there are many […]

Operating System Support for SQL Server Versions

There are currently six major versions of SQL Server that I commonly see being used in Production, along with five major versions of Windows Server. Only certain combinations of SQL Server and Windows Server are officially supported by Microsoft, but tracking down this information is a little tedious. Table 1 shows these possible combinations and […]

SQL Server Diagnostic Information Queries for January 2017

This month, I have updated the legacy queries for SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. There are also minor updates for the SQL Server 2012 and newer queries. Rather than having a separate blog post for each version, I have just put the links for all six major versions in […]