SQL Script: Distinct Column Values Across All Tables

Sometimes I wonder if some of the more random scripts I post are useful to anyone but me so if this one is useful to you definitely drop a comment below! Check it out:  Our team was trying to confirm what our best practice was when creating flag columns in the data warehouse.  As usual… Continue reading SQL Script: Distinct Column Values Across All Tables

The Four Database Design Principles You Should Be Using

"Obey the principles without being bound by them." -Bruce Lee   Do you have some guiding principles you use when designing a new feature or when implementing a new requirement?  I do.  And you should too.  I put them to paper a few years ago while we were undergoing a hiring binge and I wanted… Continue reading The Four Database Design Principles You Should Be Using