DEV Community

#sqlserver

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
Why Your SQL Query Returns the Wrong Rows (And How WHERE and ORDER BY Fix It)

Why Your SQL Query Returns the Wrong Rows (And How WHERE and ORDER BY Fix It)

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