Enterprise vs Enterprise Core

Categories: Blog Business Intelligence Microsoft SQL Server

This month saw the release of SQL Server 2016, which from a BI\Report point of view is huge. Once we had access to it

yeah, already been on msdn. Can't believe we're being made to wait!!!

— Dave Kerby (@davekerby) June 1, 2016

I spotted something odd.

So whats the diff? Enterprise is only core licensed - https://t.co/2NgZG7siUD #sqlhelp @sqlserver @SQLServerBI pic.twitter.com/SP8OC5eLvD

— Matt Smith (@matt40k) June 6, 2016

Now, in SQL Server terms there are two types of licensing

Except for Enterprise, you can only get Core licenses.

The next question was, have they made a edition for Windows Server Core, a cut-down version – but the files sizes are the same, so this was unlikely, Microsoft also hadn’t made any statement about a cut-down version (which you’d expect), so again, this was unlikely.

Once again, Twitter came to the rescue, more precisely Joey D’Antoni did. The answer is legacy. Any old Microsoft licensing agreement with software assurance (SA) can get the latest version. This means that anyone who had an old SQL Server Enterprise Server\CAL license is now on the core based licensing – there are a few gotchas which Joey refers to – your still limited my the number of CALs, but your also limited to a max of 20 cores.

So in short