SQL Server Knowledge Sharing Network (@sqlmaster) : upgrade

SQL Server data platform upgrade - Why upgrade and how best you can reduce pre & post upgrade problems?

ssqa.net — Sat, 19 May 2012 10:26:00 GMT

SQL Server upgrade, let it be database(s) or instance(s) or both the process and procedures must follow best practices in order to reduce any problems that may occur even after the platform is upgraded. The success of any project relies upon the simpler...(read more)

SQL Server 2008 R2 Service Pack 1 CTP - test and feedback #sql #sqltools #ctp

ssqa.net — Wed, 11 May 2011 10:43:00 GMT

SQL Server 2008 R2 service pack 1 contains all the cumulative update pack releases since RTM release. This means SP1 CTP consist the CU Package releases from 1 to 6, as CU7 has released on April 18th 2011. So before you test the SQL2008R2SP1 CTP, I would...(read more)

End of support (technical) for SQL Server pre-2005 versions, mind the dates!

ssqa.net — Tue, 19 Oct 2010 15:45:00 GMT

11th Jan 2011 - is the date to remember if you still managing SQL Server 7.0 SP4 [ 7.00.1063 or 7.00.1152 build version] (compatibility=70) instances on your production environment, end of extended support for this version! 09th April 2013 - is the date...(read more)

Reminder: Support for Windows XP SP2 and Windows 2000 Ends July 13, 2010

ssqa.net — Mon, 12 Jul 2010 08:32:00 GMT

Here is the reminder for the organisations and users about Windows XP mainstream support from Microsoft Lifecycle services: As we announced in 2008, support for Windows XP Service Pack 2 (SP2) will end on July 13, 2010. Support for Windows 2000 will end...(read more)

SQL Server Replication upgrade practices - choose optimal upgrade option

ssqa.net — Wed, 04 Nov 2009 16:39:00 GMT

SQL Server Upgrade task needs a thorough planning and testing before you deploy the process in production environment. In this regard when performing an upgrade to a replicated environment, DBAs must make sure that all changes have been applied to all...(read more)

January 2009 update for SQL Server 2008 Books Online aka BOL

ssqa.net — Wed, 04 Feb 2009 08:56:00 GMT

Here comes another update that you need to concentrate, a newest update to the SQL Server 2008 Books OnLine. MSDN site specifically refers that the following categories have had new topics added or existing topics updated with significant changes in the...(read more)

SQL Server 2000 to 2005 to 2008 Upgrade Technical Reference Guide

ssqa.net — Fri, 05 Dec 2008 09:02:00 GMT

What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of...(read more)

SQL Server Upgrade - don't forget the Collation issues?

ssqa.net — Thu, 29 May 2008 08:08:00 GMT

Whenever any user (forum or usergroup) asks me about Upgrade gotchas and FAQs I will refer this SQLUpgrade-blurb post that I have made from my experience. Further I would like to enhance the topic of upgrade and things you need to watch about Collation...(read more)