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

Creating logins and users in Azure Database

Azure Database is the PaaS solution for SQL Server databases, on a previous post we have discussed how to create one.On this post, I want to show you how...
The...

Tuning Azure SQL Elastic Pools

The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
The...

Enterprise-scale Backup for SQL Server Databases

More and more organizations are moving to the cloud to leverage the key benefits of agility and reduced overall cost. Its likely that at some point in time, your SQL Server will manifest as either of the three implementations in Azure.

Overview of Azure SQL Database Performance Monitoring

Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment. One of the primary concerns related to this transition is diminished level of transparency providing insights into performance of cloud-resident workloads. Fortunately, with Azure SQL Database, you have a wide range of options that address this concern, allowing you to identify and remediate overwhelming majority of performance-related issues.