Author: Peter Whyte
-
How to Check Features Installed in SQL Server
This guide explains how to check which features are installed on a SQL Server instance.
-
How to Install SQL Server on Linux
As from SQL Server 2017, we now have support for running our favorite RDMS on Linux, as well as Windows!
-
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…
-
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…
-
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>…
-
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…
-
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…
-
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…
-
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…
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 havingThis 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- Linux & WSL (28)
- Microsoft SQL Server (51)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)