SQL Server 2022 – price rises & licensing changes


Photo by Pixabay on Pexels.com

SQL Server 2022 is now generally available and is, in Microsoft’s words, the “most Azure enabled release” so far.

https://cloudblogs.microsoft.com/sqlserver/2022/11/16/sql-server-2022-is-now-generally-available/

There are a few licensing updates and changes to be aware of with SQL Server 2022 as well as a price increase:

Flexible Virtualisation Benefit

Both licenses with active SA and active subscriptions can now be deployed with any Authorized Outsourcer – that is, anyone who isn’t a Listed Provider (Amazon, Google, Alibaba). However, don’t forget that License Mobility through Software Assurance rights still exist (via SA) which allow you to put software on the servers of an “Authorised Mobility Partner” – and the Listed Providers are eligible for this.

Furthermore, when licensing SQL Server Standard or Enterprise by virtual OSE, if you have active SA you can run an unlimited number of containers containing SQL Server within that virtual OSE.

Related to this, Microsoft have made another change that will cause some issues for certain customers. Licensing a virtual machine based on the number of virtual cores now requires Software Assurance with SQL 2022 and, as that is the only option available for licensing virtual machines with SQL Server Std 2022 (i.e. you can’t license the physical hardware to then run VMs), this means that Software Assurance is a requirement if you have virtual machines with SQL Server Std per core.

Machine Learning removal

Looking at the Product terms, it appears that Microsoft have removed the rights for SQL Server Enterprise customers to use:

  • Machine Learning for Window or Linux
  • Machine Learning Server for Hadoop

PAYG licensing

Enabled via Azure Arc, this new billing model enables organisations to pay for SQL Server on a monthly or hourly basis:

https://www.microsoft.com/en-us/sql-server/sql-server-2022-pricing#tabx58bf128753034847a6690344bce5c2d7

The servers must be connected to Azure Arc to use this option. For 2022, the Arc connection is a default part of the setup process while for SQL 2014 and above, it will be enabled via a capability within the Azure portal which is, according to Microsoft, coming soon. This seems to suggest that PAYG isn’t available with SQL 2012 or earlier which makes sense, given they’re all out of support.

See more on SQL PAYG here and the pricing is here.

New pricing

Microsoft have confirmed that SQL Server 2022 Standard, Enterprise, and Web pricing will increase by 10% from January 2023 – including public sector.

Microsoft Financial Results: Q1 FY23


Photo by Essow on Pexels.com

Let’s take a look at Microsoft’s financial results for the first quarter of FY23.

  • Overall revenue was $50.1 billion, an increase of 11%.
  • Operating income was $21.5 billion, up 6%…
  • but Net income was down 14% to $17.6 billion
  • Operating expenses were up 15% to $13.2 billion.

Looking at the individual divisions we see:

Productivity & Business Processes

Overall revenue up 9% to $16.5 billion and within that:

  • Office 365 Commercial revenue up 11%
  • LinkedIn revenue up 17%
  • Dynamics 365 revenue up 24%

Intelligent Cloud

Overall revenue was up 20% to $20.3 billion and within that:

  • Azure growth of 35%

Still a good increase but noticeably slowing down from previous quarters. Microsoft note that cloud margins are down primarily due to increased energy bills.

More Personal Computing

Overall revenue decreased slightly to $13.3 billion and within that:

  • Windows OEM revenue decreased 15%
  • Devices revenue increased 2%

Earnings Call

  • Satya Nadella was quick to point out the hybrid/multi-vendor approaches possible with Azure – talking about SAP & Oracle in the first couple of paragraphs.
  • PowerApps has almost 15 million monthly active users (MAU), a 50% year on year increase, and Power Automate has reached 7 million MAU.
  • Nadella also talked about Teams and how chat has overtaken email as where the average user spends their time. He also said:

“Teams is becoming a ubiquitous platform for business process.”

and shared that the number of enterprise users running 3rd party/custom apps has increased 60% year over year.

  • Microsoft Viva already has 20 million MAU – just the start of things for this line-up I’m sure.
  • Amy Hood spoke about strong E5 momentum being driven by security, compliance, and voice products and an increase in Average Revenue Per User (ARPU) too.
  • Nadella also stated:

we are going to optimize for long-term customer loyalty by proactively helping them optimize [Azure] spend

This follows on from what he said last quarter (and also matches what AWS recently said) that helping customers waste less will ultimately help them spend more.

Further Reading

See all the info, slides, and transcripts here.

Azure Hybrid Benefit for Azure Kubernetes Service (AKS)


Photo by Chanaka on Pexels.com

