Forem

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.
Getting Started with SQL: A Guide for Data Analysts

Getting Started with SQL: A Guide for Data Analysts

Comments 1
2 min read
Olake (Lakehouse)
Cover image for Olake (Lakehouse)

Olake (Lakehouse)

Comments
2 min read
Apresentação do Repositório Dotnet Templates

Apresentação do Repositório Dotnet Templates

Comments
2 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has 😻
Cover image for Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

8
Comments 2
5 min read
Top 5 Alternative Data Career Paths (And How to Learn Each for Free)
Cover image for Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Comments 2
4 min read
Backup (and restore) an Sql database inside a docker container.
Cover image for Backup (and restore) an Sql database inside a docker container.

Backup (and restore) an Sql database inside a docker container.

Comments
1 min read
10 SQL Anti-Patterns You Must Avoid in Production

10 SQL Anti-Patterns You Must Avoid in Production

2
Comments
2 min read
Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

1
Comments
2 min read
Working with JSON in PostgreSQL, MySQL & SQL Server

Working with JSON in PostgreSQL, MySQL & SQL Server

1
Comments
2 min read
SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

Comments
2 min read
Think in Sets: Writing High-Performance SQL the Declarative Way

Think in Sets: Writing High-Performance SQL the Declarative Way

Comments
2 min read
Querying the Past: Temporal Tables in SQL Server and PostgreSQL

Querying the Past: Temporal Tables in SQL Server and PostgreSQL

1
Comments
2 min read
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
Top 10 AI Reporting Tools in 2025
Cover image for 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
Cover image for Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

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

7
Comments
4 min read
Optimizing SQL queries for your AI Agents.
Cover image for Optimizing SQL queries for your AI Agents.

Optimizing SQL queries for your AI Agents.

5
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
Cover image for 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
Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

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

Basics of Animal Tracking Databases: Crafting the Schema

Comments
4 min read
Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Comments
2 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
Taxi Drivers Efficiency Analysis with SQL & Tableau
Cover image for Taxi Drivers Efficiency Analysis with SQL & Tableau

Taxi Drivers Efficiency Analysis with SQL & Tableau

2
Comments 1
3 min read
Navigating the Landscape of Data-Modeling – A Comprehensive Guide
Cover image for Navigating the Landscape of Data-Modeling – A Comprehensive Guide

Navigating the Landscape of Data-Modeling – A Comprehensive Guide

Comments 2
4 min read
loading...