Author: Sugeshkumar Rajendran
-
Performance Counters
Few of my friends who wish to do a performance tuning in their servers, they asked me what are the counters that they should check that gave me an idea to prepare this document and publish across.
-
Moving System Databases – SQL Server 2005
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 of writing an article for moving the databases so that…
-
Short Cut Keys
I have always googled out for finding any shortcut key to be used in SQL Server that gave me an idea to post this. I have gathered all the SQL Server 2000 and 2005 shortcuts with the help of books online and internet here. Hope this helps you.
-
How to Configure Peer to Peer replication – GUI
This article takes you with simple steps in configuring peer-to-peer replication. P2P replication is new to SQL server 2005 and though looks like complex in theory its one of the easiest to configure and maintain on long run. The following steps take you through the configuration process.
-
SQL Server maintenance Job Deletion Error
I have found in discussion forums regarding the error given below when you try to delete a job that was part of maintenance.