As well as the Azure Stack HCI news, Microsoft have also added Azure Hybrid Benefit (AHB) for AKS (Azure Kubernetes Service).

How it works

This benefit is available for Windows Server Standard and Datacenter (both with SA) and also CSP server subscriptions. Hosts must be Windows Server 2019 (and later) or Azure Stack HCI

Each Windows Server core license w/SA allows use of 1 virtual core of AKS. The AKS AHB is additive, meaning the licenses can be used to cover on-prem/Azure workloads AND to use AKS. You can see more info here.

Azure Hybrid Benefit for Azure Stack HCI


Photo by Alexander Grey on Pexels.com

Ignite 2022 saw Microsoft expand the Azure Hybrid Benefit (AHB) to grant access to Azure Stack HCI.

What is it?

It is only available for Enterprise Agreement customers and only applies to Windows Server Datacenter licenses w/SA; licenses must be allocated for all physical cores in the Azure Stack HCI cluster. Licensing in this way allows you to use unlimited Windows Server base instances across the cluster. Furthermore, as per the Product Terms, the “dual-use” rights do not apply so licenses can be used as Windows Server licenses OR as Azure Stack HCI licenses.

It is activated in the Azure portal:

I question the phrasing in the Microsoft announcement here as it says that customers “exchange” their Windows Server licenses to get Azure Stack HCI. This suggests that they are somehow transformed from one type into another but that doesn’t appear to be the case – as this is via AHB, it is simply an additional right that doesn’t change the underlying licenses. As with allocating Windows Server licenses to “regular” Azure, it seems one can re-assign from Azure Stack HCI licenses back to Windows Server Datacenter licenses following the 90-day rule.

Given the increasing level of focus on CSP and the MCA, it’s interesting to see that it is restricted to Enterprise Agreement customers only. It not being made available for Open Value and MPSA customers is, rightly or wrongly, business as usual these days but CSP has been getting a lot of shiny things lately.

Microsoft Azure Savings Plans


Photo by maitree rimthong on Pexels.com

This new way of paying for Microsoft Azure was announced at Microsoft Ignite 2022 and seems to bear more than a passing resemblance to Amazon AWS Savings Plans. The similarities are probably a bonus for customers, meaning you don’t have to learn 2 totally different IaaS cloud payment options.

What is it?

Azure Savings Plans is, to some degree, the next step beyond Reserved Instances (RI). This new offering comes with a spend commitment on an hourly basis (over 1 or 3 years) and gives discounts over the PAYG pricing on resources where you have consistent usage. Eligible compute services include:

  • Virtual Machines
  • Dedicated Hosts
  • Containers
  • Azure premium functions
  • Azure app services

How it works

Savings Plans discounts are applied automatically (starting where the largest discount exists) to any eligible services on spend up to the hourly commitment i.e. £7 per hour. Any spend over that amount is then charged at PAYG pricing so, just as with Reserved Instances, accurate understanding of current and future usage is a must.

They only apply to infrastructure costs but can be combined with Azure Hybrid Benefits for Windows Server & SQL Server etc.

How to buy

Savings Plans are available for Enterprise Agreements, Microsoft Customer Agreements (MCA), and Microsoft Partner Agreements.

Enterprise Agreements

  • EA admins with write permissions can directly purchase savings plans from Cost Management + Billing > Savings plan. No specific permission for a subscription is needed.
  • Subscription owners for one of the subscriptions in the EA enrollment can purchase savings plans from Home > Savings plan.
  • Enterprise Agreement (EA) customers can limit purchases to EA admins only by disabling the Add Savings Plan option in the Azure portal. Navigate to the Policies menu to change settings.
  • Notifications are sent to EA administrators and EA notification contacts.
  • Users added to a savings plan using Azure RBAC (IAM) permission don’t receive any email notifications.

Microsoft Customer Agreements

  • Customers with billing profile contributor permissions and above can purchase savings plans from Cost Management + Billing > Savings plan experience. No specific permissions on a subscription needed.
  • Subscription owners for one of the subscriptions in the billing profile can purchase savings plans from Home > Savings plan.
  • To disallow savings plan purchases on a billing profile, billing profile contributors can navigate to the Policies menu under the billing profile and adjust Azure Savings Plan option.

Microsoft Partner Agreements

Partners can use Home > Savings plan in the Azure portal to purchase savings plans for their customers.

Savings Plans can be paid for upfront or on a monthly basis, and you don’t pay any more for choosing to spread payments. That said, monthly prices may vary on MCA due to impact of exchange rates.

