Microsoft Product Terms: December 2023


Photo by Markus Winkler on Pexels.com

The final Product Terms update for 2023 is here:

Power Virtual Agents replaced with Copilot Studio

ClipChamp SKUs added:
ClipChamp Std standalone USL
ClipChamp Premium standalone USL
ClipChamp Premium add-on* license for M365 E3/E5/BS/BP
*ClipChamp (Std) added to M365 E3/E5/BS/BP

Update to terms around add-on USLs being purchased on same agreement. It now says “Add-on User SLs, as specified in the Add-ons section of each respective product section,”

New Failover rights for Azure SQL database = “One geo-secondary specifically for disaster recovery purposes

It has also been spotted that M365 Business Standard and Business Premium have been removed from the license prerequisites for Copilot for Microsoft 365:

Is this a temporary removal to prevent confusion as it is isn’t currently available for those licenses…or is it a sign that M365 Copilot won’t be available for SMB customers? I feel it’s the former but you never know!

Microsoft Product Terms June 2022


Photo by Markus Winkler on Pexels.com

Some new M365 F5 Security bundles made available – further expanding what’s possible for protecting frontline workers.

Microsoft Sustainability Manager added. This is what we’ve been calling Microsoft Cloud for Sustainability…it seems that will be now an umbrella term and Sustainability Manager will come under that.

Clarification that the SQL Server Enterprise SA benefit of running Power BI Server applies in a fail over OSE too

Tidying up of various clauses and terms.

No mention of the major changes they announced for cloud BYOL rules around Windows Server, Windows desktop, and Office.

Microsoft Intelligent Data Platform


At Microsoft Build 2022, they have introduced us to the new Intelligent Data Platform.

They say this will help in “removing points of friction between your databases and analytics systems while automatically mapping and governing your full data estate” and allow developers/organisations to “Focus on building innovative apps—and spend less time managing your data“.

Is it a new product?

No – instead it’s a collection of existing products that MS position as forming a better, cohesive eco-system for organisations. Those products are:

  • Azure SQL
  • Azure Cosmos DB
  • SQL Server 2022
  • Azure Arc
  • Azure Synapse Analytics
  • Power BI
  • Azure Machine Learning
  • Microsoft Purview

The latter enabling comprehensive governance of data across all these different locations, products, and use cases.

For many organisations across a variety of verticals, data is the key to success. However, given the increasing regulatory pressures and growing threat of cyber attacks – not managing that data effectively can be one of the largest risks a business faces. The dual concept of helping organisations better connect their data to extract more useful insights more quickly AND securing all that data will surely seem a particularly attractive offering for a lot of customers. Several other organisations, including Amazon and Google, are heavily focusing on data too – it’s the next frontier for winning/losing customers in many ways – and I’m sure Microsoft will continue to enhance this area of their business. I’m also sure they will be selling this concept, and the underlying products, heavily during renewals and customer briefings etc.

Further Reading

Intelligent Data Platform page

Microsoft IDP announcement

Microsoft Product Terms – March 2022


Photo by Markus Winkler on Pexels.com

Again, not a huge amount of change in the Microsoft Product Terms for March 2022:

Microsoft 365 Privacy Management has been rebranded “Priva”…I thought they might change their mind on this one 😂 I guess they wanted to make sure there was something people could confuse with Viva?!

Expanded pre-requisite licenses for Cloud for Healthcare add-on

Azure Virtual Desktop per user access promo extended to March 31st, 2022 (although the section doesn’t appear to have actually been updated)

SQL Server Big Data Nodes have been retired – anything other than the “core” SQL editions just never seems to quite work does it?

Updated “no cancellations after 72 hours” terms for online services under CSP NCE

Microsoft extend Extended Security Updates


Image by PublicDomainPictures from Pixabay

Extended Security Updates (ESUs), available for Windows Server 2008/R2 and SQL Server 2008/R2, were introduced in 2019 to extend available security support for 3 more years beyond the end of the products’ extended support periods.

It’s now less than 12 months until the end of the ESU period for SQL Server 2008/R2 and Microsoft have announced they will be providing 12 additional months of cover – but only for workloads running in Azure. This will also apply to Windows Server 2008/R2 – the end of ESU dates are:

  • SQL Server 2008/R2 – July 12, 2022
  • Windows Server 2008/R2 – January 10, 2023

End of support for 2012 Server versions

They have announced the availability of ESUs for the 2012/R2 releases of SQL Server and Windows Server. Extended Support for these ends:

SQL Server 2012 – July 12, 2022

Windows Server 2012/R2 – October 10, 2023

It’s now less than 12 months until SQL Server 2012 goes out of support so if you’re using that within your organisation, you need to come up with a plan to:

  • Upgrade on-premises
  • Migrate to Azure for free ESUs
  • Budget to purchase on-premises ESUs

See more info from Microsoft here.

Microsoft Product Terms: September 2020


Photo by Markus Winkler on Pexels.com

Only a few additions again this month but a couple are pretty interesting.

Azure DevOps Server 2020 is added.

Dynamics 365 Sales Premium is added. This is a new SKU that combines the “Sales Enterprise” and “Sales Insight” licenses for £101.80 per user per month – a saving of £7.50 pupm. Naming wise – I’m not sure that having an “Enterprise” SKU inside a “Premium” SKU really makes sense tbh!

