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 of [...]
Archive of posts filed under the Database category.
(Re-)Introducing PDNSOps
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 question is “How do I manage the MySQL backend?” [...]
Error: SQL1159 Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 9.7.0
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 [...]
Serendipity to WordPress – Changing table prefix
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 [...]
DB2 LUW vs zOS: Selecting from nested subselect
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 [...]
In MySQL: x^y != x raised to the y
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 [...]
From the “all-your-databases-are-belong-to-me” department…
I figured the best way to start this spot is with 4 ways for absolutely anyone to make their DBA’s life easier. Never start a conversation with “I just need this one thing, really quick”. This rule can be expanded to replace one with any given number. Reasoning: You are not a DBA and most [...]
