The double-loop is a little odd, but otherwise I don't see anything that makes me really question the overall idea. Including the table def + the script in one ticket...

Conceptually, how would you handle NULL DB values going through this process when you hit the Conditional Split transform? Would you ensure there were no NULL values by tweaking the...

Well, I recreated the dimension completely and this time it worked. I don't know what I did differently, but I did mess around with the relationships quite a bit the...

aochss (7/10/2014)

---

Please, please make the error/warning messages better and more precise...Nothing worse than something like this:

Msg 8152, Level 16, State 14, Line 1

String or binary data would be truncated.

The statement...

I enjoyed the article and didn't take it as preaching. Motivation to keep looking for a solution/better solution - yes, but not preaching. However, there does exist the possibility that...

I ended up knowing this mostly because we use custom permissions w/ SSDT (to handle multiple environments and based on Jamie Thomson's work). Without including the "GRANT CONNECT" statement, we...

I'm using SSDT as well - free to use and works really well with SQL Server (with a learning curve). I'm trusting Dave to go with what he knows and...

One thing worth mentioning that bit me recently - SSMS doesn't script out compression levels by default. We had a handful of indexes that were compressed and I had to...

We used to push all of our changes and do lots of management through the GUI or by manually running scripts, installers, copying bits, etc. We slowly (and sometimes painfully)...

How much more would you want than the answers in that forum topic? That pretty much sums it up. 🙂 (besides an example or two, perhaps)

I could do this using SSDT to push the DB changes from Dev to (Test, Prod, etc.). I don't know if that's what you want or not, though. I've...

Steve, I could do this for SSDT, but not for Red-Gate. I don't know if that would work or not, but I'd be willing to take on an SSDT article...

Good points, John. I tend to avoid correlated sub-queries as much as possible because there are usually better ways to accomplish the same result. That doesn't mean they're bad -...

JediSQL (3/20/2014)

---

Regarding cursors: One of my DBAs had starting writing WHILE loops to avoid cursors. I was enhancing some of her code like this, and I started to...

I've run into issues before trying to concatenate a large string and EXEC that using sp_executesql. It's definitely a solution for some people, but at least one time I tried...