SQL Server upgrades and patches

MUST READ Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003 TIP - This case study describes upgrading to SQL Server 2005 and Windows 2003 Active/Active cluster from and provides upgrade option pros and cons for SQL Server high availability. Working with schemas in SQL Server 2005 TIP - If you're managing too many databases with too many objects, it may be time to take advantage of SQL Server 2005's ANSI SQL feature: schemas. Find out how schemas can help. Create an upgrade plan for your move to SQL Server 2005 TIP - Before upgrading to SQL Server 2005, make decisions about print statements, testing QA, rolling back and in-place SQL Server upgrade vs. hardware migration. Top 10 new features in SQL Server 2005 TIP - From programming to administrative capabilities, SQL Server 2005 enhances many existing SQL Server 2000 features and goes well beyond. Upgrading to SQL Server 2005 FAQs FAQ - Here's a list of frequently asked questions that address your SQL Server 2005 upgrade issues, including DTS packages, copying databases and creating passwords.

EXPERT TECHNICAL ADVICE: 1 - 3 of 59

	Should you upgrade to SQL Server 2005 or SQL Server 2008? Submitted By: SearchSQLServer.com | 13 Aug 2008 TIP - Is your organization evaluating whether to upgrade. Let this SQL Server expert advice help you weigh your options for upgrading from SQL Server 2000.

	Monitor database mirroring and replication after a SQL Server upgrade Submitted By: SearchSQLServer.com | 05 Aug 2008 TIP - Learn how to monitor your database mirroring and replication setup after upgrading an Active/Active cluster to SQL Server 2005.

	Upgrade live applications to SQL Server 2005 for high availability Submitted By: SearchSQLServer.com | 09 Jul 2008 TIP - Part 4 in this series on upgrading an Active/Active cluster to SQL Server 2005 details how to push live data from one cluster to another using a conversion DB and replication.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER UPGRADES AND PATCHES

REFERENCE & LEARNING: 1 - 3 of 14

	Top 10 SQL Server Integration Services (SSIS) and DTS tips SearchSQLServer.com | 15 Jun 2008 TOP 10 TIPS - Top SQL Server Integration Services (SSIS) tips from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server 2005.

	FAQ: SQL Server databases how-to SearchSQLServer.com | 19 Mar 2008 FAQ - Troubleshoot SQL Server database issues with these FAQs. Whether it's how to back up, restore, import, export, copy or upgrade SQL Server databases, you'll get expert advice here.

	Upgrading to SQL Server 2005 FAQs SearchSQLServer.com | 17 Sep 2007 FAQ - Here's a list of frequently asked questions that address your SQL Server 2005 upgrade issues, including DTS packages, copying databases and creating passwords.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER UPGRADES AND PATCHES

NEWS: 1 - 3 of 15

	Q&A: What's new in SQL Server 2005 SP1 SearchSQLServer.com | 04 May 2006 INTERVIEW - SQL Server 2005 Service Pack 1 provides production-ready Database Mirroring, SAP NetWeaver Business Intelligence support, Full-Text support and more.

	SQL Server 2005 SP1 ships SearchWinIT.com | 19 Apr 2006 ARTICLE - SQL Server 2005's database mirroring functionality is finally here with the release of SQL Server SP1.

	Microsoft releases CTP for SQL Server SP1 SearchWinIT.com | 17 Mar 2006 ARTICLE - Community preview of SP1 for SQL Server 2005 includes new features, fixes.

	VIEW ALL NEWS ON SQL SERVER UPGRADES AND PATCHES

BEST WEB LINKS: 1 - 2 of 2

	SQL Server World Wide User Group Help Center http://www.sswug.org/ | 22 Jul 2005 BEST WEB LINK - This Web site allows subscribers access to educational webcasts, discussion forums, database news, script manager and e-mail discussion lists

	How to upgrade from SQL Server 6.5 Microsoft | 18 Feb 2005 BEST WEB LINK - Learn how to convert data from Microsoft SQL Server 6.5 to Microsoft SQL Server 2000 using the SQL Server Upgrade Wizard.

	VIEW ALL BEST WEB LINKS ON SQL SERVER UPGRADES AND PATCHES

	SEE ALSO - Topics Related to SQL Server upgrades and patches:  SQL Server 2005 (Yukon), SQL Server overview, SQL Server 2008 (Katmai)