Category: Database

Wrapping my brain around DynamoDB 2

Wrapping my brain around 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 of data. I decided to take the plunge and learn how to use DynamoDB and more...

(Re-)Introducing PDNSOps 9

(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?” and that is where PDNSOps comes in.

Error: SQL1159  Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 9.7.0 1

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 driver that .NET uses to communicate with, and thus began several hours of googling and...

Serendipity to WordPress – Changing table prefix 6

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 from SQL injection hacks.  Basically the majority of these injections presume a default of ‘wp_’...

DB2 LUW vs zOS: Selecting from nested subselect 0

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 groups post which made mention of it. Basically, the situation was that I had SELECT...