Administration how-tos

Common SQL Server administration tasks: BCP, compression, the transaction log, CU and GDR updates, table size and monitoring.

Several SQL Server instances on one server

Consolidating SQL Server instances is better than installing several of them on the same server.

Compress tables and indexes

ROW and PAGE compression of tables and indexes, in every edition since SQL Server 2016 SP1: estimate the gain, compress, rebuild.

Remove backup messages from the error log

The error log records every successful backup, which is of no use. Here is how to turn those messages off.

SQL Server Monitoring

Monitoring SQL Server: the basic Windows and SQL Server counters to watch, PRTG configuration, and Always On availability group monitoring.

Get the size of your tables

How to find the size of your tables, and the largest ones in particular.

Exporting a table with BCP

An example of exporting a table with the bcp command-line utility: integrated authentication (-T) and native format (-n) for SQL Server.

Updating SQL Server: CUs, GDRs and servicing branches

The SQL Server servicing model since 2017: choosing between the CU branch and the GDR branch, reading a build number, finding the right update and applying it.

Managing the SQL Server Transaction Log

A transaction log filling up the disk is a classic DBA problem. Learn how to diagnose blocking issues and properly configure your recovery models.