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

Upgraded to Model

That's right, folks, I'm now a model. Or at least, a model DB. Tom LaRock released his most recent rankings and...