SQL Server General DBA

SQL Server 2008 MERGE Statement

SQL Server 2008 introduces the MERGE statement which will allow users to perform insert, update and delete operations in a single statement. In the earlier versions of SQL Server to achieve the same functionality the database developer or database administrator needed to write separate statements to perform the insert, update or delete of data in one […]

Obtain Exclusive Access to Restore a SQL Server Database

Database Administrators have always come across scenarios where they need to restore a copy of the latest production database to a test or development environment. This can be either a scheduled process or an adhoc request from the test or development team. The most important things that a DBA needs to do when restoring a […]

Configure Windows Firewall for SQL Server Remote Connections

The Firewall is an important component of Microsoft Windows which prevents unauthorized access to computer resources. If the Windows firewall is turned on and if it is not configured correctly, then attempts made to connect to SQL Server by users will be blocked. To access an instance of SQL Server through a firewall, a Database […]

Understanding Service Level Agreements

As a DBA, your job is to provide database systems that are reliable, secure and available when required. In order to achieve these goals, you must understand your customer’s service requirements, usually conveyed through Service Level Agreements. Far too many DBAs have no idea what their Service Level Agreements are, or if it’s possible to […]

Database Audit Specifications in SQL Server 2008

SQL Server 2008 introduces a new feature called SQL Server Audit. Auditing a SQL Server database involves tracking and logging events that occur on the database. This feature enables Database Administrators to implement a strategy that they can use to meet the specific risks of their SQL Server 2008 databases. Database Audit Specification The Database […]

How Change Data Capture Can be Used

Introduction Change Data Capture or CDC is a new feature included in SQL Server 2008. There are several excellent introductionary articles on sql-server-performancesql-server-performance that cover what is CDC, how to configure CDC and where CDC data is captured. This article discusses how we can use CDC in our day to day wok. Uses of CDC There three ways […]

Server Audit Specifications in SQL Server 2008

SQL Server 2008 introduces a new feature called SQL Server Audit. Auditing an instance of SQL Server involves tracking and logging events that occur on the system. This feature enables Database Administrators to implement a strategy that they can be used to meet the specific risks of their SQL Server instances. Server Audit Specifications The Server […]

Server and Database Auditing in SQL Server 2008

SQL Server 2008 introduces a new feature called SQL Server Audit. Auditing an instance of SQL Server or a SQL Server database involves tracking and logging events that occur on the system. This feature enables Database Administrators to implement a strategy that they can use to meet the specific risks of their database environments. SQL […]

So, you find yourself On-Call

So, you find yourself on-call.  Your life was just interrupted.  You realize it is an issue that you ‘have to’ deal with.  Are you ready?  What are you missing to accomplish your task?  In the heat of the moment, you may not have everything on hand that is needed, much less recall all the needed […]

Administrator & Monitoring Change Data Capture in SQL Server 2008

SQL Server 2008 introduces a new feature called Change Data Capture (CDC). CDC Captures DDL and DML activities on a SQL Server Table and places the changes in a separate SQL Server relational table. In this article we will see how DBA can administer and monitor CDC in SQL Server 2008. The CDC feature is disabled by default at 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 |