To anticipate and prevent
dynamodb At work I’ve been working on a big Amazon Web Services related project. For part of this project, I wanted to record some information in a database. Previously, all I’ve used has been relational databases like MySQL. One could use AWS Relational Database Service, but that’s expensive if you’re only storing a small amount…
By Dsv (Own work) Public domain, via Wikimedia Commons For the last few years, my DNS server of choice (when I run my own) is PowerDNS. It is very simple to use, and the ability to run multiple “backends” makes it wonderfully configurable. My choice setup is PowerDNS running the MySQL backend. Of course the…
This past weekend I spent way too much time with Jon while trying to get our new work machines setup. Normally most of the time is spent waiting for Visual Studio to install (seriously that thing takes forever), but not so this time. DB2 kept refusing to work and play well with others. Specifically the…
While this isn’t strictly part of the migration process from S9y to WordPress, I decided to take some advice I read on the net and change the prefix for WordPress tables. Most use this feature for when they have to share a database, but the suggestions I read said to do it to help prevent…
Read More “Serendipity to WordPress – Changing table prefix” »
SQL0104N An unexpected token “” was found following “”. Expected tokens may include: “CORRELATION NAME”. SQLSTATE=42601 This was the error that I got while attempting to execute a stored procedure under DB2 v8.1 for z/OS. Being quite confused about it, I googled for the answer. I didn’t find one, but I did find this google…
Read More “DB2 LUW vs zOS: Selecting from nested subselect” »
As the title states, the caret (^) is not used as an exponent in MySQL. I’m not certain what exactly it does (and couldn’t find any documentation after a quick search), and would love to find out what its purpose is. I ran into this problem today when I noticed that MySQL’s math results (using…