Taking database offline is one line of T-SQL with ROLLBACK IMMEDIATE. But what if your boss wants to wait 30 seconds first? Here is that script too.
NUMA in SQL Server: A Lunch Chat About Local and Remote Memory
NUMA in SQL Server came up in a lunch break chat at SQLPass, during my 42 tips session. An attendee asked what NUMA is and when SQL Server got it. Here is the answer I gave, with the history.
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.
SQL SERVER – Getting Started with Project Versions in the SSIS Catalog – Notes from the Field #106
Tim Mitchell shows a handy but overlooked feature: project versions in the SSIS catalog, which keep earlier deployments you can browse in SSMS.
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.
Finding Dead Code: Stored Procedures Nobody Calls
Investigate dead code with cached procedure statistics, dependency checks and retained snapshots, then quarantine candidates before removal.
BULK INSERT ORDER Hint: Loading Pre-Sorted Files Without a Sort
The ORDER hint does not sort anything. It is a promise about your file, and SQL Server checks it. Here is what happens when you break it.