SQL

Articles tagged: SQL

Turning SQL into Data Lineage with the Dataedo SQL Parser
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 Michał Trybulec 10 min read
New free Dataedo tool: SQL Query Analyzer
Products and News

New free Dataedo tool: SQL Query Analyzer

Anna Sztabkowska Anna Sztabkowska 2 min read
Test If Your Database Has Foreign Keys Or Is It Full of Loners (Metric + Test 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 Piotr Kononow 7 min read
6 Useful SQL Server Data Dictionary Queries Every DBA Should Have
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 Magda Lakomiec 11 min read
How to Document Stored Procedures and Functions in Database
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 Piotr Kononow 5 min read
2 Common SQL Join Traps (with Test Queries)
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 Piotr Kononow 4 min read
6 Useful Oracle Data Dictionary Queries Every DBA Should Have
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 Piotr Kononow 12 min read
Is Lack of Database Documentation a Global Problem for Software Developers?
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 Piotr Kononow 2 min read