SQL

Products and News

Turning SQL into Data Lineage with the Dataedo SQL Parser

The Dataedo SQL Parser is a core engine designed to analyze SQL code and extract meaningful metadata from it.

Michał Trybulec 10 min read

Products and News

New free Dataedo tool: SQL Query Analyzer

Anna Sztabkowska 2 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

Database Design & Metadata

How to Document Stored Procedures and Functions in Database

A compilation of best practices documenting stored procedures and functions in relational databases.

Piotr Kononow 5 min read

Database Design & Metadata

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....

Piotr Kononow 4 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

Database Design & Metadata

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.

Piotr Kononow 2 min read