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 for Developers: The Practical Guide (2026)
armorbreak profile

SQL for Developers: The Practical Guide (2026)

#beginners #database #sql #tutorial
Comments
5 min read
Your LLM fused the two columns you asked for — and the eval marked it wrong
omer_hochman profile

Your LLM fused the two columns you asked for — and the eval marked it wrong

#sql #llm #ai
Comments
3 min read
# Modernizing the Pitch: Building an Automated SQL Data Quality and Transformation Pipeline for Multi-Club Scouting Platforms
ishak_ahmed_1ea86b2efd2b9 profile

# Modernizing the Pitch: Building an Automated SQL Data Quality and Transformation Pipeline for Multi-Club Scouting Platforms

#automation #data #dataengineering #sql
Comments
5 min read
Clustered Indexes in SQL Server: How Data is Stored for Faster Queries
namrata_khorjuwekar_ profile

Clustered Indexes in SQL Server: How Data is Stored for Faster Queries

#sql #database #performance #backend
Comments
4 min read
AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions
marcus1968 profile
Marcus

AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions

#ai #claude #sql #database
Comments
7 min read
As 12 Regras de Codd: o que torna um banco de dados realmente relacional?
carlos-delfino profile

As 12 Regras de Codd: o que torna um banco de dados realmente relacional?

#sgbd #sql #sqlserver #mariadb
1
Comments
7 min read
LLM SQL Guard Architecture: Parser, Catalog, Policy Engine, Audit Log
_706015150500ca0399b12 profile

LLM SQL Guard Architecture: Parser, Catalog, Policy Engine, Audit Log

#architecture #llm #security #sql
Comments
1 min read
Understanding the Key Differences Between SQL and NoSQL Databases
jefersoneiji profile

Understanding the Key Differences Between SQL and NoSQL Databases

#sql #nosql #database #comparison
Comments
1 min read
Oracle ORA-00215 Error: Causes and Solutions Complete Guide
dbmserror profile

Oracle ORA-00215 Error: Causes and Solutions Complete Guide

#oracle #database #dba #sql
Comments
3 min read
PostgreSQL 20000 Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 20000 Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
Comments
3 min read
Scaling n8n with PostgreSQL and Redis on Upsun 🚀
florabrandao profile

Scaling n8n with PostgreSQL and Redis on Upsun 🚀

#sql
Comments
1 min read
SQL Server Heaps: Understanding Tables Without Clustered Indexes
namrata_khorjuwekar_ profile

SQL Server Heaps: Understanding Tables Without Clustered Indexes

#sql #database #performance #backend
1
Comments
4 min read
Normalization vs. Denormalization: The Great Database Debate
ibrahim0695 profile

Normalization vs. Denormalization: The Great Database Debate

#architecture #database #performance #sql
1
Comments 1
2 min read
Building an Atomic Delivery Dispatcher with PostgreSQL Row-Level Locking
poojang profile

Building an Atomic Delivery Dispatcher with PostgreSQL Row-Level Locking

#backend #database #postgres #sql
Comments
5 min read
Oracle ORA-00206 Error: Causes and Solutions Complete Guide
dbmserror profile

Oracle ORA-00206 Error: Causes and Solutions Complete Guide

#oracle #database #dba #sql
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.