CHECKSUM vs HashBytes

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

Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget

Charts present summary data in a visually appealing format. Following is a chart for sales over month:

Before
I frequently use a few...

DevConnections Offers DBAs Many Options for Training

As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...

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

Learning, Networking & Wine

Let’s say, you want to spend a couple of days learning about SQL Server. You also want to spend some...

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