Wrapping my brain around DynamoDB
May 13, 2013
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 importantly, how to use this “NoSQL” thing people have been talking about.
October 21, 2011
By Dsv (Own work) Public domain, via Wikimedia CommonsFor 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
July 20, 2010
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 downloading and installing.
Serendipity to WordPress – Changing table prefix
June 17, 2010
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_’ prefix.
DB2 LUW vs zOS: Selecting from nested subselect
February 17, 2010
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 COUNT(*) FROM
In MySQL: x^y != x raised to the y
November 18, 2008
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 ^) didn’t match my own. After triple checking my own math, I added lots of parens and still got nowhere, so I checked the Operator Precedence and sure enough it listed the caret (^) as falling between “*, /, DIV, %, MOD” and “- (unary minus), ~ (unary bit inversion)".
From the “all-your-databases-are-belong-to-me” department...
September 21, 2007
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 likely do not know what else the DBA is working on, it is much better to ask, “I have a couple things I need from you; do you have time to go over them now?