Archive for October 17th, 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