New Cloud Licensing Limits

Licensing is always a complex discussion with SQL Server. Depending on the way you run it, the edition, the version, whether you've purchased Software Assurance, and more, you might struggle to ensure you are in compliance with Microsoft's terms.

This can be even more complex when you move to the cloud, as sometimes your setup could include a license, and sometimes it doesn't. If you lift-and-shift to cloud VMs, Azure lets you bring your existing licenses with the Azure Hybrid Benefit, which is tempting for organizations that want to get out of the data center business and move their workload to the cloud.

However, that isn't necessarily the same for all clouds. While Amazon lists various ways you can bring your licenses to AWS, Microsoft hasn't felt that was legal. They've noted in 2019 that their "cloud partners" couldn't support workloads on non-SA licenses. I can't quite determine if SA licenses can be used, as lots of information out there is conflicting. Microsoft's FAQ seems to support the idea that you need dedicated hosts, not just any shared VM.

Not all cloud providers count, however. This week Microsoft noted that some cloud providers can let you run your workload by bringing your licenses. These are smaller providers in Europe who filed complaints. Likely these providers can't offer the scale or pricing of GCP, AWS or Alibaba, so they aren't as big a revenue threat as these providers.

I don't know what I think is the right thing, as once I've purchased a license, why does the location or ownership of the VM count? I ought to be able to run the software within the same guidelines in Rackspace, EC2 or GCP just as I would on-premises. However, such is the strange world of software licensing.

If you deal with licensing, I'm sorry, but also, you should note that there are rules and restrictions when you move to the cloud. That's something I see increasingly happening in many organizations, so educate yourself so that you can make the right recommendation. And when you get ready to purchase licenses, think about how SA not only affects upgrades, but also the flexibility of migration.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

There and pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of build vs. buy. In this blog post, Grant Fritchey discusses when you should build, and when you should buy.

If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell.

Rollback scripts are designed to allow us to recover safely from a failed deployment that leaves the database in an indeterminate state. They must check exactly what needs to be reverted before doing so. If you work with an RDBMS that cannot support transaction DDL rollback they are vital. This article proposes a strategy where you create and test a rollback file, at the same time as the forward migration, and reuse it as a Flyway undo script.

Paladin I have sort of a love/hate relationship with wait stats scripts and analysis. Sometimes they’re great to correlate with larger performance problems or trends, and other times they’re totally...

Introduction With the release of SQL Server 2022 R...

Many of the sys.dm_os_ring_buffer entries support ...

What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild your indexes to fix it? At the SQLBits conference, I tried...

At Stedman Solutions, LLC when we do corruption repair it usually means someone has discovered they have corruption, and they call us. If they had good backups and good...

Getting Back to Basics To date, I’ve always used the MongoDB API for Cosmos DB when demonstrating PolyBase. This is true in PolyBase Revealed, as well as blog posts...

It is highly recommended that you try to evenly distribute the work among multiple tasks so every task produces a single output file and job is completed in parallel.

It is quite typical to write the resulting data in...

This article explains Azure SQL Database Geo Restore using geo-replicated backups for disaster recovery. Introduction Any business continuity and disaster recovery plan must include database backups to protect your...

We received some support cases when customers encounter the error below while trying to add an AAD security group to their Azure SQL Database or Azure SQL managed instance....

In this article, we will learn how we can create t...

Reading Time: 6 minutes In this post I want to co...

If I would write a book on becoming a technical pr...

There are employment opportunities at every experience level, in a variety of occupation categories, with software developers and engineers the most in-demand, a CompTIA analysis has found.

Is your company hiring for a database position as of September 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid...

Microsoft has acknowledged that customers may experience domain name system...

I was honored to speak at Future Data Driven last year. This year has a great lineup with some fantastic sessions on data related topics. Register today for the... The...

This webinar will share top tips when evaluating monitoring tools and vendors, the common pitfalls when implementing a new solution, and how you can demonstrate Return on Investment (ROI) to the business post-purchase.

Every organization must perform data governance. This requires planning, oversight, and control over the management, security, resilience and quality of data and over the use of data by the...

Let’s say you’re planning to present a large table of information and you want the user to be able to filter based on the top or bottom X number of records. Due to the size of the dataset we would like the customer to have the ability to filter based on more than one column for their comparison

Football has finally come home for the England wom...

Microsoft’s Azure Managed Grafana service that launched in preview back...

Learn how you can move your data through different...

What is horizontal partitioning in SQL Server?

Learn how to build graph node and edge tables using Azure Data Studio in this step-by-step guide.

In this article, we learn about different data models to use for large document data stores such as Embedded, Composite Key, Inverted Index, and Single Table.

