If you sign up, the system will generate a phrase for you. I didn't like mine as there is no way I would ever remember it. They also list some suggestions but I didn't like those. Almost every suggestion included the word "bread". They trying to tell me something? I swear I've cut back on the carbs! Read Full Story

There are plenty of things to like about InfiniDB - Multi-threaded and designed for multi-cpu/cores, ACID compliant, recoverable, supports SQL standards and online DDL, MVCC, dynamic data compression, and FREE! What attracted me first though was the open source implementation of the columnar storage. Read Full Story

DB Geek says: Twitter Weekly Updates for 2009-10-25 http://bit.ly/24Mkb # RT: @Divorce_Care Stop trying to change someone else that you think need fixing. People can't change people. But you can work on yourself. # Rofl! RT: @datachick Listening to wackos explain to the CBC why they won't get flu shot: "it has alien parts in it". # @datachick had someone tell me a scientific theory is just an idea a scientist had. seriously. i couldn't respond. what do u say? in reply ... Read Full Story

DB Geek says: Twitter Weekly Updates for 2009-10-25 http://bit.ly/24Mkb # RT: @Divorce_Care Stop trying to change someone else that you think need fixing. People can't change people. But you can work on yourself. # Rofl! RT: @datachick Listening to wackos explain to the CBC why they won't get flu shot: "it has alien parts in it". # @datachick had someone tell me a scientific theory is just an idea a scientist had. seriously. i couldn't respond. what do u say? in reply ... Read Full Story

A human being should be able to change a diaper, plan an invasion, butcher a hog, design a building, write a sonnet, set a bone, comfort the dying, take orders, give orders, solve equations, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects. -- Robert Heinlein Read Full Story

From An Expert's Guide to Oracle Technology I got a question the other day about whether to use a scalar sub-query or a join. I think we all know what a join is (if not, I have posted on it before), but what exactly is a scalar sub-query. Well, what does scalar mean? I looked up the definition of scalar and get: Noun 1. scalar - a variable quantity Read Full Story

How often does a vendor REDUCE their prices, and thereby lowering your bill, without some nasty contract renegotiation? In my experience, never. One more reason to really like Amazon's web services. Read Full Story

This is pretty slick. I haven't played with it yet as it was just announced but it seems to be an API driven mysql instance. For slightly more than a base instance, 0.11/hour RDS vs 0.10/hour base EC2 (this price is dropping 15% BTW) on a small server, you get a complete server with MySQL installed. You can create and manage your database instances via procedural call (the API) and you can scale to larger instances or additional storage fairly painlessly by also using those APIs. You also pay... Read Full Story

From An Expert's Guide to Oracle Technology Popular question: Should I use dynamic SQL for some(xxxx) task? No. Have a nice day. Next. Just kidding. Sometimes you need to use dynamic SQL. When coding, Dynamic SQL can be a lot of fun. I've used dynamic SQL to generate SQL that was then run. Cool. When I use dynanamic SQL, it's because I cannot use static SQL. Seriously. If you are coding and you think you should use dynamic SQL, y Read Full Story

Blog Comments: Comment on Oracle INFORMATION_SCHEMA by Jorge Carrillo: Hi, This is good work! I.. http://bit.ly/Qs1AJ # DB Geek says: Twitter Weekly Updates for 2009-10-18 http://bit.ly/CUvO # Twitterberry is using opera mini to open links. How do I change it back to the bb browser? # Blogged "NEXT_DAY – Get the next day from a date + day combo" http://it.toolbox.com/trd/46/2/34849/3 # RT: @TampaBayWeather Mid-Day Update: Warming up from a record low: Tampa temperature sets ... Read Full Story