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.
Build an MCP Server in C# That Safely Queries SQL Server

Build an MCP Server in C# That Safely Queries SQL Server

1
Comments 2
17 min read
Stop Guessing: Building a Clarification Gate for Text-to-SQL Agents

Stop Guessing: Building a Clarification Gate for Text-to-SQL Agents

Comments 2
7 min read
SQL Deep Dive: Window Functions, Joins, CTEs, and Subqueries

SQL Deep Dive: Window Functions, Joins, CTEs, and Subqueries

Comments
7 min read
SQL Server Msg 1934: 'SET Options Have Incorrect Settings: QUOTED_IDENTIFIER' - Why It Happens and How to Fix It

SQL Server Msg 1934: 'SET Options Have Incorrect Settings: QUOTED_IDENTIFIER' - Why It Happens and How to Fix It

Comments
8 min read
Architectural Deep-Dive: Enterprise Cross-Border E-Commerce Fraud & FinOps Engine on Microsoft Fabric

Architectural Deep-Dive: Enterprise Cross-Border E-Commerce Fraud & FinOps Engine on Microsoft Fabric

Comments
3 min read
Database Indexing – Part 4: Covering vs. Composite Indexes in PostgreSQL – Which One Should You Use?

Database Indexing – Part 4: Covering vs. Composite Indexes in PostgreSQL – Which One Should You Use?

Comments
11 min read
How to Track Schema Changes in PostgreSQL: DDL Logging, an Event Trigger or a Schema Snapshot

How to Track Schema Changes in PostgreSQL: DDL Logging, an Event Trigger or a Schema Snapshot

Comments
9 min read
An AG replica goes SUSPENDED after patching. My fix was wrong; here is the corrected one.

An AG replica goes SUSPENDED after patching. My fix was wrong; here is the corrected one.

Comments
3 min read
Dagster and dbt: do you need both?

Dagster and dbt: do you need both?

Comments
2 min read
Following foreign keys in DBeaver, pgAdmin or IntelliJ: one row at a time

Following foreign keys in DBeaver, pgAdmin or IntelliJ: one row at a time

Comments
2 min read
Coefficient of Variation in Python, JavaScript, R, SQL, and Rust

Coefficient of Variation in Python, JavaScript, R, SQL, and Rust

Comments
3 min read
Twelve SELECTs for the list and six filtered counts for the page, and the only shared code is three SQL fragments

Twelve SELECTs for the list and six filtered counts for the page, and the only shared code is three SQL fragments

Comments
7 min read
Your creator count may be a pagination ceiling in disguise

Your creator count may be a pagination ceiling in disguise

Comments
6 min read
Stop Giving Your AI Blind Access to Databases

Stop Giving Your AI Blind Access to Databases

Comments
4 min read
Database Transactions Explained With a Simple Example

Database Transactions Explained With a Simple Example

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