SSIS Denali Resolve References

One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z)...

SQL Rally Precon Vote Results

The votes have all been tabulated and during PASS this week the top pre conference seminars were announced for SQL Rally.Thankfully...

SQL Server 2011 (Denali) no DTS support

The end has come!  We've been told for several years the vNext of SQL Server will no longer support DTS...

Date Dimension Using Computed Columns

Picked up this nice script from a client last week.  Use this script below to create a Date Dimension for...

MDX - Color Formatting on All Measures at Once

In a post a while back I wrote about how you can create conditional color formatting on the Analysis Services...

SQL Rally Cast Your Vote!

Pre Conference seminar voting is up now.  Go make it happen!  Here's the description of our session:
Title:

Business Intelligence Workshop
Speaker:Patrick LeBlanc,...

SQL Rally Precon - We Need Your Vote!

Okay SQL Community, I need your help!  Patrick Leblanc, Adam Jorgensen, Mike Davis and myself have submitted a precon for...

SQL Lunch #36 - Overview of Common DAX Expressions

Tuesday at 12:30 pm I will be presenting for SQL Lunch giving you an overview of some common DAX Expressions...

Issues With Calculating Current Age Using DateDiff (Rounding?)

Recently I inherited a set of SSIS packages that did a pretty simple calculation for age.It used the following expression,...

SSRS - Join Function

Often when designing a Reporting Services with parameters you
may be required to display those parameter values on your report.This is...