SQL Server Checksum

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

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 stateDescriptionSYNCHRONIZINGThe contents of the mirror database are...

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

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

Operation Souza

This Wednesday we’re having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past...

Last Weeks Top “Reading” Links #104

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

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

Notes From the October 9, 2014 Space Coast SQL Meeting

Not a bad drive over from Orlando. Only a little traffic, about 80 minutes. I was early enough to have...

Tools For Successful Remote Working

I’ve been asked a few times recently how I find remote working and how well it works so I thought...

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