Kenneth Urena shows how to use Stretch Database, the SQL Server 2016 feature that moves cold table data to Azure while hot data stays on premises. Microsoft has since discontinued it.
SQL SERVER – How to Change SQL Server Collation on Microsoft Azure VM (IaaS)
Azure gallery VMs install SQL Server with SQL_Latin1_General_CP1_CI_AS. Here is how to change SQL Server Collation on such a VM by rebuilding system databases.
SQL SERVER – Introduction to SQL Azure Database Throttling
On-premises SQL Server queues extra requests, but Azure works differently. Here is an introduction to SQL Azure Database Throttling and what it means for you.
SQL SERVER 2016 – IF EXISTS Function on SQL Azure Databases and More
Many SQL Server 2016 features reach Azure SQL Database first. Here is how I checked the IF EXISTS Function and other new features on SQL Azure databases.
SQL SERVER – Connecting to Azure SQL DB
Connecting to Azure SQL DB from SSMS gave me an error at first. Here is where to find the connection string and how to allow your IP address in the portal.
In-Memory OLTP in Azure SQL Database: Tiers, Limits and a Local Test
In-Memory OLTP in Azure SQL Database needs the right service tier and fits inside a memory cap. This post lists today’s tiers and limits from the documentation, then tests memory-optimized tables, a native procedure and a pre-scaling check on SQL Server 2025.
Backup to Azure Storage in SQL Server: Steps With a Container SAS
Backup to Azure Storage uses BACKUP TO URL to write a SQL Server backup straight to a blob. My original example used a storage account key. This version uses a container SAS and block blobs, with a new blob name for every backup, and I tested the local steps on SQL Server 2025.