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.
Introducing the All-New SLS SQL Copilot

Introducing the All-New SLS SQL Copilot

Comments
15 min read
Building a Realistic Banking Dummy Data Generator with Bad-Data Simulation

Building a Realistic Banking Dummy Data Generator with Bad-Data Simulation

1
Comments
1 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
Google Cloud SQL: The Ultimate Guide to Managed Relational Databases

Google Cloud SQL: The Ultimate Guide to Managed Relational Databases

6
Comments
4 min read
Mastering SQL: Revisiting the Basics

Mastering SQL: Revisiting the Basics

Comments
3 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
Quick Recap: SQL Databases

Quick Recap: SQL Databases

Comments
2 min read
When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

5
Comments 4
8 min read
Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Comments
3 min read
Best Practices for Connecting LLMs to SQL Databases

Best Practices for Connecting LLMs to SQL Databases

2
Comments
5 min read
SLS Copilot in Practice: Building a Flexible Data Infrastructure for LLM Applications with SLS

SLS Copilot in Practice: Building a Flexible Data Infrastructure for LLM Applications with SLS

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