Alter Table: Add Not Null Column – SQL Server

Listen up my people.  NOT NULL columns are your friend.  It may take a few extra brain cells to populate it initially but the long term rewards in data quality are well worth it. (You'll also force all your software developer cohorts to think specifically about the values they'll be inserting into a column which… Continue reading Alter Table: Add Not Null Column – SQL Server

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

The Three Best Tips For Effective Code Reviews And Preventing Knife Fights!

Bring a group of senior business intelligence professionals or SQL Server pros together to review each others code and you have all the potential for a good knife fight.  As our team is getting ready to make design/code reviews a regular part of our development process we're looking to make sure we get off on… Continue reading The Three Best Tips For Effective Code Reviews And Preventing Knife Fights!