Blog Posts

• Domain Join Sanity Checks

  October 31, 2019

  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 process can be complex and may vary depending on your specific environment. After joining a domain, especially in a new…

  Read More

  ---

• How to Create MySQL Databases & Tables

  October 8, 2019

  This blog post is a guide on how to create databases and tables in MySQL, from a Windows and Linux computer. The information included here should help beginners who are new to MySQL. To create a new database in MySQL, and many other relational database systems we use…

  Read More

  ---

• Delete Windows.old Files

  October 7, 2019

  When your machine is upgraded to a newer version of Windows, it leaves behind a C:\Windows.old directory which can be quite large. It contains the backup of the previous Windows version, so if you plan on deleting it you’re saying goodbye to the rollback option. If do you…

  Read More

  ---

• Installing MySQL 8.0 on Windows

  October 3, 2019

  A simple run-through of installing MySQL Community Server 8.0, including MySQL Workbench on Windows. Don’t forget to checkout the MySQL Installation documentation, and here’s a link to prerequisites. Installing MySQL Open the MySQL installer exe as downloaded from the link above. Accept License Agreement and Next. I would…

  Read More

  ---

• Running Scheduled Tasks in SQL Server Express

  October 2, 2019

  Running scheduled tasks in SQL Server Express requires an alternative approach since this edition lacks SQL Server Agent. Tasks like index maintenance, backups, or other recurring operations can be scheduled using Windows Task Scheduler. Below is a straightforward method to set up and execute such tasks using sqlcmd…

  Read More

  ---

• sqlcmd Examples (SQL Server)

  October 1, 2019

  The sqlcmd utility allows you to execute Transact-SQL commands directly from the command line using ODBC, enabling SQL Server batch execution without the need for a GUI. This post contains sqlcmd examples to help you understand it more. sqlcmd is essential for running SQL queries, automating tasks, and…

  Read More

  ---

• Changing Schemas in SQL Server

  September 30, 2019

  This is a post on how-to on changing the schema of a table in SQL Server, moving it from one schema to another using the ALTER SCHEMA [tableName] TRANSFER SQL statement. During my time as a SQL Database Administrator, assisting with a task like this is a rare…

  Read More

  ---

• Adding & Removing SQL Features via Command

  July 18, 2019

  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 new feature (such as replication), and uninstalling a feature when no longer needed. The following areas will be covered within this…

  Read More

  ---

• Install/Uninstall SQL Server via Command

  June 10, 2019

  This is a post on installing SQL Server via command; I have a Windows Server 2016 Core running on a local Hyper-V test environment, and I’m installing SQL Server 2019, then uninstalling it. There’s 4 parts to this one;# Download a SQL Server ISO. # Mount the ISO…

  Read More

  ---

• Configuring Windows Server Core

  June 9, 2019

  Windows Server Core is the CLI only version of the Windows OS. This post is a run-through of configuring a new Windows Server 2016 Core host, detailed in the following steps; # Installing Windows Server 2016 Core. # (CLI) Changing a Windows Server Hostname.# (CLI) Amending TCP/IP &…

  Read More

  ---