DEV Community

#sqlserver

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
One database, four dialects: MySQL, MariaDB, SQL Server and PostgreSQL clients on one server

One database, four dialects: MySQL, MariaDB, SQL Server and PostgreSQL clients on one server

Comments
3 min read
Why Is My SQL Server Slow? A 4-Step Diagnosis with Blocking, Wait Stats, Execution Plans and Missing Indexes

Why Is My SQL Server Slow? A 4-Step Diagnosis with Blocking, Wait Stats, Execution Plans and Missing Indexes

Comments
9 min read
SQL Server Query Store: A Practical Beginner's Guide

SQL Server Query Store: A Practical Beginner's Guide

Comments
3 min read
SQL Server Statistics Explained: Why Your Query Plans Go Wrong

SQL Server Statistics Explained: Why Your Query Plans Go Wrong

Comments
3 min read
Letting an AI assistant read SQL Server without letting it write

Letting an AI assistant read SQL Server without letting it write

Comments
7 min read
Build a Pre-Deployment Schema Drift Check for SQL Server

Build a Pre-Deployment Schema Drift Check for SQL Server

Comments
5 min read
Port 1433 Exposed: How Weak SQL Server Passwords Led to a Miner and a RAT

Port 1433 Exposed: How Weak SQL Server Passwords Led to a Miner and a RAT

Comments
5 min read
How to Find Slow Queries in SQL Server (DMVs and Query Store)

How to Find Slow Queries in SQL Server (DMVs and Query Store)

Comments
4 min read
SQL Server Multiple Cascade Paths (Error 1785): Which Foreign Key Loses ON DELETE CASCADE, and What Replaces It

SQL Server Multiple Cascade Paths (Error 1785): Which Foreign Key Loses ON DELETE CASCADE, and What Replaces It

Comments
11 min read
SQL Server Index Tuning for Beginners: A Practical Guide

SQL Server Index Tuning for Beginners: A Practical Guide

Comments
4 min read
How to Reduce Azure SQL Costs: A Practical Checklist (2026)

How to Reduce Azure SQL Costs: A Practical Checklist (2026)

Comments
4 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
7 min read
SQL Server Locks: A Performance and Deadlock Cheat Sheet

SQL Server Locks: A Performance and Deadlock Cheat Sheet

Comments
10 min read
SaveChanges shouldn't take four seconds to insert 100,000 rows

SaveChanges shouldn't take four seconds to insert 100,000 rows

Comments
5 min read
How to Monitor SQL Server Agent Job Failures (Alerts, Queries and Best Practices)

How to Monitor SQL Server Agent Job Failures (Alerts, Queries and Best Practices)

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