DEV Community

#sqlserver

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Copy only the missing rows from SQL Server to PostgreSQL from the command line

Copy only the missing rows from SQL Server to PostgreSQL from the command line

Comments
6 min read
Entity Framework Core Performance: 8 Common Mistakes and How to Fix Them

Entity Framework Core Performance: 8 Common Mistakes and How to Fix Them

Comments
3 min read
SQL Server migration verification: matching row counts are only the start

SQL Server migration verification: matching row counts are only the start

Comments
4 min read
SQL Server Isolation Levels Explained (with NOLOCK and RCSI)

SQL Server Isolation Levels Explained (with NOLOCK and RCSI)

Comments
4 min read
SQL Server to PostgreSQL: five details that break a data migration (and how to check them)

SQL Server to PostgreSQL: five details that break a data migration (and how to check them)

Comments
2 min read
Temp Tables vs Table Variables in SQL Server: Which Should You Use?

Temp Tables vs Table Variables in SQL Server: Which Should You Use?

Comments
3 min read
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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.