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.
Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours
marcus1968 profile

Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours

#sql #sqlserver #xml #database
Comments
41 min read
How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes
lingamsuyambu profile

How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes

#sql #sqlserver #database #performance
Comments
4 min read
Бухгалтерия на естественном языке: каким должен быть MCP-сервер. Часть 4
andreik profile

Бухгалтерия на естественном языке: каким должен быть MCP-сервер. Часть 4

#ai #sql #llm #mcp
Comments
1 min read
Бухгалтерия на естественном языке: каким должен быть MCP-сервер. Часть 3
andreik profile

Бухгалтерия на естественном языке: каким должен быть MCP-сервер. Часть 3

#mcp #ai #llm #sql
Comments
2 min read
Бухгалтерия на естественном языке: каким должен быть MCP-сервер. Часть 2
andreik profile

Бухгалтерия на естественном языке: каким должен быть MCP-сервер. Часть 2

#mcp #llm #ai #sql
Comments
2 min read
NL2SQL: cómo leer un 83,80 en BIRD Mini-Dev con un evaluador de precisión de ejecución en Python
_0e3192755d4df45b92 profile

NL2SQL: cómo leer un 83,80 en BIRD Mini-Dev con un evaluador de precisión de ejecución en Python

#ai #python #sql #benchmarks
Comments
9 min read
CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction
labyrinthlab profile

CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction

#postgres #sql #database #devops
Comments
3 min read
Two salary ranges do not establish an exchange rate
dataspryva profile

Two salary ranges do not establish an exchange rate

#datascience #python #analytics #sql
Comments
7 min read
My open-source text-to-SQL layer is #1 on BIRD Mini-Dev in all three dialects
ashish_sinha_5241c7673d93 profile

My open-source text-to-SQL layer is #1 on BIRD Mini-Dev in all three dialects

#sql #database #ai #opensource
Comments
1 min read
SQL EXISTS vs JOIN: Find Customers Who Have Placed an Order
kailas_warade_d2a15d1ef8a profile

SQL EXISTS vs JOIN: Find Customers Who Have Placed an Order

#sql #database #programming #sqlserver
Comments
3 min read
Deadlocks με ένα συγκεκριμένο παράδειγμα
__b63657 profile

Deadlocks με ένα συγκεκριμένο παράδειγμα

#dotnet #csharp #sql
Comments
1 min read
Isolation levels με απλά παραδείγματα
__b63657 profile

Isolation levels με απλά παραδείγματα

#dotnet #csharp #entityframework #sql
Comments
1 min read
CDC Deletes, Tombstones and the Idempotent MERGE
pipelinewhiteboard profile

CDC Deletes, Tombstones and the Idempotent MERGE

#dataengineering #kafka #snowflake #sql
Comments
7 min read
Your match results can put a club in the wrong relegation spot
dataspryva profile

Your match results can put a club in the wrong relegation spot

#datascience #python #analytics #sql
Comments
6 min read
Tracing AI Agents with OpenTelemetry: A Design for LLM and Agentic AI Observability
bonree-js profile

Tracing AI Agents with OpenTelemetry: A Design for LLM and Agentic AI Observability

#discuss #ai #devops #sql
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.