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

SQL Server proxy account and local policy

Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...

Reblog: October 3 to October 9

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...