CHECKSUM vs HashBytes

Hashing can be useful in Data Warehousing  as well  It can give you the ability to break large problems into...

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

Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012

Atlanta MDF presents: SQL Saturday #111 Pre-Conference Sessions SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve managed to schedule 3 awesome pre-con sessions...

Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012

Atlanta MDF presents:

SQL Saturday #111 Pre-Conference Sessions
SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve...

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

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 in a Derived Column.  The conversion
was taking an ISBN13...

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

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

February Question: If you weren’t a DBA, what would you like to do?

Sometimes its fun to think of what career you might have chosen if you hadn’t become a DBA. With this...