Database Mirroring States (SQL Server)

SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :- Mirroring state Description SYNCHRONIZING The contents of the mirror database are lagging behind the contents of...

Murder In Utah

I am about to set sail on a new venture with my next official whistle stop.  This year has been...

Murder In Utah

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on...

Some Thoughts On Running a Chapter

Last week I spent some time after my presentation to Space Coast SQL talking to Kathleen Branch, the chapter leader,...

SQL Server Checksum

Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the...

The Question – Why?

The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...

T-SQL – Scripting Stored Procedure to Create backup copy on same database

This post is one of the request from OP.
Download SQL  Backup SP in the same database
The probelm statement 1:-
Create a...

T-SQL Tuesday #59 – My Hero!

It always amazes me how fast these T-SQL Tuesday block parties come about; it seems like we just finished one...

T-SQL Tuesday #59: My Hero

This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show).

Ada...

TSQL Tuesday #59: My Hero, My Inspiration, My Wife

TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t)...