SQL Server Upgrades and Migrations Tips
Administration
Backward Compatibility
Books Online
Consolidation
Deprecation
Installation
Migration
- Generate scripts for SQL Server object migration
- Manage SQL Server Instances for Decommissioning and Upgrade Projects
- Migrating a SQL Server Instance
- Migrating a VLDB in SQL Server with Log Shipping
- Speed up the SQL Server 2005 migration process
- SQL Server Database Migration Checklist
- SQL Server Migration Assistant 2008 SSMA
- Transition from MS Access to SQL Server with the Migration Assistant
Miscellaneous
- Energy Policy Act of 2005 for SQL Server Notification Services
- Energy Policy Act of 2005 Implications on SQL Server
New Features
- Learning SQL Server 2008
- SQL Server 2008 Features, Function and Value
- SQL Server 2008 First Impressions
- SQL Server 2008 List of New Features
- What's on your SQL Server wish list?
Overview
- Choosing a SQL Server Upgrade Method - Part 1
- Demonstrate a SQL Server Architecture with Lego
- Minimizing Downtime for SQL Server Upgrades - Part 4
- Reasons to Upgrade to SQL Server 2017
- SQL Server Upgrade Methods In-Place Upgrades and Differential Restore Upgrades - Part 2
Service Packs
- Applying SQL Server Service Packs
- Creating a SQL Server Build and Patch Release Table
- Error Applying SQL Server 2012 SP2 with Availability Groups
- Extract Hot Fix Details from a SQL Server CU KB Articles
- How to Recover from a SQL Server Service Pack 3 Install Error
- Issues Encountered when Upgrading SQL Server 2012 Service Pack 1 with a Cumulative Update
- Post SQL Server 2000 Service Pack 4 Performance Issues
- Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation
- Steps to Install SQL Server 2008 Service Pack 1 (SP1)
Snapshots
System Objects
Troubleshooting
Upgrade
- Choosing Between SQL Server 2012 and SQL Server 2014
- Migrate a database from SQL Server 2008 to 2016 and use new features
- Overview of Microsoft SQL Server 2008 Upgrade Advisor
- Side by Side SQL Server Upgrade with Log Shipping - Part 3
- SQL Server 2005 Upgrade Considerations for DBAs and Developers
- SQL Server 2008 Upgrade Plan for DBAs
- SQL Server 2008 Upgrade Testing at the Microsoft Technology Center
- Upgrading SQL Server databases and changing compatibility levels
- Upgrading to SQL Server 2008 Using Backup and Restore Method
- Upgrading to SQL Server 2008 using Copy Database Wizard
- Upgrading to SQL Server 2008 Using Detach and Attach Operations
- Upgrading to SQL Server 2012 Express
- Version and Edition Upgrades with SQL Server 2008 R2
- What's new in SQL Server 2014? Is it worth the upgrade?
- Why Upgrade to SQL Server 2008