Database Normalization

Embark on Your Database Normalization Journey

Best Practices for Database Naming Conventions

A personally weighted list of naming conventions for new SQL databases

Random functions in MS SQL

Exploring random functions and their uses in MS SQL

Bulk upsert data to MSSQL

Using MERGE in SP to UPSERT data to MSSQL with C#

Upsert in databases

Upsert data in databases

Levenshtein distance in databases

Should you use levenshtein distance in databases?