Test If Your Database Has Foreign Keys Or Is It Full of Loners (Metric + Test Queries)
Piotr Kononow
Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a method to measure your database.
SQL Articles
6 Useful SQL Server Data Dictionary Queries Every DBA Should Have
Magda Lakomiec
List of SQL queries for SQL Server Catalog / Data Dictionary handy for any DBA.
How to Document Stored Procedures and Functions in Database
A compilation of best practices documenting stored procedures and functions in relational databases.
2 Common SQL Join Traps (with Test Queries)
There are 2 very common traps (with serious consequences) you can easily fall into while joining tables in an SQL query. Learn what they are and how to avoid them.
6 Useful Oracle Data Dictionary Queries Every DBA Should Have
List of SQL queries for Oracle Data Dictionary handy for any Oracle DBA.
Is Lack of Database Documentation a Global Problem for Software Developers?
See what polls tell us about software developers' struggles in the area of databases.