Hero image!
May 07, 2024 - Drygast

Useful MySQL commands

A couple of MySQL commands/queries that might be useful.
April 22, 2024 - Drygast

Database Normalization

Embark on Your Database Normalization Journey
March 07, 2024 - Drygast

Best Practices for Database Naming Conventions

A personally weighted list of naming conventions for new SQL databases
March 03, 2024 - Drygast

Random functions in MS SQL

Exploring random functions and their uses in MS SQL
March 01, 2024 - Drygast

Bulk upsert data to MSSQL

Using MERGE in SP to UPSERT data to MSSQL with C#
January 16, 2024 - Drygast

Upsert in databases

Upsert data in databases
September 17, 2023 - Drygast

Levenshtein distance in databases

Should you use levenshtein distance in databases?
June 27, 2023 - Drygast

MySQL tips and tricks

A couple of snippets that might come in handy
June 26, 2023 - Drygast

Should I use datetime or timestamp in MySQL?

My thought on datetime vs. timestamp in MySQL