Peter Whyte

Author: Peter Whyte

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
Check & Restart SQL Server Services on Linux

July 14, 2020

As of the 2017 Edition of SQL Server we have been able to install SQL Server on Linux. Linux will likely be more of an unfamiliar environment for traditional…
Read More
“Changing the Primary Domain DNS Name of this Computer Failed” – Server 2008 R2

May 30, 2020

🛠️Part of the Windows Administration Complete Guide, every Windows administration post on this site, grouped by the job you are doing. Within an AWS account I have a Windows Server 2016 Domain Controller, and I’m trying to join a Windows Server 2008 R2 to my Whyte.net Domain. I…
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
How to Backup a SQL Server Certificate

May 4, 2020

Backing up SQL Server certificates is essential if you use them, especially for encrypted database backups that may need restoration on another server.
Read More
How to Check Features Installed in SQL Server

April 29, 2020

This guide explains how to check which features are installed on a SQL Server instance.
Read More
How to Install SQL Server on Linux

April 27, 2020

As from SQL Server 2017, we now have support for running our favorite RDMS on Linux, as well as Windows!
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