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

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

Introduction to Parallel Data Warehousing

What are we talking about?
Recently Microsoft released a new version of SQL Server 2008 R2 called Parallel Data Warehouse Edition....

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

Sharing Remote Desktop Sessions

I work for a very large company where divisions are spread out literally all over the world. There are many...

SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai

Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...

The Right Level of “Right”

…or, How I Learned to Stop Worrying and Love the Bomb
I had a SQL dev’s dream come to me via...

2010 3rd Quarter Goals

Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...

Webcast Today – Using XML to Query Execution Plans

I’ll be speaking for the SQL PASSDatabase Administration Virtual Chapter today at 12 PM Eastern time.  The topic will be...

PASS 2010 Summit on LinkedIn Event Calendar – Have You RSVP’d?

Happened to notice in my weekly LinkedIn update today that Todd McDermid had signed up for the 2010 Summit event...