SQL Server Database Mirroring Tips and Tricks, Part 1

Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique...

SQL Skills IE3 #sqlskills

I attended my first SQL Skills event in December 2011.  Due to a big project at work I was able...

Why I don’t like maintenance plans

If you create a maintenance plan (SQL 9.0.3042) to backup databases and select All databases as below;

Then at some point...

#Meme15: On Facebook

This will be my first Meme15 (here’s Jason Strate’s original Meme15 post), and today we’re talking Facebook. The question is:
How...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those cases where you are consulting or you have taken...

Cached blocking history with sys.dm_db_index_operational_stats

Transactions generate IO, latching  and  locking on tables and indexes  , while attempting to access data. The sys.dm_db_index_operational_stats  DMV returns aggregated data...

ColoradoSQL for March 2012

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...

Data Warehouse Architecture – Kimball and Inmon methodologies

What is the best methodology to use when creating a data warehouse?  Well, first off, let’s discuss some of the reasons why...

Execution Plans – Merge Join

The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There...