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.
SQL SERVER – Steps to Backup to Windows Azure storage
Steps to backup to Windows Azure storage with T-SQL: create a credential for your storage account, then back up to a blob, with no extra tools needed.
SQL AZURE – How to Disable and Enable All Constraint for Table and Database
sp_msforeachtable does not work in Azure SQL Database. Here is how to disable and enable all constraint for table and database in SQL Azure using DMVs.
SQL SERVER – Finding Top Offenders in SQL Server 2012 – Notes from the Field #068
John Sterrett shows how to capture a workload and find your top offenders in SQL Server 2012 right inside Management Studio, without writing any T-SQL.