Azure SQL Edge is added. This is a new variant of SQL made for the cloud world with features including:

  • Support for ARM architecture
  • Built-in data streaming
  • Network bandwidth optimisation
  • Designed to run in containers

I’ve taken a look at it here.

Azure Stack Edge appears too – this is a physical device you keep on-premises, like a branch office or field location, to “filter, analyse, and transform your data before it moves to Azure”. Lose/damage one and it’s a $40,000 charge!

Azure SQL Edge – what is it?


Photo by Brett Sayles on Pexels.com

A new variant of SQL – Azure SQL Edge – is available in public preview and was added to the Product Terms in September 2020.

What is it?

This new flavour of SQL is made for the emerging, growing world of the cloud and edge computing – something of a focus for Microsoft over the last couple of years. Azure SQL Edge is based on SQL Server for Linux and, although it contains only a subset of the full functionality, it also includes features not found in SQL Server for Linux or Windows.

It supports both Intel and ARM processors and runs in containers, currently the only supported scenario is Docker hosts running Ubuntu 16.04 LTS or 18.04 LTS. New features include built-in data streaming and in-database machine learning.

When would you use it?

Microsoft say it is aimed at “edge scenarios” – primarily Internet of Things (IoT) – and it allows data to be analysed and processed before it gets to the central infrastructure; this can lead to faster results and also reduced cloud and network bandwidth utilisation. This latter point is an often overlooked aspect of working with the cloud – more data moving around more places means more network usage and, in many cases, more cost too.

“You don’t need an army of database administrators to install and manage SQL Edge on all your edge devices”

As Azure SQL Edge is container-based, you can deploy it from one portal and then simply update the container as needed. If this is indeed the case, it will help with the “do more with less” approach that comes with cloud – where you can easily end up with many more servers and assets than on-premises, without a matching increase in head count!

Pricing

It’s in Public Preview at the moment, meaning it can be used at no cost (in areas where Azure IoT Edge is available) and more details on pricing and purchase model will be released once the preview is over.

*Update – Feb 2025*

Unfortunately, Azure SQL Edge is being retired by Microsoft as of September 30th, 2025.

Microsoft recommend migrating to:

  • SQL Server Express
  • SQL Server Standard
  • SQL Managed Instance enabled with Azure Arc

None of which are particularly similar to the Edge edition.

See the retirement notice here – https://azure.microsoft.com/en-gb/updates?id=azure-sql-edge-retirement

Further Reading

Azure SQL Edge overview

Microsoft Product Terms: August 2020


Photo by Markus Winkler on Pexels.com

Nothing too major this month, as expected:

  • The Teams Advanced Communications SKU has been added
  • There are a few updates to SQL Hybrid Benefit info for Server Subscriptions
  • Added extra Power Platforms info covering:
    • Purchase minimums
    • Extended Use Rights for Portals
    • Additional pre-requisites

Nothing new for Power Platform, really just moving key info from the licensing guide to the Product Terms – which is the way it should be.

Microsoft Product Terms: June 2020


Photo by Markus Winkler on Pexels.com

June is the last month of Microsoft’s financial year but they’re still made a few changes worth noting in this month’s Product Terms:

  • 5 year reservations for Azure VMs are added – with a 35% early termination fee
  • Azure Hybrid Rights for SQL have been expanded so now:
    • on-premises SQL Server Standard licenses can be used to run SQL Server Enterprise VMs in Azure
    • on-premises SQL Server Enterprise licenses can be used to run SQL Server Standard VMs in Azure
  • Changes to the eligibility for Office 365 and Microsoft 365 F1 & F3 licenses

SQL Server

The core conversion ratio is different for the two new scenarios:

4 x SQL Server Std on-prem cores w/SA = 1 x SQL Server Ent Azure core

1 x SQL Server Ent on-prem core w/SA = 4 x SQL Server Std Azure core

You can see the above table, and the info, on pages 54-54 of the June 2020 Product Terms.

F1/F3 changes

Microsoft have again changed the rules around who is eligible for a “Firstline” SKU. The new requirements are that to qualify for an F1/F3 license a worker must satisfy at least one of these conditions:

  • Uses a primary work device with a single screen smaller than 10.1”
  • Shares their primary work device with other qualifying Microsoft 365 or Office 365 Firstline Worker licensed users, during or across shifts
    • Other licensed Microsoft Firstline Worker users must also use the device as their primary work device
    • Any software or services accessed from the shared device requires the device or users to be assigned a license that includes use of those software or services

The previous guidance, updated in November 2019, was:

“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.”

These new rules should make it a bit easier for everyone to police but, for organisations already licensed for F1/F3 prior to June 1, 2020, you can continue to license based on the previous rules until your next renewal.

Microsoft Product Terms – January 2020


Photo by Markus Winkler on Pexels.com

Nothing major but a couple of interesting SQL Server bits:

1) A clause that, if you’re using SQL in Azure via Azure Hybrid Rights or DR rights, you must indicate it in the portal/API.

2) If you acquire SQL 2017 from an OEM before March 31, 2020 – you can add Software Assurance within 90 days of purchase.

That first addition feels audit related doesn’t it? While it makes sense that organisations indicate where they’re using their licenses and which Software Assurance benefits they’re using etc. – it definitely feels like Microsoft are getting things lined up for the next generation of license compliance audits which will look at cloud environments too.

Also, slightly interestingly, the Online Service Terms (OST) won’t be published until January 8th. Whether this is because people are still on holiday or due to a major change being announced – we’ll have to wait and see! 😊