Creating MySQL Databases & Tables (with added tips)
This is a post on creating databases/tables in MySQL on both Windows and Linux, with added tips to help with general usage.
Tech Blog – Home
Delete Windows.old Files
When your machine is upgraded to a newer version of Windows, it leaves behind a C:\Windows.old directory which can be quite large.
Installing MySQL 8.0 on Windows
A simple run-through of installing MySQL Community Server 8.0, including MySQL Workbench on Windows. Installing MySQL Open the MySQL installer exe as downloaded from the link above.
Running Scheduled Tasks in SQL Server Express
Running scheduled tasks in SQL Server Express has to be done differently due to the limitations of the Edition. As well as having a maximum database size of 10GB and 1GB consumable RAM, Express does include the SQL Server Agent.
sqlcmd in SQL Server
The sqlcmd utility allows SQL to be run at the command prompt over ODBC (Version 17.3+ allows Azure connectivity). This tool comes with SSMS, or separate Windows &
Changing Schemas in SQL Server
This is a post on moving tables from one schema to another in SQL Server. A semi-rare task for myself, although it could be more frequent for those who use schemas for things like staging tables/versioning.
Adding & Removing SQL Features via Command
This is a quick guide on how to add and remove features from SQL Server via command, following the theme of recent posts.
Install/Uninstall SQL Server via Command
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.
