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.
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles

Comments
5 min read
How I Made Sure You Can't Like and Dislike the Same Post at Once

How I Made Sure You Can't Like and Dislike the Same Post at Once

5
Comments
3 min read
Why schema drift goes undetected

Why schema drift goes undetected

Comments 2
7 min read
Data Types and So much more

Data Types and So much more

Comments
2 min read
The Afternoon We Put Magento's Schema on SQL Server

The Afternoon We Put Magento's Schema on SQL Server

1
Comments
40 min read
Top N per group is the query `LIMIT` can't write

Top N per group is the query `LIMIT` can't write

Comments
3 min read
How to compare two PostgreSQL schemas

How to compare two PostgreSQL schemas

1
Comments
6 min read
BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

1
Comments
5 min read
Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning

Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning

1
Comments
3 min read
SQLite vs PostgreSQL: Choosing the Right Database

SQLite vs PostgreSQL: Choosing the Right Database

Comments
5 min read
Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.

Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.

Comments 1
3 min read
Building a School Database with PostgreSQL: My SQL Week 2 Journey

Building a School Database with PostgreSQL: My SQL Week 2 Journey

1
Comments
4 min read
Why I Built a Free SSMS Extension to Stop Destructive Queries

Why I Built a Free SSMS Extension to Stop Destructive Queries

Comments 1
3 min read
Why SQL Is Still the Most Important Skill for Data Engineers

Why SQL Is Still the Most Important Skill for Data Engineers

Comments
3 min read
You don't need a backend to store form submissions. You need a place to ask "how many."

You don't need a backend to store form submissions. You need a place to ask "how many."

1
Comments 1
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.