You're welcome, Ron.  This is something I've had to do a lot in the healthcare domain.  Data points like vital event conditions, e.g. birth / death conditions, etc. are perfect...

RonKyle,
I see your point about junk dimensions, as that's where one would normally stick lone indicators.  But the solution documented here fits the case for code sets on which analysis is desired.  Case...

Hi RonKyle,

This approach creates non-junk dimensions that employ bit columns, each of which represents selected code values in a given code set.  This results in a fixed-length, very-rarely-changing dimension (it would only change when new...

Nehehe,

The technique illustrated in my article is used to create data warehouse dimensions that represent code sets.  This scenario isn't a one-size-fits-all solution, but more often than not,...

I partially concur with your assessment; sometimes cursors/while-loops are unavoidable when a given task cannot be achieved with a set operation. However, in my support of over 800 databases,...

Well done-- very useful!

Yes, there is a small security concern with having it continuously enabled. Optionally, you could enable it before the script and disable it after. Or, you could create...

I didn’t actually use the For Each Loop container, as I don’t connect to all my SQL Servers using Windows credentials.

But, if you do, here’s how you would use one:

1....

I see great minds think alike! I actually set out using a pure SSRS solution, but the report generation took too long because I have so many servers, so...