DEV Community

#sqlserver

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
SQL Server Blocking: How to Find the Head Blocker and Fix It

SQL Server Blocking: How to Find the Head Blocker and Fix It

Comments
3 min read
What 120,000 invented rows taught me about moving a SQL Server 2012 app to Dataverse

What 120,000 invented rows taught me about moving a SQL Server 2012 app to Dataverse

Comments
4 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
How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes

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

Comments
4 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
dbSlice in 3 Minutes: Migrate, Replicate and Sync Data

dbSlice in 3 Minutes: Migrate, Replicate and Sync Data

Comments
2 min read
SARGable Queries in SQL Server: Why Functions in WHERE Slow You Down

SARGable Queries in SQL Server: Why Functions in WHERE Slow You Down

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
SagreEventi: an offline-first app for Italian food festivals

SagreEventi: an offline-first app for Italian food festivals

Comments
6 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
From Spring Boot to EF Core: Understanding Concurrency a Little Differently

From Spring Boot to EF Core: Understanding Concurrency a Little Differently

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