Peter Whyte

Category: Microsoft SQL Server

Microsoft SQL Server Blog which includes troubleshooting, performance tuning, and database administration guides from an experienced SQL DBA, Peter Whyte.

Checking SQL Server Mirroring Health & Latency

December 2, 2024

In this blog post I’m sharing info on how to check the health and latency of your Database Mirroring in SQL Server.
Read More
SQL Script to Get AAG Latency

November 30, 2024

In this post, I’m sharing a script that I use frequently as a Production SQL DBA to check Always On Availability Group (AAG) latency.
Read More
Keeping SQL Server and Critical Systems Up to Date

November 25, 2024

Applying the latest patches to SQL Server, Windows OS, and underlying hardware is a vital part of maintaining secure, high-performing systems. For many…
Read More
How to Set the Default Database for SQL Server Users

November 24, 2024

This blog post contains a quick guide on how to set your default database in SQL Server using SQL Management Studio.
Read More
How to Silently Install SSMS

September 14, 2022

This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell).
Read More
Add a Filegroup to a Database in SQL Server

September 1, 2022

This post contains a demo on how to add a new Filegroup for a database in SQL Server. Most databases work well with single data/log files and do not need this.
Read More
Connecting to SQL Server on Another Domain

August 25, 2022

This post contains a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User other than your own.
Read More
How to Rename a Computer that Hosts SQL Server

August 23, 2022

When changing the hostname of a computer that is running SQL Server, we have to update system metadata so that remote connections and applications do not lose…
Read More
Get Estimated Database Backup/Restore Example

August 18, 2022

When you’re waiting on a database backup or restore to complete in SQL Server, we can run the script below to get an estimated time of how long the backup has…
Read More

Start with a guide

Three guides collect the posts by the job you are doing rather than by date.

PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth having

Looking for SQL Server?

This site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.

sqldba.blogScripts, error library, wait types, SSMS