Limiting Table Access for Reporting Part 1

End users may have a need to do some form of reporting of data from source systems. Opening up the...

Limiting Table Access for Reporting Part 2

Blog Title: Limiting Table Access for Reporting Part 2

In the first blog post of this series, I showed you how...

Log Shipping By Abi Chapagai (Revised)

Log Shipping  By Abi  Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...

Pesky Protected Mode

How many of you keep falling for this one…You open up Report Manager for a user that you know you...

Poor Little Misunderstood Views

Some people love ‘em, some people hate ‘em. But, one thing I have found to be nearly universal is that...

Schedule Published for SQLSaturday #51 in Nashville

Just released, http://www.sqlsaturday.com/51/schedule.aspx?sat=51. Five tracks, lots of good speakers, but I see a few new names too. Looks like a...

SQL Bits 7 – Registration is Open !

Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...

SQL Saturday Advice - Communicate Often

It seems that Thursdays are becoming SQL Saturday day here at my blog. I wrote a few posts about SQL...

SQLSaturday #40 is Almost Here – July 31, 2010

I’ll be leaving Friday morning with my family to go to Miramar, Fla, for the 2nd annual SQLSaturday there. I’m...

The Dangers of Sub-queries!!!!

Ok, now that I have your attention this really should be titled the danger of not qualifying all objects, but...