Author: Sugeshkumar Rajendran
-
Moving System Databases — SQL Server 2000
Introduction: There are lots of articles, Links and sites that describe how to move system databases from the SQL default location to the location described by the DBA but still lot of users find difficult while moving them and land up in trouble. So I thought that I would just do a graphical way of…
-
Upgrading to SQL Server 2005
Introduction: As we all know that Microsoft has released SQL Server 2005 sometime back and is planning to release the next version KATMAI before end of 2008. Also it has announced the end of life cycle support for SQL Server 2000. Its high time that we start with upgrading our instances with SQL Server 2005…
-
Locks & Locking Hints
Introduction: Locking, Locks and Deadlocks are words that a developer/DBA does not want to hear in real life but still there are possibilities that we hear them because of some bad code written. This article takes you on to the type of locks available in SQL server and the ways of avoiding them using the…
-
SQL 2005 Edition Comparison
Introduction: SQL Server 2005 comes with different editions with each having features that are either available in the other or not. This document lists the comparison of the features available between the different editions.