Sql Server

Hard-coded IP address versus DNS name in a SQL Server connection string

Article | Sql Server

Don’t specify IP’s in your SQL connection string

In today’s SQL newsletter from SQL-Server-Performance.com I was horrified to find the following tip: When you specify a server in an ADO.NET connection string, use the server’s IP address, not the server’s DNS name. By using an IP addres...

Huy Vũ|Oct 2, 2026|2 min read

Article | Sql Server

SQL Server Change Data Capture (CDC): How It Works, Setup & Best Practices 2026

SQL SERVER CDC GUIDE What is SQL Server CDC?How SQL Server CDC WorksHow to Enable CDC on a SQL Server DatabaseCDC vs. Change Tracking in SQL ServerNative SQL Server CDC vs. Third-Party CDC ToolsCore Use Cases for CDCCDC for Azure SQL Dat...

Huy Vũ|Oct 13, 2026|6 min read

Article | Sql Server

SQL Performance Tuning: Estimating Percentage Improvements

When I’m doing performance tuning on an application in the early stages of its lifecycle (or any app that’s never had DBA attention before), I end up with a ton of recommendations within the first day of performance tuning. The resulting...

Huy Vũ|Oct 2, 2026|3 min read

Sql Server

Don’t specify IP’s in your SQL connection string

SQL Server Change Data Capture (CDC): How It Works, Setup & Best Practices 2026

SQL Performance Tuning: Estimating Percentage Improvements

SQL Server CASE Statement – Simple Explanation

Does index fill factor affect fragmentation?

Explanation of Unused Indexes in SQL Server

How to Reduce the CPU Overhead of Dynamic SQL

FILLFACTOR in SQL Server: Optimizing Index Performance and Storage Efficiency

Database Animations: Stop Using Page Splits to Justify Lowering Fill Factor.

If Your Trigger Uses UPDATE(), It's Probably Broken.

Should That Be One Update Statement or Multiple?

Can You Get Parameter Sniffing on Updates and Deletes?

Resizing Tempdb (When TEMPDB Wont Shrink)

In Memory Table Indexes

Tempdb Performance Improvements in SQL Server 2022 are Dramatic

You Can Disable Parameter Sniffing. You Probably Shouldn’t.

Trace Flags That Are Now Defaulted Behaviors in SQL Server

With(NoLock) vs With(ReadPast)

Using NOLOCK? Here's How You'll Get the Wrong Query Results.

But NOLOCK Is Okay When My Data Isn't Changing, Right?

Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide

How to Make SELECT COUNT(*) Queries Crazy Fast

How To Decide if You Should Use Table Partitioning

Bad Habits: Avoiding NULL in SQL Server

HOW TO Tracking Synchronous Statistics Updates

MAXDOP and DOP Feedback in SQL Server 2022: The Complete Guide

A Beginner-to-Advanced Guide to Query Store in SQL Server

How SQL Server 2025’s Optional Parameter Plan Optimization Works

7 Things Developers Should Know About SQL Server

Unusual Parameter Sniffing: Big Problems with Small Data

Coming in Entity Framework 9: Better Query Parameterization

Reading analytics

Articles