Category: Migration & Upgrades

sp_help_revlogin carries more than you think, including disabled state. What nothing carries, and why the script you actually ran matters more.

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Upgrading the operating system underneath SQL Server is usually driven by someone else: a support deadline, a security policy, a hardware refresh. That does not make it someone else’s problem, because SQL Server is the thing that will be blamed…

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Changing SQL Server edition is two completely different jobs depending on which way you are going. Upgrading is a setup.exe operation measured in minutes. Downgrading is a migration, because there is no supported in-place path, and it starts with an…

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment There are two ways to upgrade a SQL Server version, and the choice is really a choice about what your rollback looks like. Side-by-side gives you a rollback that consists of pointing the application back at a server which is…

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Migrating a highly available instance is not one job, it is two different jobs that people frequently confuse. An Availability Group migration adds replicas and fails over. A Failover Cluster Instance migration builds a new cluster and cuts over. The…

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Moving a standalone SQL Server instance to new hardware is the most common migration there is, and the one most often done from memory. The databases are the easy part. What catches people is everything around them: logins that arrive…

“Bump the compatibility level after a migration” is standard advice, and Version Upgrade Readiness already tells you which databases are behind. What that advice usually skips is what the number actually controls, and one part of it is more counter-intuitive than most people assume. This post runs a real test on a lab database to…