Connecting to databases via SSH Tunneling is something developers and IT professionals often need to do. And HeidiSQL is one of the more popular open-source database tools. While HeidiSQL fully supports SSH tunneling, there doesn’t seem to be any documentation about how to accomplish this. So, after struggling with this for a few hours and figuring it out, I put these instructions together to help others.
Linux & Servers
What is life without Linux? Browse this category to explore content I have created relating to Linux and Servers. This section is pretty broad. It promises content on Ubuntu, cloud VMs, server automation, bash scripting, PowerShell, system/website administration, AWS, etc. Watch this space for my existing and future content on the aforementioned technologies.
PowerShell desired state configuration scripts often request user credentials which then need to be stored in some form in the output MOF files. Since you never want to save passwords as clear text, this article explains how you can keep passwords secure and encrypted inside your MOF files.
I have been playing a lot with PowerShell desired state configuration (DSC) recently and so, I decided to write an introductory post on it. In this article, I explain at a high level what PowerShell DSC is all about. And then, I provide a simple example that demonstrates at a basic level how PowerShell desired state configuration works.
Many individuals and organizations implement virtual machines and dedicated servers using Amazon Elastic Cloud Compute (EC2). Like any other host on the Internet, your Amazon EC2 instances can be vulnerable to attack if you don’t take special precautions. In this article, I explain some of the most important things you should do to secure your Amazon EC2 instance.
On Amazon EC2, the instance type you choose determines the amount of physical memory (RAM) that you get. Larger instance types with lots of RAM are more expensive. So if you want more RAM on a medium or small EC2 instance, you can define some storage space on your disk to act as RAM when needed. The disk area you use for this purpose is called a swap file. This article explains swap files and demonstrates how to set up a 2GB swap file using ephemeral storage on an m3.medium instance of Amazon EC2 that has only 3.75GB of RAM by default.
WordPress on Amazon EC2 makes a very flexible and powerful web development combo. WordPress is a great choice because it has a huge theme and plugin ecosystem, and it is very user-friendly (non-technical people can use it comfortably). Amazon EC2 is highly scalable and practically unlimited and Amazon Web Services (AWS) provides a whole suite of website and application management tools that most people find useful at one point or another.