Flush authentication cache entries with DBCC FLUSHAUTHCACHE. This post tests the command on SQL Server 2025, shows who can run it and that on SQL Server 2025 it ends no open session, and says what it is documented to do on Azure SQL Database.
Azure SQL Database Serverless: Auto-Pause and What Wakes It
Understand Azure SQL Database serverless limits, auto-pause, resume delays, and billing metrics before choosing an idle strategy.
Single Installer for SSMS and ADS – SQL in Sixty Seconds #138
Microsoft has recently released a single installer which now installs SSMS and ADS both together in a single Installation.
Long-Term Backup Retention in Azure SQL Database
Configure long-term backup retention in Azure SQL Database, inspect retained recovery points, restore a separate copy, and review costs.
Moving to Azure SQL Database: The Features You Give Up
Plan moving to Azure SQL Database by finding Agent jobs, cross-database references, CLR, FILESTREAM, linked servers, and recovery changes.
Azure SQL Firewall Rules: List, Add and Remove With T-SQL
Azure SQL firewall rules decide which IP addresses can reach a logical server and its databases. This post lists the server-level and database-level rules with T-SQL, adds, changes and removes one, and explains how to find the address Azure sees. It also covers the one thing T-SQL cannot do, which is let you in for the first time.
SQL Azure – Add IP Address to Firewall
To Add IP Address to Firewall rules, I first confirm the intended Azure SQL network path. A home connection prompted this walkthrough.