PASS European Conference in April

While it is probably out of reach for most DBAs in the United States to attend, the PASS European Conference...

Location of the PASS Summit Follow-up

I got a little distracted after lunch and was reading through some of the various bloggers reactions to the decision...

Setup Database Snapshot against a Mirrored Database (Part 2)

This post is the second post in my series about Database mirroring. For part one is titled Configuring Database Mirroring...

The Root of all Evil

Or “Shot gun query tuning”
There have been a fair few forums questions in recent months asking for help in removing...

SCSUG (Space Coast SQL Users Group) Meeting Tonight Featuring PFE David Pless

In case you missed David Pless in Orlando on Tuesday, you have another chance to see his presentation tonight (Thursday...

Displaying a Check Mark for a Row When a Related Record Exists

Let's say that you have a column
named some_id in an outer-joined table that will return a value if a record...

Nested Tables in a Repeating List Data Region

Report designers often revert to overly complex report designs and often use subreports
unnecessarily. Building a report on a single dataset...

Creating a Recursive Report from a Parent Child Dimension

Reporting Services supports recursive hierarchies and Analysis Services supports parent-child
dimensions…

…and these two powerful features ought to just work together seamlessly,...

Using a Report Subscription with User Authentication

This question comes up quite often. A report requires a user to be authenticated using
their own network user name and...

Showing User-related Content in a Report

In cases where you want the data or content in a report to be different for each user,
there are a...