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
@matt40k yeah, already been on msdn. Can't believe we're being made to wait!!!
— Dave Kerby (@davekerby) June 1, 2016
I spotted something odd.
— Matt Smith (@matt40k) June 6, 2016
Now, in SQL Server terms there are two types of licensing
- Server license + CALs
- Cores (processors)
Expect 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
- SQL Server 2016 Enterprise Core is limited to 20 cores and is for legacy license holders.
- SQL Server 2016 Enterprise isn’t limited.