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 to Grade Search Relevance Before You Touch the Ranking Weights
libme profile

How to Grade Search Relevance Before You Touch the Ranking Weights

#postgres #database #sql #testing
Comments
6 min read
Your Test Went Red. Can You Read It?
onurkesim profile

Your Test Went Red. Can You Read It?

#postgres #testing #sql #debugging
Comments
8 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 5: Where AI Actually Helped
kostyabartashevich profile

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 5: Where AI Actually Helped

#ai #database #azure #sql
Comments
6 min read
How to Test Search Relevance Before You Ship a Ranking Change
libme profile

How to Test Search Relevance Before You Ship a Ranking Change

#postgres #database #testing #sql
Comments 2
6 min read
Shadow-Gate Your LLM-Generated SQL: A Replay Test Against a Frozen Fixture Database
dataio_4921 profile

Shadow-Gate Your LLM-Generated SQL: A Replay Test Against a Frozen Fixture Database

#sql #testing #ai #tutorial
Comments
6 min read
A New Model Dropped. Is It Actually Good at Your SQL? A 30-Minute Smoke Test
dataio_4921 profile

A New Model Dropped. Is It Actually Good at Your SQL? A 30-Minute Smoke Test

#ai #sql #testing #opensource
Comments
4 min read
The text-to-SQL demo takes an afternoon. The other 90% is why you should buy it.
omer_hochman profile

The text-to-SQL demo takes an afternoon. The other 90% is why you should buy it.

#sql #database #ai #webdev
Comments 1
3 min read
Your companies table is lying to you about when things happened
corpdigest profile

Your companies table is lying to you about when things happened

#database #sql #datascience
Comments
2 min read
SEQUENCE vs IDENTITY in SQL Server: Choosing the Right Auto-Increment
tygryso profile

SEQUENCE vs IDENTITY in SQL Server: Choosing the Right Auto-Increment

#sqlserver #database #sql #olap
1
Comments
6 min read
# 🔬 PostgreSQL Internals: What Is Actually Inside an 8 KB Page?
ahmedraza_fyntune profile

# 🔬 PostgreSQL Internals: What Is Actually Inside an 8 KB Page?

#database #webdev #postgres #sql
Comments
5 min read
From Raw Tables to Business Insights: A SQL Workflow Every SaaS Team Can Use
vivekdraxlr profile

From Raw Tables to Business Insights: A SQL Workflow Every SaaS Team Can Use

#sql #database #analytics #tutorial
Comments
5 min read
SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each
jonathan_kip profile

SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each

#sql #datascience #beginners
2
Comments
4 min read
Dominando SQL para la Ciberseguridad: De la Selección Básica a la Detección de Amenazas
ce4vjpcode profile

Dominando SQL para la Ciberseguridad: De la Selección Básica a la Detección de Amenazas

#cybersecurity #database #sql
Comments
3 min read
Your text-to-SQL model isn't as wrong as your benchmark says. The gold SQL is.
omer_hochman profile

Your text-to-SQL model isn't as wrong as your benchmark says. The gold SQL is.

#sql #llm #ai
Comments 1
3 min read
How We Query 1.2 Billion Rows in Under 50ms — Partitioning, Columnstore, and Read Models at Scale
kirandeepjassalcrypto profile

How We Query 1.2 Billion Rows in Under 50ms — Partitioning, Columnstore, and Read Models at Scale

#sql #systemdesign #azure #dotnet
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.