Long Road - Setup Your Dev VM (Part 3)
Warning: This post is outdated. It is here for reference purposes only.
This post is the third post that gives a quick crash course to setting up a development Linux virtual machine. Please read the first and second parts if you haven't already if you like. If you're just looking for what I install on the machine once it's up and running, then this is the place for you! If you don't want to go through a whole bunch of command line commands, this probably is n't the post for you.
Long Road - Setup Your Dev Virtual Machine (Part 2)
Warning: This post is outdated. It is here for reference purposes only.
This is the third of many posts about developing BCS Group's automated backup and restore system. This post builds off the previous post by going over how to setup the network adapters in a different way, how to setup your user to take advantage of sudo, and setting up a password-less connection via SSH.
Long Road - Setup Your Dev VM (Part 1)
Warning: This post is outdated. It is here for reference purposes only.
This is the second of many posts about developing BCS Group's automated backup and restore system, but is also the first of three posts that go over how I setup my development virtual machines. If you haven't read the first post, go ahead and check it out if you like! I'll wait.... That post also contains direct links to all the other posts in this series.
Long Road to the Right Solution
Warning: This post is outdated. It is here for reference purposes only.
This is the first of what will likely be a few posts about developing BCS Group's automated backup and restore system for all the websites we manage, which is currently around 30 Joomla! sites. This initial post will cover the overview of this massive project; the next posts in the series will likely cover these general topics:
- Setup Your Dev VM (Part 1) - Initial Install of Debian
- Setup Your Dev VM (Part 2) - Network, sudo, and SSH
- Setup Your Dev VM (Part 3) - Install packages
- My site backup process
- Overview of SSH and asymetric encryption (as I understand it, I'm no expert!)
- Example setups of Jenkins CI jobs
- Unit Testing, and why you should do it
- Maybe some more as I think of it...
Using SUM and CASE together
Many people are familiar with the CASE statement in SQL Server but I do not
see examples of using it like I do so commonly for some of my reporting tasks.
This post assumes the reader has a working knowledge of CASE statements.
Mastodon