When Statistics Update

Logical processors

Target Recovery Interval and Indirect Checkpoint

Indirect checkpoint is the recommended configuration, especially on systems with large memory footprints and default for databases created in SQL Server 2016.

Quick SQL Server Configuration Summary Report

This script will detect and display a quick summary of your SQL Server installation.

Context Is Everything - Check Your Settings

Check 96 server and database settings to make sure they match your expectations in your databases with this script.

How to Document and Configure SQL Server Instance Settings

There are around seventy SQL Server instance settings, and a DBA needs to be aware of the effect that many of them have. Brad McGehee explains them in enough detail to help with most common configuration problems, and suggests some best practices.

Configure Windows Firewall to Work with SQL Server

Windows Firewall is an OS level software firewall. It can be a crucial part of OS level security if you are not using other firewall hardware or software. Since I do not have another firewall I have a need to enable Windows Firewall for my SQL Server database server. In this article I go through the process of configuring Windows Firewall for different scenarios along with the associated considerations.

SQL Server Configuration

The importance of correct configuration. Which default configuration options to change. Common mistakes.

How to move a SQL Server database within the same instance without losing settings

I want to move my database on my SQL Server 2005 system to a new drive, but I have database options, like cross-database ownership chaining, that I don't want to lose or have to remember to re-apply. How can I do this?

Default port number