Installing Firewalld on Linux
Quick installation notes from installing Firewalld on an Amazon Linux 2 EC2 instance – more a reference page for a future post.
Tech Blog – Homepage
Enabling TCP Connections in SQL Server
Some network protocols are not enabled by default in SQL Server. We need to enable the option and restart the SQL Service to allow TCP connections.
What’s New in the SQL Server 2019 Installation Wizard
The release of SQL Server 2019 happened during the first day of Microsoft Ignite (4th November). Up until now, I’ve been using the release candidates for tests… so it’s good to have it all officialised!
Domain Join Sanity Checks
Before joining a Windows Server to a domain, you might’ve had to request firewall rules from the network team to be opened up.
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.
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. Don’t forget to checkout the MySQL Installation documentation, and here’s a link to prerequisites.
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 &
