Peter Whyte

Author: Peter Whyte

  • How to Install Firewalld on Linux

    Firewalld is a firewall management tool that simplifies rule configuration for Linux systems. It dynamically manages firewall rules, supports zone-based…

    Read More

  • Domain Join Sanity Checks

    In order to join a Windows Server to a domain, you may need to request that the network team open certain firewall rules. The network requirements for this…

    Read More

  • How to Create MySQL Databases & Tables

    Setting up MySQL databases and tables is a foundational skill for database administrators and developers. Whether you’re using Windows, Linux, or a cloud environment, this guide is aimed to help you create databases and tables in MySQL. Topics covered: > Create a MySQL Database> The USE DATABASE Command>…

    Read More

  • How to Remove Old Windows Upgrade Files

    When your machine is upgraded to a newer version of Windows, it leaves behind the C:\Windows.old directory. This folder contains backups of the previous…

    Read More

  • How to Install MySQL on a Windows Computer

    🛠️Part of the Windows Administration Complete Guide, every Windows administration post on this site, grouped by the job you are doing. Installing MySQL on a Windows computer is a straightforward process, however selecting the right options is key for a smooth setup. This is a simple how to…

    Read More

  • How to Run Scheduled Tasks with SQL Server Express

    SQL Server Express lacks SQL Server Agent, which means scheduling tasks like index maintenance, backups, and other recurring operations requires an alternative…

    Read More

  • How to Rename Schemas in SQL Server

    Changing the schema of a table in SQL Server can be a rare task for database administrators but a more common requirement for database developers. This guide walks through how to move a table from one schema to another using the ALTER SCHEMA statement. During my time as…

    Read More

  • Adding & Removing SQL Features via Command

    This post will guide you on how to add and remove features from SQL Server via the command line. The process includes checking installed features, installing a…

    Read More

  • Install/Uninstall SQL Server via Command

    Installing and uninstalling SQL Server via command line can be useful, especially in environments without a GUI.

    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
Latest posts
Browse by topic