This weekend is SQL Saturday #130 in Jacksonville, FL. On Friday, April 27th, is a great pre-con session by SQL Server MVP, Kevin Kline on Performance Tuning SQL Server 2008 R2. Go here to get registered for this phenomenal opportunity to learn from an unquestioned expert. Also, I'll be presenting a session on MDX called MDX 101: An Introduction to MDX. I'm going to be giving an introduction into the multidimensional expression language used to query SSAS cubes. In this session, we will learn th...
Read More
On a recent project I created a Date dimension script that I thought, I?d share (mostly so I would have access to it from anywhere). I based this script on one written by Mike Davis , but I included a few changes such as a first and last day of month flag, open flag, relative time period attributes, and a few others. Enjoy! --Make sure you set the Start and End Date below on row 58 and 59 --Create the tables BEGIN TRY DROP TABLE [DimDate] END TRY BEGIN CATCH --DO NOTHING END CATCH CREATE TABLE [...