SQL Server General DBA

Surface Area Configuration Using Policy Based Management

The SQL Server Surface Area Configuration Tool (SQLSAC) was a utility introduced by Microsoft in SQL Server 2005 to help SQL Server Database Administrators or Developers manually turn on features which are off by default in the product. The previous article titled Using the SQL Server 2005 Surface Area Configuration Tool explains how database administrators or […]

New Features in SQL Server 2008 Management Studio – Part 3

The article titled New Features in SQL Server 2008 Management Studio – Part 1 discussed new features such as Activity Monitor, Intellisense Support and Region Outlining that are available in SQL Server 2008 Management Studio. The second article New Features in SQL Server 2008 Management Studio – Part 2 discussed more new interesting features such as […]

New Features in SQL Server 2008 Management Studio – Part 2

The previous article titled New Features in SQL Server 2008 Management Studio – Part 1 discussed some of the new features available in SQL Server 2008 Management Studio; namely Activity Monitor, Intellisense Support and Region Outlining. This article continues to explore the new features available within SQL Server 2008 Management Studio (SSMS).  These features can be used by database […]

New Features in SQL Server 2008 Management Studio – Part 1

SQL Server Management Studio (SSMS) is a graphical tool which can be used by Database Developers and Database Administrators to perform development and administrative tasks on SQL Server 2008. SQL Server Management Studio (SSMS) tool was first introduced by Microsoft in SQL Server 2005. SSMS is a replacement for Query Analyzer, Analysis Manager & Enterprise […]

Understanding the Basic of Triggers

 A trigger is an operation that is executed when some kind of event occurs to the database. It can be a data or object change.  Listed below are the different types of tiggers: Types of Triggers DML(data manipulation language) triggers (SQL Server 2000- 80.0) AFTER triggers (Only Tables) INSTEAD OF triggers (Tables or Views) DDL(data definition language) […]

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 […]
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 |