If you currently have Azure Reserved Instances but would like to move to Savings Plans, you’re in luck – you can trade in Reservations for Savings Plans. The hourly commitment of the new savings plan must be greater than the leftover payments that are cancelled for the returned reservations. That said, not all reservations can be traded – those not eligible are:

  • Azure Databricks reserved capacity
  • Synapse Analytics Pre-purchase plan
  • Azure VMware solution by CloudSimple
  • Azure Red Hat Open Shift
  • Red Hat plans
  • SUSE Linux plans

Beware – Savings Plans cannot be cancelled, exchanged, or refunded. Automatic renewal of Savings Plans isn’t on by default but can be activated if you so wish.

Setting the scope

You can set the scope of Savings Plans to restrict where the savings can be applied. Your options are:

  • Shared
  • Single subscription
  • Management group
  • Single resource group

Reporting

Microsoft have provided information to help with reporting and cost analysis including how to identify wasted spend and how to access the CSV files here.

To get this, and more, in your inbox each month – sign up to my newsletter here!

Further Reading

Microsoft announcement

Azure Savings Plans document hub

Manage Savings Plans

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 Financial Results: Q3 FY22


Photo by John Guccione http://www.advergroup.com on Pexels.com

Microsoft’s financial results for Q3 FY22 (Jan – Mar 22) are in and, once again, they’re showing strong growth in all their key focus areas. They also listed several big name customers that they’re working with including:

  • Bridgestone
  • Lufthansa
  • Fujitsu
  • Woolworths
  • Cracker Barrel
  • Heineken

and called out Boeing, Heinz, and Westpac among customers making “strategic” Azure commitments.

Satya Nadella always hits us with a good quote during the earnings call and this quarter’s was:

“The last two years have proven that every organization needs a digital fabric that connects the entire organization”

Let’s take a look at some of the numbers:

Overall

Revenue = $49.4 billion – up 18%

Operating income = $20.4 billion – up 19%

Really strong top line numbers as always – remember, this is for just 3 months!

Productivity & Business Processes

Revenue = $15.8 billion – up 17%

  • Office 365 Commercial up 17%
  • Dynamics 365 up 35%
  • LinkedIn up 35%

Microsoft saw growth in SMB and frontline SKUs as well as increase in Revenue Per User – a key SaaS metric.

Office on-prem revenue was down 28%, continuing the downwards trend that we’ve been seeing for a couple of years now. It was noted as well that the end of Open Licensing has caused a drop in transactional license sales during the last quarter.

Intelligent Cloud

Revenue = $19.1 billion – up 26%

  • Azure (and other cloud services) up 46%
  • Server products up 5%

Another strong showing from Azure…with the number of $100 million Azure deals more than doubling over the previous year.

The server products increase includes Window Server & SQL Server in hybrid use cases (as well as Nuance) and again Microsoft mentioned the impact of Open Licensing’s end.

What else did we learn?

  • Satya Nadella once again called out the performance of Cosmos DB, with 100%+ YoY growth for 3 quarters in a row.
  • Power Platform, as a family, was up 72% year on year.
  • Microsoft Viva has over 10 million monthly active users.

Overall this is another great performance from Microsoft, giving them good momentum as they move into their Q4 (April – June) which is always a busy time of year. It will be interesting to see the full FY results in July for sure!

Microsoft Defender for Cloud pricing


Photo by Pixabay on Pexels.com

Microsoft Defender for Cloud is a relatively new product name – created through a combination of “Azure Defender” and “Azure Security Center” – and is Microsoft’s solution for “cloud security posture management” (CSPM) and “cloud workload protection” (CWP).

It works not only in Azure but also Amazon AWS and Google GCP and hybrid scenarios via Azure Arc.

Licensing & Pricing

The main thing to understand is that Microsoft Defender for Cloud isn’t one thing, it is an umbrella for several separate products that all have their own costs.

Resource TypePrice
Microsoft Defender for Servers Plan 1£0.006/Server/hour
Microsoft Defender for Servers Plan 2£0.016/Server/hour
Included data – 500 MB/day
Microsoft Defender for Containers£0.0072/vCore/hour
Microsoft Defender for SQL on Azure£0.016/Instance/hour
Microsoft Defender for SQL outside Azure£0.012/vCore/hour
Microsoft Defender for MySQL£11.420/Instance/month
Microsoft Defender for PostgreSQL£11.420/Instance/month
Microsoft Defender for MariaDB£0.016/Instance/hour
Microsoft Defender for Storage£0.016/10K transactions
Microsoft Defender for App Service£0.016/App Service/hour
Microsoft Defender for Key Vault£0.02/10K transactions
Microsoft Defender for ARM£3.046/1M API calls
Microsoft Defender for DNS£0.533/1M Queries
Microsoft Defender for IoT agentless monitoring£107 per month per 100 monitored devices
https://azure.microsoft.com/en-gb/pricing/details/defender-for-cloud/

