DEV Community

#sqlserver

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
How to Prevent Duplicate POS Sales from Skewing Inventory with Python and SQLite

How to Prevent Duplicate POS Sales from Skewing Inventory with Python and SQLite

Comments 1
5 min read
Polecat on SQL Server 2025: Production Spike Migration

Polecat on SQL Server 2025: Production Spike Migration

Comments
4 min read
Renaming a column in SQL Server, and what it quietly breaks

Renaming a column in SQL Server, and what it quietly breaks

Comments
4 min read
CREATE UNIQUE INDEX terminated because a duplicate key was found

CREATE UNIQUE INDEX terminated because a duplicate key was found

Comments
4 min read
SQL Server'da yavaş sorgu nasıl hızlandırılır?

SQL Server'da yavaş sorgu nasıl hızlandırılır?

Comments
9 min read
Why Is My SQL Server Slow? A 4-Step Diagnosis with Blocking, Wait Stats, Execution Plans and Missing Indexes

Why Is My SQL Server Slow? A 4-Step Diagnosis with Blocking, Wait Stats, Execution Plans and Missing Indexes

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

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

Comments
41 min read
LogCarverGuard, an MCP proxy between an AI agent and SQL Server

LogCarverGuard, an MCP proxy between an AI agent and SQL Server

2
Comments
5 min read
SQL EXISTS vs JOIN: Find Customers Who Have Placed an Order

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

Comments
3 min read
SQL Server Database Corruption: How to Diagnose Errors Before Attempting Recovery

SQL Server Database Corruption: How to Diagnose Errors Before Attempting Recovery

Comments
5 min read
5 Common SQL Mistakes: WHERE, ORDER BY, AND/OR, and Top 3 Queries

5 Common SQL Mistakes: WHERE, ORDER BY, AND/OR, and Top 3 Queries

Comments
3 min read
ROW VS PAGE VS COLUMNSTORE VS ARHIVE DATA COMPRESSION on SQLServer

ROW VS PAGE VS COLUMNSTORE VS ARHIVE DATA COMPRESSION on SQLServer

Comments
3 min read
sqlcmd 'Scripting Variable Not Defined': Why $( Breaks Your Script and How to Fix It

sqlcmd 'Scripting Variable Not Defined': Why $( Breaks Your Script and How to Fix It

Comments
8 min read
A password you cannot change: CVE-2026-114119 and the hardcoded SQL Server administrator in Bp Premier

A password you cannot change: CVE-2026-114119 and the hardcoded SQL Server administrator in Bp Premier

Comments
4 min read
SQL Server In-Memory OLTP: When Memory-Optimized Tables Actually Pay Off

SQL Server In-Memory OLTP: When Memory-Optimized Tables Actually Pay Off

Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.