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

SQL_Sheet

1
Comments
3 min read
Oracle to Snowflake migration validation: a six-gate acceptance framework

Oracle to Snowflake migration validation: a six-gate acceptance framework

Comments
4 min read
Postgres "deadlock detected": Fix the Lock Order First, Then Add a Retry

Postgres "deadlock detected": Fix the Lock Order First, Then Add a Retry

Comments 1
6 min read
The dbt test that would have caught our duplicate orders

The dbt test that would have caught our duplicate orders

Comments 1
1 min read
The 4 kinds of ALTER TABLE that cause production incidents (and a 5-minute review for each)

The 4 kinds of ALTER TABLE that cause production incidents (and a 5-minute review for each)

Comments
4 min read
SQL Joins Explained with One Tiny Dataset (Plus 5 Interview Questions)

SQL Joins Explained with One Tiny Dataset (Plus 5 Interview Questions)

Comments
5 min read
Validando CPF dentro do PostgreSQL: função, CHECK constraint e domínio

Validando CPF dentro do PostgreSQL: função, CHECK constraint e domínio

Comments
3 min read
Flag Office Visits Within 6 Months After Surgery

Flag Office Visits Within 6 Months After Surgery

5
Comments
6 min read
How to format SQL without uploading your queries

How to format SQL without uploading your queries

Comments
2 min read
Why my database client makes you review every edit before it runs

Why my database client makes you review every edit before it runs

Comments
1 min read
Fifteen numbers on one admin page, one round trip, and a row count Postgres never counts

Fifteen numbers on one admin page, one round trip, and a row count Postgres never counts

Comments
5 min read
The list shows two numbers, so the query digs them out of the JSON instead of loading a hundred attempts

The list shows two numbers, so the query digs them out of the JSON instead of loading a hundred attempts

Comments
4 min read
Free Draft Volume or Paid First Passes: A Debate for Agent SQL Budgets

Free Draft Volume or Paid First Passes: A Debate for Agent SQL Budgets

Comments
6 min read
DBeaver SQL Summary Learning Notes

DBeaver SQL Summary Learning Notes

Comments
4 min read
The SQL Behind an AI Visibility Dashboard: Five Metrics and Their Traps

The SQL Behind an AI Visibility Dashboard: Five Metrics and Their Traps

Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.