Blog Talk: Comment by Meredith Dart on Decisions, decisions, decisions – Gotta Rant http://bit.ly/1gy8A #
DB Geek says: Twitter Weekly Updates for 2009-11-01 http://bit.ly/LkhfN #
Blog Talk: Comment by VIVEK BALIGA on SQL and PL/SQL – Free and Open Coding Standards http://bit.ly/2ZJrxL #
@imjustagoyle check out the sponsers and see if you can get a sponsored live blog pass. tweets or blogs for the sponser. etc in reply to imjustagoyle #
Bullcrap! 11g xe now! RT: @orana Bad news... Read Full Story
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