SQL Server General DBA

Steps to Install SQL Server 2008

Microsoft SQL Server 2008 Release to Manufacturing (RTM) was released in the August 2008. There are different versions of SQL Server 2008 available such as Enterprise, Standard, Workgroup, Web, Express, Compact and Developer editions. The trial version of Microsoft SQL Server 2008 can be downloaded from the following link http://www.microsoft.com/sql/2008/prodinfo/download.mspx. This article describes the steps […]

How to Configure and Use the Central Management Server Feature in SQL Server 2008

SQL Server 2008 introduces a new feature called Central Management Server (CMS) which can be used by Database Administrators within an organization to manage all the SQL Servers like 2000, 2005 and 2008 using an instance of SQL Server 2008. Central Management Server (CMS) acts as a central repository which holds the list of all […]

Peer-to-Peer Replication in SQL Server 2008

Introduction Peer-to-Peer (P2P) Replication was introduced in SQL Server 2005 in order to improve availability and performance. In SQL Server 2008 the P2P Replication feature has matured further with the addition of more features.  This articles describers the reasons to use P2P, how to configure P2P and some common issues. Why use P2P Replication In typical replication […]

Create Backups without Breaking the Database Backup Sequence

Development or Testing teams often request Database Administrators to provide a copy of a full database backup of a production database. When such a request comes in, I have seen in many organizations that the junior database administrators will quickly perform a full database backup and copy the backup files to the specified shared location […]

Recover Data Using Database Snapshots

The Database Snapshot feature was first introduced in SQL Server 2005 Enterprise Edition and it is also available in SQL Server 2005 Enterprise Edition. Database Administrators can create database snapshots of all the user databases irrespective of the database recovery model they are using. A database snapshot is basically a static, read-only copy of the […]

Backup User Databases Using a Maintenance Plan

Data is the heart and soul of any enterprise. It has become an essential task for organizations around the world to protect their data. Database Administrators have a tough job to implement right database backup strategies and disaster recovery plans. Backing up your user databases can protect an organization against the accidental loss of data, […]

Differential Database Backups in SQL Server

In this fast moving world, data is the heart & soul of any enterprise. As the business is expanding many organizations around the world have adopted a 24×7 business model to support and run their businesses. In a 24×7 business model data changes happen around the clock, thereby increasing the demand for database backups. Taking […]

Backup System Databases Using Maintenance Plans

System databases are an integral part of SQL Server, as SQL Server is dependant on the System Databases for functionality. Database Administrators should make sure that all the system databases are part of their day to day backups. Most importantly, database administrators should take full backup of all the system databases immediately after they have applied any Hotfixes […]

Overview of Maintenance Plans in SQL Server 2008

The Maintenance of a SQL Server databases is one of the primary responsibilities of a Database Administrator. To make database maintenance easier, DBA’s can leverage the Maintenance Plan Wizard or Maintenance Plans which are available in SQL Server 2005 and higher versions. A DBA can create a database maintenance plan either by using the Maintenance Plan Wizard […]

Dedicated Administrator Connection in SQL Server

As a Database Administrators you may come across a scenario where you are unable to access a SQL Server instance, especially when the CPU or Memory utilization on the server is very high. To allow database administrators to troubleshoot such scenarios, Microsoft introduced the Dedicated Administrator Connection (DAC) in SQL Server 2005; this is a special diagnostic connection for […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |