Intel Xeon E7 Processor Generational Performance Comparison

Intel has a fairly recent document titled Accelerated Operations for Telecom and Financial Services which is also listed under Accelerate OLTP Database Performance with Intel TSX. It describes the “performance” increases seen with the AsiaInfo ADB from moving from 2.8GHz Intel Xeon E7-4890 v2 (Ivy Bridge-EX), to 2.5GHz Intel Xeon E7-8890 v3 (Haswell-EX), and finally […]

CPU-Z 1.78 is Available

On November 21, CPU-Z 1.78 was released. This is a great tool for getting all the technical details about your processors and checking on their current clock speed. The main improvement in this version is support for Intel Kaby Lake processors, which are already available in the mobile space. It looks like the desktop version […]

SQL Server 2016 Service Pack 1 and SQL Server 2016 RTM CU3

Microsoft has released SQL Server 2016 RTM CU3 (Build 13.0.2186.6), with 31 fixes in the public fix list. They have also released SQL Server 2016 Service Pack 1 (Build 13.0.4001.0). As they previously did for SQL Server 2014 SP2, Microsoft has managed to include all of the hotfixes from the latest SQL Server 2016 RTM […]

Major Changes for SQL Server 2016 Standard Edition

At today’s Connect() event, Microsoft announced some pretty major changes for SQL Server 2016 Standard Edition, which are implemented in SQL Server 2016 Service Pack 1 (which was also released today). Many very useful SQL Server features that were previously only available in Enterprise Edition will now be available in Standard Edition (and also in […]

SQL Server Diagnostic Information Queries for November 2016

This month, I have added several new queries to SQL Server 2016 set, along with adding additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. I have gotten quite a bit of interest about making a special version of these queries for SQL Database in Microsoft Azure. So, I will be […]