Change Tracking Default Retention

Estimating Data Compression Savings in SQL Server

This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.

SQL Server Diagnostic Memory Queries

Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server.

Unloading an Extended Stored Procedure

Trace Flag Scope

The Engine Edition

The Slow Upgrade of SQL Server Versions

It seems that instances are being upgraded about every ten years, according to Steve's interpretation of some reports. Do you agree? Let us know how often you upgrade.

Deploying SQL Server Automatically

I've had to install SQL Server many times over the years. Often it has felt that most of these installs were one-offs, a dev server, a new QA instance, a production server for a brand new application. A few times I've had to recover from disaster, including restoring master, but often, I just installed SQL […]

Patching Challenges

Having a patching strategy for your systems is important, and Steve notes that you ought to be organized and allow for some flexibility when designing one.

Shutting Down the Instance