Understand Azure SQL Database serverless limits, auto-pause, resume delays, and billing metrics before choosing an idle strategy.
When Did SQL Server Last Restart? Four Ways to Check
Find SQL Server’s last restart using startup metadata, tempdb, logs, and sessions, then interpret reset counters correctly.
Before You KILL a Session: Estimating the Rollback Cost
Before you KILL a session, inspect its transaction age, log bytes, current command, and likely rollback work, then monitor the undo safely.
Finding Old Agent Jobs Not Run in Months or Never Scheduled
Review agent jobs not run recently or lacking schedules, combine history and activity, and disable approved candidates for review.
CHECK_POLICY and CHECK_EXPIRATION for SQL Logins
Audit CHECK_POLICY and password expiration for SQL logins, inspect LOGINPROPERTY evidence, and plan safe service-account exceptions.
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.
SQL Agent Operators and Notifications: Who Gets the Alert
Configure SQL Agent operators, connect jobs and alerts to email notifications, test delivery, and verify notification evidence.