Reference data belongs in governed lookup tables with stable codes, clear owners, and a release process that keeps environments aligned.
SQL SERVER – Disable Clustered Index and Data Insert
A client’s DBA disabled every clustered index before a bulk insert, and the application stopped working. What happens when you disable clustered index?
SQL SERVER – GUID vs INT – Your Opinion
GUID vs INT as a primary key or clustered index: I list one advantage and one disadvantage of each and ask you to add yours in the comments.
Storing Percentages: 0.15 or 15, and How to Tell Them Apart
Storing percentages starts with a declared unit. Fractional rates and percentage points require different conversions, even when both pass a range check. Use named columns, explicit boundaries and a guarded disposable fixture.
SQL SERVER – Create Primary Key with Specific Name when Creating Table
How do you create a primary key with specific name while creating the table itself? One CREATE TABLE statement can define and name the constraint.
Modeling Data Before Writing Tables
Modeling data before tables clarifies entities, relationships, keys, and grain so schema changes do not discover the rules too late.
Building Your Own Sample Data Set
Build a sample data set with realistic keys, skew, NULLs, and repeatable generation when a downloaded sample misses the lesson.