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.
How I Automated 90% of Data Requests Using LLM-Powered SQL Generation

How I Automated 90% of Data Requests Using LLM-Powered SQL Generation

5
Comments 2
7 min read
Database Transactions and ACID Properties: Guaranteeing Data Consistency

Database Transactions and ACID Properties: Guaranteeing Data Consistency

Comments
8 min read
EP 13: SQL Injection Isn't Dead - It Just Evolved

EP 13: SQL Injection Isn't Dead - It Just Evolved

1
Comments
3 min read
PART 5 — The Rise of Network SQL (N-SQL)

PART 5 — The Rise of Network SQL (N-SQL)

4
Comments
26 min read
catalog

catalog

Comments
1 min read
dupl

dupl

Comments
1 min read
Stop Using NOT EXISTS? Unveiling the Optimization Secrets of LEFT JOIN Anti-Join

Stop Using NOT EXISTS? Unveiling the Optimization Secrets of LEFT JOIN Anti-Join

Comments
5 min read
Introducing the All-New SLS SQL Copilot

Introducing the All-New SLS SQL Copilot

Comments
15 min read
I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.

I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.

6
Comments 2
2 min read
🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

Comments
2 min read
select2

select2

Comments
1 min read
Week 4_b of 40 – Adding Persistence with SQLite

Week 4_b of 40 – Adding Persistence with SQLite

Comments
1 min read
How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

Comments
2 min read
How I Create PDF Reports from SQL Server in C# Using IronPDF (Beginner Guide)

How I Create PDF Reports from SQL Server in C# Using IronPDF (Beginner Guide)

2
Comments
5 min read
Mastering SQL: Revisiting the Basics

Mastering SQL: Revisiting the Basics

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