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

How to Script Report Deployment, Move Reports or Change Properties

On the MSDN forums I see a lot of questions about how to use program code or command
line script to...

Oracle .NET Data Provider not Supported but Necessary for Cube Design

I've decided that from now on, consulting project estimates will be padded for an
additional week to get Oracle connectivity working...