One common comment I've heard at various conferences and customer interactions is, "setting up Always On availability groups (AGs) on pacemaker takes very long, has multiple steps and commands...

The Lenovo ThinkPad X1 Fold has been reimagined wi...

RELATED and its companion function RELATEDTABLE, a...

Why and when to use RELATED and its companion func...

Classic Espionage Like query compilations, query recompilations can be annoying. The bigger difference is that even occasional recompiles can introduce a bad query plan. If your monitoring tools or scripts are...

very now and then when I have a Power BI project of interest to me, I like to create a video of the end to end process of building a new report. This allows me to share some “warts and all” real-world examples of how to go about building a Power BI report.

So far in this series (see part 1, part 2 and part...

Learn how to leverage the functionality of Field P...

In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing an AAS database. The flow referenced an...

Want to optimize performance in Power BI? Of course, you do! In order to do that, you need to understand the two caches that are at play and how...

I see a lot of Power BI projects that we are asked to fix or performance tune, and at least nine times out of ten, the answer is that...

Every now and then when I have a Power BI project of interest to me, I like to create a video of the end to end process of building...

You are excited about Field Parameters in Power BI, but then realize you can't use conditional formatting with them. What the french toast! Don't despair! Patrick and Adam have...

Introduction These are my SQL Server Diagnostic In...

We have released an update to Microsoft.Data.SqlClient, version 2.1.5. The update addresses a few issues that are important to our customers.   Updates in Microsoft.Data.SqlClient 2.1.5 include:   Fixed Added CommandText length validation when...

General availability enhancements and updates released for Azure SQL.

Important Note: I have not yet tested this version of the Integrated Services Extension in Visual Studio 2022. On 28 Jul 2021, the Microsoft SSIS Team released an update...

We are excited to announce the General Availability (GA) of enabling Zone Redundancy for Azure SQL Hyperscale databases. The zone redundant configuration utilizes Azure Availability Zones to replicate databases across multiple...

New general-purpose and memory-optimized Azure VMs, featuring Ampere Altra Arm-based processors, engineered to efficiently run scale-out, cloud-native workloads, are now available.

During the last 5 years, I have accumulated various scripts with (personal) convenience functions for network analysis and I also implemented new methods from time to time which I could not find in any other package in R. The package netUtils gathers all these functions and makes them available for anyone who may also needs to apply “non-standard” network analytic tools.

The previous post showcases the rrapply() function in the minimal rrapply-package as a revised and extended version of base rapply() in the context of nested list recursion in R.

Github is collecting various images on their Insta...

At Microsoft, we understand that designing for inclusivity opens our experiences and reflects how people adapt to the world around them. In this new release of SSRS, we have...

Ever wonder how fast people are adopting new versi...

Back in the SQL Server 2019 days, I laid out a post which covered a really annoying bug around Windows authentication and PolyBase. The upshot is that SQL Server...

Well, it’s long overdue that I left the comfort ...

The US government and the Open Source Security Fou...

This is a fun story, detailing the hack a group of high school students perpetrated against an Illinois school district, hacking 500 screens across a bunch of schools. During the...

But one issue that lets websites overwrite content on a user's system clipboard appears unfixed in the new Version 105 of Chrome.

Apple continues a staged update process to address a WebKit vulnerability that allows attackers to craft malicious Web content to load malware on affected devices.

Come learn how to start using your existing Azure SQL Database using Entity Framework Core and EF Core Power Tools in this episode of Data Exposed: MVP Edition with...

We are pleased to announce new features in Kusto Explorer (Desktop version of Azure Data Explorer Web UI) to help you be more productive in managing and executing queries

Fun With KQL - Between

In this article, we look at various ways to conver...

In this tip we look at the impact of running SQL Server processes in smaller batches instead of one large operation.

In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows.

I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will ... Continue reading The post SQL Homework – September 2022...

Microsoft has announced some important changes to ...

A new report finds executives are focusing on grow...

HP’s higher mix of commercial PCs has served as a shield from the plunging consumer market in recent months, but the company is also starting to see a slowdown...

The Lenovo Glasses T1 create a virtual monitor to ...

IT strategy and planning are becoming increasingly complex as hybrid work changes previous straightforward projects and tasks.

Documenting your database and code is such a pain ...

After I bought my 1988 Porsche 944 Turbo off Cars ...

Microsoft has announced the release of version 1.71 of its...

In this episode of Data Exposed with Timi Oshin and Anna Hoffman, get an introductory demo to the Table Designer feature in Azure Data Studio, and how you can...

This is the third in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this article for... The...

This article deploys a SQL Server container using Azure Kubernetes Services (AKS). Introduction to Kubernetes Kubernetes is a portable, open-source, extensible platform for managing and orchestrating containers. It abstracts...