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

SQL Saturday Minnesota Precon 10/24 – Virtualization for SQL Server DBAs

Coming soon is the SQL Saturday #332 in Minneapolis, MN on October 25th, with my preconference training session on Friday, October 24. I am really looking forward to...

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

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

My Best Technical Sites and Blogs

Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the...

Navel Gazing

I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...