DEV Community

#sqlserver

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
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
CDC do SQL Server para o Amazon MSK com Debezium no MSK Connect: IAM, Secrets Manager e alerta de conexĂŁo

CDC do SQL Server para o Amazon MSK com Debezium no MSK Connect: IAM, Secrets Manager e alerta de conexĂŁo

10
Comments
12 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
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
A patched SQL Server cluster stops syncing. The failure is identity, not the patch.

A patched SQL Server cluster stops syncing. The failure is identity, not the patch.

Comments 1
3 min read
How to Read a SQL Server Execution Plan (Beginner's Guide)

How to Read a SQL Server Execution Plan (Beginner's Guide)

Comments
4 min read
Normalization vs denormalization in a real Postgres schema: what I fixed, and the copy I kept

Normalization vs denormalization in a real Postgres schema: what I fixed, and the copy I kept

1
Comments 2
7 min read
One Line of EF Core Config Cut My Query’s Reads by 99%

One Line of EF Core Config Cut My Query’s Reads by 99%

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