Peter Whyte

Tag: Database Admin

Database Admin Blog Archives: Includes practical guides, troubleshooting strategies, and best practices, written by an experienced Microsoft SQL Server DBA.

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
Drop Table if Exists in SQL Server

July 26, 2022

The DROP TABLE command in SQL Server is used to remove a table from the database permanently. However, attempting to drop a non-existent table can result in…
Read More
Creating a Linked Server with a MySQL Database

July 15, 2020

This is my third Linked Server demo post, and this time, we’re connecting to a MySQL database.
Read More
Testing Connectivity to Remote Server Ports with PowerShell

May 7, 2020

This post contains a demo for how to check if a port is open using PowerShell, whether you are on the latest or older versions of Windows.
Read More
How to Apply Force Encryption in SQL Server

May 6, 2020

If you’re planning to allow external connections to a SQL Server, one of the first security measures to implement is encryption, both at rest and in transit.
Read More
Include Execution Trace Messages in SQL Server Error Logs

May 5, 2020

Execution trace messages in SQL Server Agent error logs can be helpful for diagnosing issues. This guide explains how to enable this option.
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