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 Beyond SELECT: Understanding SQL Sublanguages.

SQL Beyond SELECT: Understanding SQL Sublanguages.

Comments
7 min read
SQL_Sheet

SQL_Sheet

1
Comments
3 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
Database Indexing: The Performance Trick Nobody Explained Properly

Database Indexing: The Performance Trick Nobody Explained Properly

1
Comments
9 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
100% activation, three inactive users: a SQL interview trap

100% activation, three inactive users: a SQL interview trap

Comments
9 min read
Migrating On-Prem SQL Server to Azure SQL PaaS: How We Cut Infrastructure Costs by 25%

Migrating On-Prem SQL Server to Azure SQL PaaS: How We Cut Infrastructure Costs by 25%

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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.