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 JourneyMarch 07, 2024 - Drygast
Best Practices for Database Naming Conventions
A personally weighted list of naming conventions for new SQL databasesMarch 03, 2024 - Drygast
Random functions in MS SQL
Exploring random functions and their uses in MS SQLMarch 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 databasesSeptember 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 handyJune 26, 2023 - Drygast