Upgrades and Migrations

Valuable SQL Server Upgrades and Migrations tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
Demonstrate a SQL Server Architecture with Lego Graham Okely2026-05-14
Upgrade to SQL Server 2025 Enterprise Developer Edition Jim Evans2026-02-20
Side by Side Upgrade to SQL Server 2022 Nivritti Suste2025-08-21
Optimize SQL Server deployments with Amazon FSx for NetApp ONTAP MSSQL Tips2025-08-07
Upgrade SQL Server from Evaluation Edition to Standard or Enterprise Daniel Calbimonte2025-06-18
Modernize in place with SQL Server 2022 and AMD MSSQL Tips2024-06-13
Always On SQL Server Upgrade Checklist Jim Evans2022-05-13
Minimizing Downtime for SQL Server Upgrades – Part 4 Ameena Lalani2018-11-28
Side by Side SQL Server Upgrade with Log Shipping – Part 3 Ameena Lalani2018-11-09
SQL Server In-Place Upgrade and Differential Restore Upgrade – Part 2 Ameena Lalani2018-09-10
Choosing a SQL Server Upgrade Method – Part 1 Ameena Lalani2018-08-27
Reasons to Upgrade to SQL Server 2017 Ameena Lalani2018-08-16
Migrate a database from SQL Server 2008 to 2016 and use new features Pablo Echeverria2018-05-09
Extract Hot Fix Details from a SQL Server CU KB Articles Jeffrey Yao2018-03-30
Identify System Object Differences Between SQL Server Versions Jeffrey Yao2018-02-12
Creating a SQL Server Build and Patch Release Table Jeffrey Yao2018-01-15
SQL Server Edition Post-Downgrade Steps Svetlana Golovko2017-09-21
Error Applying SQL Server 2012 SP2 with Availability Groups Carla Abanes2015-06-15
SQL Server Database Snapshots for Data Comparison Burt King2015-04-27
Quick Guide to Upgrading to SQL Server 2014 Dallas Snider2014-06-06
Choosing Between SQL Server 2012 and SQL Server 2014 Aaron Bertrand2014-06-05
What’s new in SQL Server 2014? Is it worth the upgrade? Daniel Farina2014-01-23
Issues Encountered when Upgrading SQL Server 2012 Service Pack 1 with a Cumulative Update Koen Verbeeck2013-12-23
Downgrade from SQL Server Enterprise Edition to Standard Edition Brady Upton2013-10-23
Manage SQL Server Instances for Decommissioning and Upgrade Projects Graham Okely2013-08-15
Upgrading to SQL Server 2012 Express Murali Krishnan2013-05-07
What’s on your SQL Server wish list? Jeremy Kadlec2013-01-18
SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule Manvendra Singh2012-02-16
Version and Edition Upgrades with SQL Server 2008 R2 Murali Krishnan2011-10-27
SQL Server Migration Assistant 2008 SSMA Murali Krishnan2011-01-25
Overview of Microsoft SQL Server 2008 Upgrade Advisor Ashish Kumar Mehta2010-12-14
Upgrading to SQL Server 2008 Using Backup and Restore Method Ashish Kumar Mehta2010-11-19
Upgrading to SQL Server 2008 Using Detach and Attach Operations Ashish Kumar Mehta2010-10-06
Database features restricted to a specific edition of SQL Server 2008 Ashish Kumar Mehta2010-09-07
Migrating a VLDB in SQL Server with Log Shipping John Sterrett2010-07-29
Transition from MS Access to SQL Server with the Migration Assistant Tim Ford2010-04-28
SQL Server Database Migration Checklist Jugal Shah2010-02-05
SQL Server 2008 Upgrade Plan for DBAs Jeremy Kadlec2010-02-02
How to Recover from a SQL Server Service Pack 3 Install Error Matteo Lorini2009-09-15
Upgrading to SQL Server 2008 using Copy Database Wizard Ashish Kumar Mehta2009-07-13
Steps to Install SQL Server 2008 Service Pack 1 (SP1) Ashish Kumar Mehta2009-06-03
Generate scripts for SQL Server object migration Atif Shehzad2009-06-01
SQL Server 2008 Upgrade Testing at the Microsoft Technology Center Kun Lee2009-03-04
SQL Server 2008 First Impressions Jeremy Kadlec2008-01-23
SQL Server 2008 List of New Features Chad Boyd2007-10-15
Updates for SQL Server 2005 Books Online Jeremy Kadlec2007-10-15
Learning SQL Server 2008 Jeremy Kadlec2007-10-03
Applying SQL Server Service Packs Greg Robidoux2007-09-10
SQL Server Consolidation Pros and Cons Jeremy Kadlec2007-08-30
Migrating a SQL Server Instance Jeremy Kadlec2007-05-17
Post SQL Server 2000 Service Pack 4 Performance Issues Jeremy Kadlec2007-04-24
SQL Server 2005 Upgrade Considerations for DBAs and Developers Jeremy Kadlec2007-04-11
Energy Policy Act of 2005 for SQL Server Notification Services Jeremy Kadlec2007-02-02
Energy Policy Act of 2005 Implications on SQL Server Chad Boyd2007-01-23
Speed up the SQL Server 2005 migration process Jeremy Kadlec2006-06-16