Default Values, Triggers, and You

A friend of mine sent me an email the other day asking about default values in SQL Server. I realized that I’ve had to think about this a few times over the years and I’ve been asked about it more than once, too. Setup We need a table first, right? We’ll also want a few…
Read More

What I’m Reading – 2010-12-03

Inside of us is a playground – It’s a video, but there are words in it so it kind of counts as reading. MySQL vs. PostgreSQL, Part 1: Table Organization – Robert Haas gets paid to write PostgreSQL. He’s started up a series of posts looking at the differences between PostgreSQL and MySQL. It’s interesting…
Read More

Getting Started With Hive

This is a follow up to the last two posts I made about querying HBase and Hive. The set up for this was a bit trickier than I would have liked, so I’m documenting my entire process for three reasons. To remind myself for the next time I have to do this. To help someone…
Read More

Querying Hive with Toad for Cloud Databases

I recently talked about using the Toad for Cloud Databases Eclipse plug-in toquery an HBase database. After I finished up the video, I did some work loading a sample dataset from Retrosheet into my local Hive instance. This 7 minute tutorial shows you brand new functionality in the Toad for Cloud Databases Eclipse plug-in and…
Read More

What I’m Reading – 2010 Birthday Edition

It’s my birthday today, so I’m going to subject you to more things that I’ve been reading recently. William Gibson says the future is right here, right now – I couldn’t agree with this more. Time gets faster because we’re constantly connected to the world. The Humble Pencil, The Mighty Computer – I love using…
Read More

On Being Wrong

When I first started blogging, I was nervous because I might be wrong. Not just “wrong” like “Gee Ted, I don’t know if I agree with your opinion about using Irish children as forced labor,” but factually wrong. And if I was wrong on the internet, people would see it forever and ever. Well, Google…
Read More

Facebook Messaging – HBase Comes of Age

Update: I want to thank Ben Black, Todd Lipcon, and Kelley Reynolds for pointing out the inaccuracies in the original post. I’ve gone through the references they provided and made corrections. Facebook, the data giant of the internet, recently unveiled a new messaging system. To be fair, I would normally ignore feature roll outs and…
Read More

What I’m Reading 2010-11-15

Understanding checkpoint_completion_target Ever wonder what’s REALLY going on under the hood of my favorite database? I do. Hubert Depesz writing series of articles about PostgreSQL configuration parameters. This one goes into incredible detail about how PostgreSQL handles checkpointing and keeps the database performing at high speeds. Riak SmartMachine Benchmark: The Technical Details How much data…
Read More

New Uses for NoSQL

We all know that you can use NoSQL databases to store data. And that’s cool, right? After all, NoSQL databases can be massively distributed, areredundant, and really, really fast. But some of the things that make NoSQL database really interesting aren’t just the redundancy, performance, or their ability to use all of those old servers…
Read More

Comparing MongoDB and SQL Server Replication

MongoDB has replication built in. So does SQL Server, Oracle, DB2, PostgreSQL, and MySQL. What’s the difference? What makes each MongoDB a unique and special snowflake? I recently read a three part series on MongoDB repication (Replication Internals, Getting to Know Your Oplog, Bending the Oplog to Your Will) in an effort to better understand…
Read More
Menu