Microsoft Defender for IoT agentless monitoring covers existing environments and is deployed on-premises. It can be connected to Microsoft Sentinel with no additional Sentinel charges – but it will require an IoT Hub which costs between £7.61 – £1903.17 per month.

For new IoT devices deployed via Azure IoT Hub, Defender pricing is:

SolutionPrice
Defender for IoT for devices managed by IoT Hub – by device£0.0008/month
Defender for IoT for devices managed by IoT Hub – by messages£0.153/25K transactions

Both of these offer free usage for the first 30 days and then the pricing kicks in, so be aware of what things people are turning on within your organisation.

Microsoft Defender for Cloud Free Tier

This is enabled on all Azure subscriptions when you visit the Defender for Cloud section of the Azure portal and includes:

  • Continuous assessment
  • Security recommendations
  • Secure Score for Azure
  • Secure Score for AWS

Further Reading

The Microsoft Defender for Cloud page is here.

Microsoft Defender for Servers


Photo by Samuel Jeru00f3nimo on Pexels.com

Microsoft Defender for Servers is available as one of the workload components of Microsoft Defender for Cloud and is now split into Plan 1 and Plan 2.

Microsoft Defender for Servers Plan 1

The features contained in Plan 1 are:

  • Auto onboarding for resources in Azure, AWS, and GCP
  • Microsoft Threat & Vulnerability management
  • Use of Defender for Cloud or M365 Defender portal
  • Integration of Defender for Cloud and Defender for Endpoint

Microsoft Defender for Servers Plan 2

Additional capabilities in Plan 2 include:

  • Log Analytics – with 500MB free
  • Security policy & regulatory compliance
  • Vulnerability assessment
  • Threat detection
  • Just in Time VM access
  • File integrity monitoring
  • Adaptive network hardening
https://docs.microsoft.com/en-us/azure/defender-for-cloud/defender-for-servers-introduction

Pricing

Under the Azure meter, the prices are listed here as:

  • Plan 1 = £0.006 per server per hour
  • Plan 2 = £0.016 per app service per hour

Volume Licensing

If you have 50 or more combined licenses of:

  • Microsoft Defender for Endpoint
  • Windows E5/A5
  • M365 E5/A5
  • M365 Security USLs

you can acquire Microsoft Defender for Endpoint (Server) under EA/EAS/MCA/EES agreements.

If you have these licenses and then choose to cover the same servers with Microsoft Defender for Cloud (the new name for Azure Security Center + Azure Defender), you will be eligible for a credit towards the cost of the latter.

Resources

Microsoft Docs page

Microsoft SQL Server 2012 end of support


Photo by eberhard grossgasteiger on Pexels.com

SQL Server 2012 goes end of support on July 12, 2022 – that’s about 10 weeks from the time of writing! This means even security updates from Microsoft will no longer be provided to customers running this software – a situation organisations really don’t want to find themselves in.

It only seems like 5 minutes since this was the situation with SQL Server 2008 (it was actually almost 4 years ago!) which causes headaches for a lot of organisations. I’d say that, based on conversations at conferences and training sessions etc., SQL Server 2012 is going to be at least equally painful as many businesses seem to have got to 2012 and then no further, considering it to be much more modern than 2008.

If your business is still running SQL Server 2012 – what are your options?

Remain on-premises

Assuming you want to remain up to date on security patches (which I’d say you do!), you’ll need to acquire Extended Security Updates (ESU) from Microsoft which will give you 3 more years of security updates. That however, comes at a price:

  • Year 1 = 75% of SQL Server license price
  • Year 2 = 100% of SQL Server license price
  • Year 3 = 125% of SQL Server license price

Let’s say you have a 4-core SQL Server 2012 Std box – approx. license cost of £5,000. That will mean:

  • Year 1 = £3,750
  • Year 2 = £5,000
  • Year 3 = £6,250

3 year total = £15,000

Migrate to Azure

ESUs are included free of charge for workloads running in Microsoft Azure VMs – including “regular” Azure VMs as well as:

  • Azure Dedicated Host
  • VMware on Azure
  • Nutanix Clusters on Azure
  • Azure Stack HCI/Hub/Edge

You can save a big amount of money through not having to pay for the ESUs…but cloud migrations come with their own set of costs…as well as benefits.

If you’ve not already made a decision on this, please gather the relevant people together and discuss the option. While both the above options can seem expensive, I’d suggest they’re nothing when compared to the cost of a security breach/ransomware attack.

You can see more info in the Microsoft blog post here.

%d bloggers like this: