DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Materialized Views in SQL: Supercharging Read Performance

Materialized Views in SQL: Supercharging Read Performance

Comments
2 min read
Behind the Scenes: Reading SQL Execution Plans Like a Pro

Behind the Scenes: Reading SQL Execution Plans Like a Pro

Comments
3 min read
How to check the same status of data in each row within a group with esProc

How to check the same status of data in each row within a group with esProc

6
Comments
2 min read
Top 10 AI Reporting Tools in 2025

Top 10 AI Reporting Tools in 2025

9
Comments
8 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

8
Comments
4 min read
Optimizing SQL queries for your AI Agents.

Optimizing SQL queries for your AI Agents.

6
Comments
4 min read
Building Weekly Historical Insights with SQL Server, Python, SQLite, and Power BI

Building Weekly Historical Insights with SQL Server, Python, SQLite, and Power BI

Comments
1 min read
Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service

Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service

1
Comments 2
3 min read
Basics of Animal Tracking Databases: Crafting the Schema

Basics of Animal Tracking Databases: Crafting the Schema

Comments
4 min read
Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

Comments
3 min read
Taxi Drivers Efficiency Analysis with SQL & Tableau

Taxi Drivers Efficiency Analysis with SQL & Tableau

2
Comments 2
3 min read
23ai - Series Part 3 - CLOB vs JSON Data Type Realistic Stress Load Comparison on Weather Data

23ai - Series Part 3 - CLOB vs JSON Data Type Realistic Stress Load Comparison on Weather Data

Comments
125 min read
Navigating the Landscape of Data-Modeling – A Comprehensive Guide

Navigating the Landscape of Data-Modeling – A Comprehensive Guide

Comments 2
4 min read
Mastering SQL Window Functions: ROW_NUMBER vs RANK vs DENSE_RANK

Mastering SQL Window Functions: ROW_NUMBER vs RANK vs DENSE_RANK

Comments
2 min read
Mastering SQL Joins: Your Definitive Guide to Relational Data Mastery

Mastering SQL Joins: Your Definitive Guide to Relational Data Mastery

Comments
2 min read
DB_DEVELOPER_ROLE Role in Oracle Database 23ai

DB_DEVELOPER_ROLE Role in Oracle Database 23ai

Comments
3 min read
Ecto for Elixir: A Beginner's Guide to Database Interactions

Ecto for Elixir: A Beginner's Guide to Database Interactions

1
Comments
3 min read
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

6
Comments 1
2 min read
DuckDB 🦆 : Libérez le puissant moteur de Requêtes

DuckDB 🦆 : Libérez le puissant moteur de Requêtes

Comments
8 min read
SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

1
Comments
6 min read
What’s a database anyway?? A blog post for kids

What’s a database anyway?? A blog post for kids

10
Comments
14 min read
Get the Initial Date Using the Total — From SQL to SPL #35

Get the Initial Date Using the Total — From SQL to SPL #35

6
Comments 3
2 min read
SQL Query Optimization for Data Engineers

SQL Query Optimization for Data Engineers

11
Comments
3 min read
Understanding Data Anomalies and the Power of Database Normalization

Understanding Data Anomalies and the Power of Database Normalization

1
Comments 2
2 min read
How Indexes Really Work

How Indexes Really Work

Comments
5 min read
loading...