Creating a Linked Server with a MySQL Database
This is my 3rd Linked Server post, and this time it’s to a MySQL database. Noteworthy weblinks: # My Linked Server Blog Posts.# Microsoft Docs – Linked Servers.
“Changing the Primary Domain DNS Name of this Computer Failed” – Server 2008 R2
Within an AWS account I have a Windows Server 2016 Domain Controller, and I’m trying to join a Windows Server 2008 R2 to my Whyte.net Domain.
Testing Connectivity to Remote Server Ports with PowerShell
All admins need a tool to test connectivity to remote servers on TCP ports. In Windows, this is commonly done using PuTTy or PowerShell.
Forcing Encryption in SQL Server
If you’re ever planning to allow external connections to a SQL Server, one of the first things to ensure is that the data is encrypted at rest and in-transit.
Running PowerShell Scripts as Scheduled Tasks in Windows
When you need something scheduled in Windows, the Task Scheduler is the tool at-hand. Running PowerShell (.ps1) scripts as Scheduled Tasks is done differently than differently than running regular .bat scripts.
How to Check What Features are Installed in SQL Server
This is a quick guide on how to check which features are installed on a SQL Server. Open your SQL Server installation files.
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.
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.
