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)...

T-SQL Tuesday #59–My Hero

It’s October, and another busy fall is underway for me. It’s also the second Tuesday, so it’s T-SQL Tuesday time...

Configure SQL Server Database Mirroring

1) Take Full backup of database at Principle Server BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’ 2) Take Log Backup at Principle Server BACKUP LOG USERDB1 TO DISK =...

Creating a Reporting Services Subscription

Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either...