-
Finding Duplicates using SQL
While migrating old data to a new database schema I was unable to activate a PRIMARY KEY on the legacy_customer_id field because there were duplicates. It turned out that the old application did not clean the data really well, and it allowed duplicates to be created where one of the customer_ids had a space character […]
-
Linux backup using CRON to local directory
As many have pointed out I am on a backup and disaster recovery kick lately. Some would say that it is about time, others are simply glad to see that data is now being backed up. I have found that it is easiest to zip up files on a local machine prior to moving them […]
-
Backup Windows Domain Controller using NTBACKUP via cmd
Backing up your servers for disaster recovery these days much include your Domain Controller if you are utilizing a Windows Active Directory to manage your users. To do this is easy using a tool that comes installed on all Windows servers called NTBACKUP. Of course you can launch the GUI by entering NTBACKUP from the […]
-
Windows backup bat script using xcopy
Recently I had the need to create a bat script that could be executed by the Windows Scheduled Tasks. The purpose was to copy files from one server to another as a cheap way to backup files created by MSSQL backing up the databases. Here is the .bat file contents (cleaned up to protect sensitive […]
-
Get SSL running on Apache (CentOS)
I was playing with a new virtual server that had CentOS installed on it recently, and wanted to get SSL working for Apache. Since I was only setting up a development server I really didn’t need to purchase a certificate and decided to use a self-signed certificate. Here is what I did: First I needed […]