DEV Community

#sqlserver

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
Real Watch Time from Noisy Video Player Logs

Real Watch Time from Noisy Video Player Logs

1
Comments 1
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
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
The Scariest Lines of Code I've Ever Written. Boooo!!!

The Scariest Lines of Code I've Ever Written. Boooo!!!

4
Comments
2 min read
Stop Making AI Guess Your Database: Oracle SQLcl MCP Server, Agent Memory, and Oracle AI Database

Stop Making AI Guess Your Database: Oracle SQLcl MCP Server, Agent Memory, and Oracle AI Database

Comments
27 min read
SQL Server INT to BIGINT Primary Key: Four Ways to Change It and What Each One Costs

SQL Server INT to BIGINT Primary Key: Four Ways to Change It and What Each One Costs

Comments
11 min read
Round-Tripping Bitwarden and Smartstore Through a Database Diagram: What SQL Server Lost and What We Fixed

Round-Tripping Bitwarden and Smartstore Through a Database Diagram: What SQL Server Lost and What We Fixed

Comments
15 min read
SQL Server Error 18456 (Login Failed for User): A Read-First Error Log State, Auth Mode, and Login Triage

SQL Server Error 18456 (Login Failed for User): A Read-First Error Log State, Auth Mode, and Login Triage

Comments
27 min read
SQL Server Transaction Log Full (Error 9002): A Read-First log_reuse_wait_desc, Log Backup, and Open Transaction Triage

SQL Server Transaction Log Full (Error 9002): A Read-First log_reuse_wait_desc, Log Backup, and Open Transaction Triage

Comments
26 min read
I Built a Free SSMS Extension Because SQL Prompt Is Too Expensive

I Built a Free SSMS Extension Because SQL Prompt Is Too Expensive

Comments
4 min read
An EF Core race condition that only showed up after the switch to Azure

An EF Core race condition that only showed up after the switch to Azure

Comments
7 min read
How to Detect Schema Drift Before Production Deployments

How to Detect Schema Drift Before Production Deployments

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