Could not agree more!  btw... I intended to click '5 stars', mouse slipped, and clicked 2... could not find a way to update to 5... apologies!!!!

I come from a manufacturing operations background.  DevOps applies many concepts of the Toyota Production System (aka 'just in time') that have been honed by that company since the middle...

Very appropriately titled 🙂  I use tinyints in some specific cases, and had not realized they are not allowed to go negative.  I will certainly take that into consideration moving...

I agree with all of the reasons given for use of surrogate keys.  Two thoughts come up for me...

Very eloquently said. Agree 100%.

Completely agree. Had never thought of it in the sense you present of "job A" v. "job B".... that's a nice way to think about it.

Another thing...

Thank you! for the post! I've been intending to start learning how to work in Azure, but wasn't real sure where to start, and have not had time to...

Thanks for the very clean example giving a basic understanding of the potential impact of type conversions. Enjoyed it!

I agree with bwild that learning DAX "all comes down to whether you want to learn something new and spend the time getting there or not". I am also...

Thanks!

Jeff Moden (7/15/2013)

It's probably not the answer you're looking for but I'd recommend talking with the DBA to get some decent utility code promoted so people can do their job....

Agree completely, but wasn't sure a better alternative (the excel method has been worse for users than the CTE method so far). What would you recommend, assuming no write...

Thanks for the well written, clear, and simple tutorial. I use CTE's a lot as they've proven very useful when needing to manipulate data without write access in a...

Interesting and good to know! I come from a functional background, and when I encountered this did not know it was a 'standard' way to do things. At...