Monthly Archives: February 2008

SQL Server 2008 Exam Changes

I had a few minutes this afternoon so I decided to watch the SQL Server 2008 Certification Live Meeting.   The most interesting part, at least to me, were the numbers who had passed the various certifications:   MCDBA 2000 – … Continue reading

Posted in Uncategorized | Leave a comment

OLAPQueryLog StartTime is Wrong

I recently saw a post on the newgroup about the StartTime in the OLAPQueryLog being incorrect. We have the same problem here (StartTime is eight hours ahead) and it’s something I accepted but never looked into the cause.   It appears the insert … Continue reading

Posted in Uncategorized | Leave a comment

Calling MDX from a SQL Server Stored Procedure

  I work for an online media company which allows our customers to login to a website and check their numbers. For the last several years all their activity reports have been pointed at SQL Server aggregated tables. While this worked, … Continue reading

Posted in Uncategorized | 1 Comment