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

PASS Summit 2014: Recommendations and Invitations (#sqlpass #Summit14)

The first week of November, we’ll be at the PASS Summit inSeattle, WA.  This is the highlight of most SQL Server speakers’...

SQLSaturday Orlando Marketing Plan-Part 49 (Plan Notes)

Introduction
After finishing up six months of managing the marketing for SQLSaturday Orlando I’ve been going back through all my blog...

Friday Followup For October 10, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...