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 SKIP LOCKED Queue Can Run a Job Twice. Heartbeats and Fencing Tokens Make It Safe
gabrielanhaia profile

Your SKIP LOCKED Queue Can Run a Job Twice. Heartbeats and Fencing Tokens Make It Safe

#postgres #sql #python #architecture
Comments
9 min read
Joins In SQL
naomi_kwamboka1001 profile

Joins In SQL

#database #sql #tutorial
Comments
15 min read
SQL Server Interview Questions for Senior Developers in 2026 — Execution Plans, Indexing, Locking & Parameter Sniffing (Deep Answers)
kirandeepjassalcrypto profile

SQL Server Interview Questions for Senior Developers in 2026 — Execution Plans, Indexing, Locking & Parameter Sniffing (Deep Answers)

#sql #database #interview #performance
Comments
4 min read
Logging in PL/SQL that survives ROLLBACK (and 4 mistakes to avoid)
sabuhi_khalilov profile

Logging in PL/SQL that survives ROLLBACK (and 4 mistakes to avoid)

#oracle #plsql #database #sql
Comments
3 min read
SQL for Hospital Data Analysis: Window Functions, Joins, CTEs, and Subqueries
maditech profile

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

#sql #analytics #datascience #tutorial
Comments
14 min read
Convert CSV to SQL INSERT Statements Quickly (Without Breaking Your Data)
hammadrasool2000svg profile

Convert CSV to SQL INSERT Statements Quickly (Without Breaking Your Data)

#sql #csv #database #tutorial
Comments
4 min read
Joins In PostgreSQL
im_nishant profile

Joins In PostgreSQL

#postgressql #postgres #sql #database
Comments
5 min read
SQL Injection Prevention: Developer's Security Checklist
rasimcarkci profile

SQL Injection Prevention: Developer's Security Checklist

#security #webdev #sql #beginners
Comments
6 min read
I Built a Free SSMS Extension Because SQL Prompt Is Too Expensive
pulushen profile

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

#sqlserver #ssms #sql #dba
Comments
4 min read
Window Functions: A guide to mastery.
ezzy_kinyua profile

Window Functions: A guide to mastery.

#database #sql #datascience
Comments
6 min read
Server-side sorting and filtering for a React data grid, and five places your SQL quietly disagree
kanunilabs profile

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

#react #postgres #sql #webdev
Comments
9 min read
Reading the CVSS 9.8 score of CVE-2026-108474 without overreading it
facilishz profile

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

#cybersecurity #database #security #sql
Comments
2 min read
Joins in SQL; A Deep Dive
ezzy_kinyua profile

Joins in SQL; A Deep Dive

#sql #database #datascience
Comments
3 min read
Transpile or Re-Ask: Fixing Dialect Breaks in Agent-Written SQL
dataio_4921 profile

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

#sql #ai #database #testing
Comments
5 min read
SQL beginners: what should happen after your first query?
aleks_sqlbrief profile

SQL beginners: what should happen after your first query?

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