DEV Community

#sqlserver

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
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
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
MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting

MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting

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