Category: DBA
-
Introduction to Notification Services
I have been a Core Server Side SQL Server DBA for more than half a decade. This was the first application side task that I handled from the SQL Server front. I would like to thank my friends Chakravarthy and Poornima for giving me this wonderful opportunity to work on Notification Services. I dont claim…
-
Linked Server – Part 2
Introduction Some days back I’ve written “Linked server part 1” where we have discussed about configuring linked server. In this article I’m going to cover authentication protocols between linked server and the possible errors. Before we start let’s have a brief description about connection protocols & authentication mechanism
-
Backup compression in SQL Server 2008
Introduction Backup compression is one of the feature expected by every administrator to minimize the backup size and to squeeze the time taken for backup. In previous versions of SQL Server most of us are going for 3rd party tools like Quests Litespeed, Redgates SQL Backup etc. for which we need to pay additional amount.…
-
How to use Copy Database Wizard
What is copy database wizard? Copy Database Wizard is a new feature from SQL Server 2005 onwards. You can make use of this feature to copy move databases between different instances of SQL Server. It can be used for the below purposes Transfer a database when the database is still available to users by using…
-
Frequently Used Catalog Views – SQL 2005
Catalog views return information that is used by the Microsoft SQL Server 2005 Database Engine. You can make use of these catalog views because they are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. Catalog views do not contain…