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.
LLMSQL&Arabic WikiTableQA&Payment-SQL:SQL Dataset(202510)

LLMSQL&Arabic WikiTableQA&Payment-SQL:SQL Dataset(202510)

1
Comments
5 min read
Optimizing SQL LIKE Security, Performance and Best Practices

Optimizing SQL LIKE Security, Performance and Best Practices

Comments
10 min read
SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

Comments
4 min read
Using LIKE with Variables and Patterns in SQL

Using LIKE with Variables and Patterns in SQL

Comments
10 min read
A Minimal Go Toolkit for Cleaning, Validating, and Querying CSV/TSV/Excel/Parquet Files

A Minimal Go Toolkit for Cleaning, Validating, and Querying CSV/TSV/Excel/Parquet Files

Comments
3 min read
Computed columns in D365FO – Using Correlated Subqueries with Real SQL

Computed columns in D365FO – Using Correlated Subqueries with Real SQL

1
Comments
2 min read
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
PART 5 — The Rise of Network SQL (N-SQL)

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

4
Comments
26 min read
dupl

dupl

Comments
1 min read
catalog

catalog

Comments
1 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
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
What is Cyber Resilience Act, and what cybersecurity requirements does it impose?

What is Cyber Resilience Act, and what cybersecurity requirements does it impose?

1
Comments
7 min read
Quick Recap: SQL Databases

Quick Recap: SQL Databases

Comments
2 min read
How to Limit Comment Nesting Depth in Self-Referencing Tables

How to Limit Comment Nesting Depth in Self-Referencing Tables

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
Simple Tweaks That Make SQLite Lookup Faster – Part 1

Simple Tweaks That Make SQLite Lookup Faster – Part 1

6
Comments
4 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
No, MongoDB Does Not Mean Skipping Design

No, MongoDB Does Not Mean Skipping Design

7
Comments 1
6 min read
loading...