SQL Server

Database Design & Metadata

Extended Properties for Database Documentation - Good or Bad?

Extended Properties are cool feature of SQL Server but are they suitable for documentation of schema. See pros and cons....

Adam Adamowicz 2 min read

Metadata Tools

How to Document SQL Server Database Using Visual Studio 2015

A tutorial that shows how to document SQL Server database with Visual Studio and then export it to PDF and HTML.

Lukasz Gil 7 min read

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

Metadata Tools

Redgate SQL Doc vs Dataedo - Documenting Existing Databases

A comparison between two database documentation tools - Dataedo and Redgate SQL Doc.

Piotr Kononow 6 min read