Very Hot Patches

Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.

Dropping the External Table

Cross Database Queries in Azure SQL Database

Cross database queries in Azure SQL Database aren't as straightforward as you might think, but they aren't hard to implement. Follow along to learn how to implement them.

Technology Flows Downstream

The technologies that we see in other data platform products sometimes flow to SQL Server.

Serverless Databases

A new feature for Azure SQL Database: serverless.

Five Ways to Migrate Your On-Premises SQL Database to Azure

There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in...

A short Azure SQL Database Edge explainer

On Thursday 2 May 2019, Microsoft announced a new edition of SQL Server, targeting Internet of Things (IoT) edge devices. That means SQL Server can now run almost anywhere....
The...

Azure SQL Database User

Building Azure SQL Db with Terraform with Visual Studio Code

I have been using Terraform for the last week or so to create some infrastructure and decided to bring that knowledge back to a problem that I and others...

In Azure SQL DB, what does “The connection is broken and recovery is not possible” mean?

All it really means is, “Click Execute again, and you will be fine.”