Archive for October, 2007

A Vegetarian Database? Diet Essentials For Oracle

This is the fifth in a series of abstracts I’ve submitted for the Collaborate 2008 conference in Denver CO.
There are healthy databases and their are unhealthy ones. We’ll take a look at what you feed your database, and how to keep it fit with just the right diet of hardware, configuration, and SQL query tuning.

1. Introduction – Diet of a Champion Database
2. Disk, Memory, CPU – Body by Intel
3. Applications – Lean & Fit
4. SQL Queries – High Fiber, Low Fat
5. Conclusions

Pixie Dust For Oracle: 5 Elemental Lessons

This is the fourth in a series of abstracts I’ve submitted for Collaborate 2008 in Denver CO.
As an independent consultant for twelve years, I’ve encountered a lot of interesting and challenging projects. I’ll discuss five different cases, and what lessons I took away from each.

1. Intro
2. The Right Hardware
3. Importance of Good Testing
4. Patchwork or Good Design
5. Don’t Mix Opposites
6. Use The Technology
7. Conclusion

Is Your Database an Open Book?

This is the third in a series of abstracts I’ve submitted for Collaborate 2008 in Denver CO.

Security is on everyone’s radar these days. You may be wondering yourself whether your database systems are really as secure as they should be. We’ll discuss some of the latest vulnerabilities, and what you can do to protect your systems.

1. Introduction
2. Authentication
3. Privilege Escalation
4. SQL Injection
5. OS Security
6. Network Security
7. Conclusions

Oracle HA On A Budget: Manual Standby Database

This is the second in a series of abstracts I’ve submitted for the Collaborate 2008 conference in Denver CO.

A little known fact is that Oracle’s standby technology – the stuff DataGuard is built on top of – is available in Standard Edition of Oracle. With a little elbow grease, and some simple scripts, we can have a rudimentary and functioning HA solution in Oracle SE.

1. Intro
2. Anatomy of a Standby Database
3. What’s there in Oracle SE
4. Setup standby
5. Shipping logs
6. Applying logs
7. Verifying setup
8. Manual Failover
9. Conclusions

Unbreakable or Hackable: How Does Oracle Measure Up?

This is the first in a series of abstracts I’ve submitted for Collaborate 2008 in Denver CO.

Marketing is one thing, bulletproof technology is quite another. Operating Systems have bugs, Database Software has bugs, and so does your application, probably. A better question is how hackable are you? We’ll look at some of the nefarious ways intruders can get in, so you’ll better know how secure your systems really are.

1. Unbreakable As a Pie In the Sky
2. OS level
3. Database level
4. Application level
5. Conclusions

DBJ: Oracle, MySQL, Postgres Compared

If you’re interested in how these three databases measure up in terms of feature sets, take a look at part one in a two part series I wrote over at Database Journal.

I discuss stored procedures, views, materialized views or snapshots, triggers, and security. Stored procedures and functions are supported on all three databases, as are views and triggers. Although MySQL and Postgres aren’t there in terms of default snapshot support, there are ways to get that functionality in a somewhat roundabout way.

Security is always a tricky question, as all the bugs out there aren’t always publicized. It’s sort of a cat and mouse game. All three databases support user based authentication to login to the database, and various privilege levels to control access to objects and data. Oracle also supports FGA or fine grained access control for column level control.

That said I might tend to say that open-source products in general have better security, their source being an open book and all.

The Wonder of Good Search: Quicksilver

Everyone waxes on and on about google’s search being so good. Don’t get me wrong, it is good. But many of our desktops are not enjoying that same goodness.

I’ve recently returned to the Macintosh world, with this Mac Book Pro I pickedup a year ago. It is a gorgeous machine in so many ways. When I first started using it, I was comparing all the things in Mac OS X to what I remembered from System 7 + 8. Believe it or not I used to program the toolbox, MacApp, Codewarrior, you name it. But I digress.

The first thing that struck me was how good Spotlight was. And how easy it was to access via Cmd-SPACE. It also struck me that it always seemed to be up-to-date, even with new files I’d just added to the system. It’s speed rivaled Unix’s locate, that I had grown to love using Linux for so many years.

That’s all changed now. It’s all part of an almost laughable past that I barely remember just one week ago, when I discovered the pornographically good Quicksilver.

What’s the big deal you say, another way to launch apps, another way to search your computer. No, this thing is much more. It’s like a whole new way to use your computer. It is so damn good at doing the right thing, that it just reduces steps, and brings you that much closer to communicating with your Mac by pure thought alone!

For starters you change the Spotlight shortcut so Quicksilver can come up with the same Cmd-SPACE you’re used to. You *MAY* wanna tweak some settings, but I didn’t have to do much. Another thing I recommend, remove all your apps from your doc, and from plain site, and use Quicksilver to launch them for a week. You’ll see what I mean. Ok, so it can launch, ok, so it can search, ok so it’s fast. What else?

Here’s an example of some of the surprises I found. Recently I spent a good number of weeks integrating my contact databases. I had one in my phone (a Sidekick which wouldn’t sync with my mac) that had mobile numbers. I had another that I was just putting together in Apple’s Addressbook, importing data from my old PINE addressbook that I had used for so many years. That had email addresses of everyone I’ve ever emailed for 15+ years. And then I had an addressbook in Sugar CRM and contacts in Linkedin. Don’t ask how I got to this sorry state of multiple database contact book madness, me being a DBA and all… Pulling these records all into Apple’s addressbook took time. It was a combination of various manual and automatic processes, massaging data, and eyeing names, for spelling inconsistencies, and redundant entries. After spending all this time, Quicksilver just illuminates my contact database. Search for a name, and the vcard comes up, you can launch addressbook, or display it in a big monster font right in the center of your screen. Of course with copy & paste at the ready! Now here’s the kicker, I went and manually indexed my old pine addressbook text file in Quicksilver, and now when there’s an entry I can’t find, that somehow never made it into the Mac Addressbook, Quicksilver will find it and display it real friendly like!! This is good.

To be fair the integration of all my messed up databases, the purchase of a blackberry which has all 2000+ entries that my Mac Addressbook does, *and* the discovery of Quicksilver all kinda happened at the same time, so that might have inflated my excitement (and don’t even get me started on why I didn’t buy an iPhone). Nah, Quicksilver brings you closer to god!

By now I know that those of you who haven’t used it are gonna go and download a copy, and the rest of you who have it installed but just don’t use it much are gonna take all your apps off the Dock and start using it everyday, right?! If you wanna learn from the horses mouth, I really recommend you check out Nicholas Jitkoff’s Google Tech Talk.

FYI, for the time being Quicksilver is only available for the Mac, though I hear Launchy is quite good on Windows.

This article was originally written while I was guest blogging over at the glorious #comments blog!

Oracle + Open Source – Reloaded

After being thoroughly tired of Moveable Type for some time, and having some great experiences with Wordpress on some other blogs I edit, I decided to switch Oracle + Open Source, so here we are! Enjoy.