SQL Server 2019 Big Data Nodes


Photo by ThisIsEngineering on Pexels.com

The release of SQL Server 2019 sees the introduction of Big Data Nodes. This new family member aims to help organisations create data lakes, combining big data tools such as Hadoop with SQL Server – all supported by Microsoft.

To run a Big Data Node cluster, you first require a SQL Server Master Instance. This must be running SQL Server 2019 – Standard or Enterprise – with SA and licensed via the per core model.

The licenses on the Master Instance give an entitlement to a certain number of Big Data Node core licenses. For Standard edition it’s a 1:1 ratio, while for Enterprise it’s 1:8 – as an example, a server with 32 cores of SQL Server 2019 Standard w/SA would give rights to 32 cores of Big Data Node, while the same server licensed with Enterprise edition would allow 256 Big Data Node cores. Additional Big Data Node cores can be purchased separately.

The big data nodes can also be deployed in Azure using the Azure Kubernetes Service (AKS).

Microsoft Product Terms: November 2019


Photo by Markus Winkler on Pexels.com

I’ve taken a look at some of the highlights of this month’s Microsoft Product Terms document.

Big news is SQL Server 2019 is here – with a new SKU type and expanded fail-over rights.

We now have “SQL Server Big Data Node (BDN)” – available in 2-core packs via EA & EES. Requires a “master node” of SQL Std/Ent core with SA and includes certain SA rights.

Each SQL Server Ent Core license with SA gives 8 BDN licenses and each SQL Server Std Core license with SA gives 1 BDN license, when assigned to a “master node”.

The updated fail-over info is there too, but I’ll look at that properly in a separate article.

New language that M365 & O365 F1 licenses can only be assigned to users without a dedicated device.

“A Dedicated Device is a computing device used for work with a 10.1” screen or larger, used by the user more than 60% of the user’s total work time during any 90-day period”

F1 licenses are aimed at users who tend not have a device – drivers, nurses, warehouse staff etc. but I know some organisations are looking at them as a way to license traditional office workers and reduce costs. This new language looks to prevent that.

The new Project Plan 1, 3, and 5 licenses are added – only available via CSP. Plan 1 not available in France or South Korea for some reason. 🤔

Terms have been added to cover Azure Spot offers. <– Interestingly, I haven’t seen Microsoft use this term themselves until now. They have referred to them as “low-priority VMs” in Azure, with Spot being a term used by Amazon AWS.

%d bloggers like this: