SQL Server
7 articles tagged SQL Server.
Azure SQL Managed Instance Link: Near-Zero Downtime Migration Runbook
Migrate a SQL Server database to Azure SQL Managed Instance with the Managed Instance link: prepare SQL Server and the network, seed with SSMS, check lag, then fail over and cut over.
Replace an Entra Connect sync server with a staging mode swing migration
Move Microsoft Entra Connect Sync to a new server without a sync outage: build it in staging mode, import the configuration, verify pending exports, then switch roles.
SQL Server 2025 Upgrade Checklist: Pre-Checks, Breaking Changes, Rollback
Upgrade SQL Server 2016, 2019 or 2022 to SQL Server 2025 safely: supported paths, OS checks, the OLE DB 19 encryption change for linked servers, full-text and replication fixes, and a rollback plan.
SQL Server Always On Availability Groups on Azure VMs: Setup Guide
Build a SQL Server Always On availability group on Azure VMs in multiple subnets: IP plan, Windows failover cluster, cloud witness quorum, Azure tuned thresholds, listener and failover testing.
SQL Server Error 1205 Deadlock Victim: Capture, Read and Fix Deadlocks
Capture deadlock graphs with Extended Events in SQL Server and Azure SQL Database, read the victim, process and resource lists, and stop error 1205 with indexing, access order, row versioning and retries.
SQL Server Error 9002 Transaction Log Full: Find the Cause and Fix It
Fix SQL Server error 9002 by reading log_reuse_wait_desc, then resolving missing log backups, open transactions, Always On replica lag or a full disk, and size the log so it doesn't fill again.
SQL Server Query Store: Find Plan Regressions and Force a Good Plan
Use Query Store in SQL Server and Azure SQL Database to find queries that got slower after a plan change, force the last good plan, check that forcing works, and automate it with automatic plan correction.