DBA News & Scripts

SQL server techniques, how-to's and other random ramblings

How to Setup DB Mirroring using T-SQL

Depending on requirements of the solution; we use asynchronous mode for performance reasons (which excludes the two-phase commit), and we...

How to Fix Performance Dashboard for SQL 2008

The SQL 2005 Performance dashboard is a fantastic way to gain access to SQL’s dynamic management views (DMVs) without the...

List the database name and file locations

List the database name, logical names and locations of the DB log and database files; [crayon-5dcf5d5578c6c456921719/]

SQL Server DMV to Output Index Fragmentation by Database / Table

The following SQL Server dynamic management view (DMV) query will return detailed information about the fragmentation level of a database....

How to Remove Replication Monitor Red Crosses

Provided that there are NO other publications against that database, the sp_removedbreplication can be used to remove all replication objects...

The SSIS Subsystem Failed to Load

When you change servers and restore msdb, you may find your maintenance plans failing and putting the following messages into...

Enable xp_cmdshell using sp_configure, run batch file from xp_cmdshell

Disclaimer: xp_cmdshell is a feature that is disabled by default in SQL Server, and for a very good reason. Serious...

How to Setup a SQL Server Alias Name

A few notes on how to configure a SQL Server alias name for connecting through to a SQL server. Firstly...

Dynamically backup and compress user databases (SQL 2008)

A simple script to dynamically backup simple recovery mode databases (with compression) under SQL 2008. Using this script, users are...

A Visual Explanation of SQL Joins

I thought Ligaya Turmelle’s post on SQL joins was a great primer for novice developers. Since SQL joins appear to...

Add these 5 Must-Have DMV Queries to your DBA Toolbelt!

In order to get the best results from these queries, you should run DBCC FREEPROCCACHE on your server a few...

Format drives with correct allocation and offset for maximum SQL Server performance

Problem Disk performance is critical to the performance of SQL Server. Creating partitions with the correct offset and formatting drives...

Contact Us

We typically respond within minutes.