Need to create a time dimension down to the millisecond?

Ok, I know that creating a time dimension down to the millisecond is extremely rare.  After all, we are talking...

Speaking at Space Coast SQL Users Group on Feb 9, 2012

I’ll be visiting the Space Coast group (http://spacecoast.sqlpass.org/) on Feb 9th to do a presentation on Professional Development Plans. I’m...

SSAS: Currency Conversion Using Measure Expressions

Currency conversions can be implemented several ways as part of a business intelligence solution.  In some scenarios it may be...

SSRS – Using Analysis Services Dynamic Management Views to Build Dynamic Reports

Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They...

Using the Error Output of the Derived Column

The other day I was building a simple data import package when I ran into a common situation; invalid conversions in a Derived Column.  The conversion was taking an...

Using the Error Output of the Derived Column

The other day I was building a simple data import package when I ran into a common situation; invalid conversions...

Using the Error Output of the Derived Column

The other day I was building a simple data import package when I ran into a
common situation; invalid conversions in a Derived Column.  The conversion
was taking an ISBN13...

Your Road to Becoming a DBA: Acquiring Experience is Key

Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...

App Domains and Their Uses

What is an app domain
An App Domain can be thought of as a kind of lightweight process. So What is...

Detect Worst Performing SQL Queries - Part 2