The modern system empowers data producers to change but disempowers the people whose job it is to provide stability. Most organizations have some data platform team whose job it is to provide ...

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema.

Currently, dbtpl can generate types for tables, enums, stored procedures, and custom SQL queries for PostgreSQL, MySQL, Oracle, Microsoft SQL Server, and SQLite3 databases.

Pigeons in the garden are a constant annoyance but I got rid of pigeons by making one bird table change.

About This an extension for SQL Server Management Studio (SSMS). It groups sql objects in Object Explorer (tables, views, etc.) into schema folders.