Maintenance Plan Issues

I think maintenance plans were a great improvement in SQL Server 2005, with a more visual designer and the ability...

Managing Report Project Deployments & Version Control

What lessons have we learned about managing report projects and what are the best
practices?

Since each report is stored in a...

MDX Datasets with Date Parameters

How should date type parameters be prompted?  There are two common approaches
depending on how you want the parameter to appear. ...

Navigating to a Report in a Pop-up Window

When using the Jump to Report action int he web browser, the target report is displayed
in the same browser window...

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

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

Parameterized Top Values Report

Top ranked lists are a common type of report. In many cases business users may want
to see only a specific...

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

PASS Releases Survey Results & Summit Location – Reactions

The Impetus
So after Andy Warren’s (@SqlAndy) blog post, PASS Update #24, last week and the follow-up posts by myself (A...

PASS Update #25 (Summit Location and More)

By now you’ve probably seen the official announcement from PASS about the Summit being located in Seattle for both 2011...