Queries

Database Design & Metadata

Test If Your Database Has Foreign Keys Or Is It Full of Loners (Metric + Test Queries)

Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a me...

Piotr Kononow 7 min read

Database Design & Metadata

6 Useful SQL Server Data Dictionary Queries Every DBA Should Have

List of SQL queries for SQL Server system catalog / data dictionary handy for any DBA.

Magda Lakomiec 11 min read

Database Design & Metadata

6 Useful Oracle Data Dictionary Queries Every DBA Should Have

List of handy SQL queries to the Oracle database data dictionary

Piotr Kononow 12 min read