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

Final Prep for SQL in the City

I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me...

Invite for #TSQL2sday #59 – My Hero!

It is T-SQL Tuesday again, for the 59th month in a row. Next month marks FIVE YEARS of T-SQL Tuesday,...