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

Self-Service Reporting Best Practices on the Microsoft BI Platform

Article from the Architecture Journal ? 12-15-2009
by Paul Turley

Once upon a time, there was a big company whose IT department

wanted...

BiTemporal Tables, anyone?

I'm doing some interesting research on using BiTemporal tables and I was wondering if anyone out there has any real-world...

The Name Game

I’m in charge of networking and social time for oPASS and I do what I can to help get our...

Log Growing Pains Article

I Just had an article published at SQLServercentral on troubleshooting the cause of log growths.  At the conclusion of that...

Maintenance Plan Issues

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

Keeping Up with PASS

I have often found it a little hard to keep up with PASS news, but after a little research, I...

Location of the PASS Summit

There has been some discussion recently around the location of the PASS Summit. The debate was centered on the results...

Top 6 Myths of Transaction Logs

Top 6 Myths of Transaction Logs I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I...