SQL Server General DBA

SQL Server Email Alerts Notifications

As  DBAs, we are often required to set up alert notification emails for various tasks. For example, there might be a requirement to set up notification alerts if a particular backup job fails. A while back, I  came across the situation where I was asked to write a script which sent an email alert to […]

Create a Performance Baseline Repository

Terms used in this article Execution or SQL Execution represents a call to a Stored Procedure or an SQL Batch. General Description This process creates a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server. The repository lights up your SQL Server’s activity and exposes interesting information […]

Manage Database Projects With Visual Studio 2010

This article demonstrates how to manage database projects with Visual Studio 2010.

Unicode Compression in SQL Server 2008 R2

 Introduction Data Compression was first introduced in SQL Server 2005 with Service Pack 2 when Microsoft introduced a new storage format called VARDECIMAL to store decimal and numeric data types as variable length columns. In SQL Server 2008, Microsoft enhanced Data Compression feature to compress fixed length data types such as INTEGER, CHAR and FLOAT. […]

Overview of SQL Server 2008 R2 Express Edition

Microsoft released the final version of SQL Server 2008 R2 Express Edition on April 21, 2010. SQL Server 2008 R2 Express Edition continues to ship in 4 different packages. One can download Microsoft SQL Server 2008 R2 Express Edition from the following link. In this article we will take a look at SQL Server 2008 […]

Physical Join Operators in SQL Server – Merge Operator

In Part I of this series on physical join operators we looked at Nested Loops. We now turn our attention to the Merge operator. For this article series I am using an analogy of two sets of standard playing cards. One set with a blue back and another with a red back that need to […]

Using SQL Server Default Trace

What is Default Trace? A default trace in SQL Server is a standard server side trace which is installed by default in SQL Server 2005 onwards. As BOL states: “Default trace provides troubleshooting assistance to database administrators by ensuring that they have the log data necessary to diagnose problems the first time they occur.” Thus […]

Running SQL Server Jobs using a Proxy Account

In most companies, roles and responsibilities are clearly defined for the various teams, whether it is the database team, application team or the development team. In some cases, the application team might own a number of jobs but they may not have direct access or the high level privileges required to run it on the […]

Getting Started with PowerShell for SQL Server

xx

Restoring a Publisher Database in SQL Server

Introduction Restoring any database is a critical task which will be  complicated by the database to be  restored being a publisher database. For the purposes of this article, I will assume familiarity with the different types of replication and their features. All   examples in this article  are with respect to transactional replication. Let us consider […]
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 |