SQL Server 2017 Licensing Datasheet

There’s a brand new SQL Server 2017 Licensing Datasheet to support general availability of this product on 2nd October 2017. There aren’t changes to the fundamental licensing but this datasheet is a nice summary including useful information such as the differences in SA benefits between Standard and Enterprise editions.

Find it in the Application Servers section here: http://bit.ly/MSLicensingGuides.

SQL Server 2017

Microsoft announce that SQL Server 2017 will be generally available on 2nd October 2017. The blog post announcement is here: http://bit.ly/2xDEo4E and gives you some detail on the (actually quite exciting) new features that will be part of SQL Server 2017.

However, if you’re more interested in a summary, here are the top three things to know from a licensing perspective:

  • A new “Azure Hybrid Benefit for SQL Server” allows customers to re-use existing on-premises SQL Server licences to run database-as-a-service in Azure
  • R Server is renamed “Machine Learning Server for Hadoop” and is now available to all SQL Server Enterprise edition customers as an SA benefit
  • It’s the first version of SQL Server to run on Windows Server, Linux and Docker, and there’s a new “SQL Server on Red Hat Enterprise Linux offer” which gives discounts off both SQL Server 2017 and the operating system to help with migrations

Premium Assurance

Microsoft announce Premium Assurance on 8 December 2016 (http://bit.ly/2hxi0ix) which is a way of adding six more years of product support for either Windows Server or SQL Server.

There’s a useful datasheet which gives more details, but here are the highlights: you need SA to be able to purchase Premium Assurance, and you must purchase it for ALL servers with active SA in an EA, EES or SCE. You also need to acquire Premium Assurance for a product before it goes out of support, and the price will go up over the next few years – from March 2017 it will be 5% of the licence cost rising to 12% from July 2019.

You can find the datasheet in the Core Infrastructure section in our Licensing Guides emporium: http://bit.ly/MSLicensingGuides.

Updated Server Virtualisation VL Brief

There’s an updated (June 2016) “Licensing Microsoft server products for use in virtual environments” Volume Licensing Brief.

It’s updated for Exchange Server 2016 (no changes to the licensing), SQL Server 2016 (Business Intelligence edition removed, requirement to assign a minimum of 4 licences per processor rather than using the Core Factor table) and it references the Product Terms document rather than the Product List and Product Use Rights documents.

Get this updated brief here in the Application Servers section: http://bit.ly/MSLicensingGuides.

BYOL SQL VMs available in Azure Gallery

Microsoft announce a new set of Bring-Your-Own-Licence SQL + Windows virtual machine images in the Azure Gallery.

This means that you can use an image to easily provision a Windows VM with SQL Server, and then use existing Volume Licensing licences with Software Assurance to license the SQL part of the VM.

For more details and some useful pictures, see the Microsoft announcement here: http://bit.ly/1Uf54zu.

APS Licensing Datasheet

Analytics Platform System


There’s a new (June 2016) Analytics Platform System Pricing and Licensing datasheet. What’s that in normal English? Well, this is the Massively Parallel Processing (MPP) appliance for data warehouse workloads which runs (keep with me here) SQL Server Parallel Data Warehouse edition. Bear in mind that when you acquire one of these appliances it’s pre-built, but you still need to purchase licences for the different components.

This datasheet does a good job of explaining the different servers and when Windows Server, System Center and SQL Enterprise licences are required.

Find it here: http://bit.ly/MSLicensingGuides.

SQL Server 2016 Licensing Guides

What’s even more exciting than the launch of a new product? A new set of Licensing Guides of course!

The SQL Server 2016 ones are available in three flavours: a Licensing Datasheet (for a 2-page overview), a Licensing Guide (a left-to-right look across SQL licensing), and a Virtualization Licensing Guide (focussing on various virtualisation scenarios).

Find them all here in the Application Servers section of our (new and improved) Licensing Guides Emporium: http://bit.ly/MSLicensingGuides.

SQL Server 2016 General Availability

Happy SQL Server 2016 General Availability Day!

The June 2016 Product Terms is updated to reflect the 3 main changes in the licensing:

  • Core licences remain but the Core Factor table is no longer used, you just need to assign a minimum of 4 Core licences to each processor
  • BI edition is retired and customers with SA migrate to the special Server/CAL licensed Enterprise edition, and
  • Parallel Data Warehouse deployments are now licensed with Enterprise Core licences

Need to understand the details and consider some real life scenarios?

Book on one of our SQL Server 2016 Licensing School Online courses: http://bit.ly/LSOcourses.