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 […]

Intel Speed Shift Support in Windows Server 2016

If you are gathering evidence to help make the case for a complete data platform upgrade in 2017, you want to find as much information as possible to bolster your argument. This post is meant to assist you in your efforts. By early-mid 2017, Windows Server 2016 will have been GA long enough to convince […]

AES-NI Encryption Support in SQL Server 2016

Microsoft’s Bob Dorr has recently consolidated a series of CSS posts about many low-level performance improvements in SQL Server 2016. One of these posts, SQL 2016 – It Just Runs Faster – AlwaysOn AES-NI Encryption describes how SQL Server 2016 improved and simplified Endpoint creation for AlwaysOn AGs to default to AES, and to better […]

Windows Server 2016 Technical Preview 4

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 it here. According to Mary Jo Foley, Windows Server 2016 is due for release in the second half of 2016. It looks like Windows Server 2016 will be moving to […]