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.
Your hiring chart may measure who posts most often

Your hiring chart may measure who posts most often

Comments
7 min read
Joins In PostgreSQL

Joins In PostgreSQL

Comments
5 min read
SQL Injection Prevention: Developer's Security Checklist

SQL Injection Prevention: Developer's Security Checklist

Comments
6 min read
I Built a Free SSMS Extension Because SQL Prompt Is Too Expensive

I Built a Free SSMS Extension Because SQL Prompt Is Too Expensive

Comments
4 min read
Window Functions: A guide to mastery.

Window Functions: A guide to mastery.

Comments
6 min read
Server-side sorting and filtering for a React data grid, and five places your SQL quietly disagree

Server-side sorting and filtering for a React data grid, and five places your SQL quietly disagree

Comments
9 min read
Free SQL practice: why SUM(DISTINCT) doesn't fix inflated payment totals

Free SQL practice: why SUM(DISTINCT) doesn't fix inflated payment totals

Comments
5 min read
Reading the CVSS 9.8 score of CVE-2026-108474 without overreading it

Reading the CVSS 9.8 score of CVE-2026-108474 without overreading it

Comments
2 min read
Joins in SQL; A Deep Dive

Joins in SQL; A Deep Dive

Comments
3 min read
Transpile or Re-Ask: Fixing Dialect Breaks in Agent-Written SQL

Transpile or Re-Ask: Fixing Dialect Breaks in Agent-Written SQL

Comments
5 min read
I ran my text-to-SQL access control on a benchmark I didn't write

I ran my text-to-SQL access control on a benchmark I didn't write

Comments
3 min read
One Null in the Subquery and Your NOT IN Returned Nothing

One Null in the Subquery and Your NOT IN Returned Nothing

Comments
2 min read
PostgreSQL Isolation Levels Explained with Python

PostgreSQL Isolation Levels Explained with Python

1
Comments 1
26 min read
# SQL for Data Analysis: Window Functions, Joins, CTEs and Subqueries

# SQL for Data Analysis: Window Functions, Joins, CTEs and Subqueries

Comments
7 min read
How to Optimize SQL Queries: 20 Proven Best Practices

How to Optimize SQL Queries: 20 Proven Best Practices

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