Browse by Tags

SQL Server Replication upgrade practices - choose optimal upgrade option
04 November 09 04:39 PM | ssqa.net | with no comments

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...

Filed under: sql server, replication, database, testing, upgrade, best practice

January 2009 update for SQL Server 2008 Books Online aka BOL
04 February 09 08:56 AM | ssqa.net | with no comments

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...

Filed under: sql server, 2008, microsoft, best practices, download, books online, upgrade

SQL Server 2000 to 2005 to 2008 Upgrade Technical Reference Guide
05 December 08 09:02 AM | ssqa.net | 1 comment(s)

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...

Filed under: sql server, microsoft, best practices, documentaiton, benefits, upgrade

SQL Server Upgrade - don't forget the Collation issues?
29 May 08 09:08 AM | ssqa.net | with no comments

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...

Filed under: sql server, 2005, setup, collation, 2000, upgrade, settings, reference