I receive an Oracle ACE award!

Here’s a nice surprise that came up last month (and unfortunately I’ve been too busy to write about it until this month,) I’ve been presented with an Oracle ACE award! What is it? In the Oracle ACE Program FAQ it’s described like this:

The Oracle ACE Program is designed to recognize and reward members of the Oracle Technology and Applications communities for their contributions to those communities. These individuals are technically proficient (when applicable) and willingly share their knowledge and experiences.

The program comprises two levels: Oracle ACE and Oracle ACE Director. The former designation is Oracle’s way of saying “thank you” to community contributors for their efforts; we (and the community) appreciate their enthusiasm. The latter designation is for community enthusiasts who not only share their knowledge (usually in extraordinary ways), but also want to increase their community advocacy and work more proactively with Oracle to find opportunities for the same. In this sense, Oracle ACE is “backward looking” and Oracle ACE Director is “forward looking.”

The ACE award seems like a great way to recognize and encourage people to contribute to the Oracle community as a whole. ACE directors additionally commit to being involved in their local Oracle community, posting to the Oracle forums and a handful of other community-centric activities.

There are currently 159 people in the Oracle ACE program and if you frequently surf for Oracle information you’ll recognize many of the names (e.g. Doug Burns, Steve Karam and Tom Kyte, just to name a few.) I’m thrilled and honored to be part of the program and plan to keep contributing where I can!

oracle, oracle ACE, database, database administration, dba

Oracle 11g, automatic features and a few warnings

If you’re an Oracle DBA like me you are probably wondering how 11g, Oracle’s most recent release, will affect you. Don Burleson who points out some great new features of 11g:

The new Oracle data compression utility promises to save on disk storage up to three times over storing data in an uncompressed format, with relatively small overhead.

SPA [SQL Performance Analyzer] is one of the most exciting features. It’s a holistic tuning tool that allows you to define and replay a representative workload on your database.

And some appropriate warnings:

Oracle has created artificial intelligence to advise on self-healing operations, and these are often misunderstood and misapplied by people without the requisite background.

Check out the whole article, and if you have a chance be sure to catch Don’s 11g New Features presentation! I was lucky enough to see it before my presentation at the North Carolina Oracle User Group meeting a few weeks ago and learned a lot!

oracle, database, dba

What’s in a name?!

I make no secret of the point that I love the webcomic xkcd and if I blogged every strip I like I would basically end up mirroring the entire comic here.

With that in mind, there is no way I could pass up posting this commic:

xkcd - Exploits of a Mom

Next time someone asks you what a SQL injection is you can point them at this, then explain nicely.

sql, oracle, pl/sql, plsql, exploit, security, sql exploit, dba, database, database administration, comic, fun, funny, sql injection

Presenting at North Carolina Oracle User Group This Friday

For anyone in the area of Raleigh, North Carolina this week I will be presenting at the North Carolina Oracle User Group’s fall meeting. I will be giving a presentation on Oracle Shell Scripting which includes several tips and scripts from my book by the same title.

Don Burleson will also be presenting on Oracle 11g new features. The meeting runs from 12:30 to 4:30 this Friday, October 5th. More details are available on the NCOUG site.

oracle, dba, database, database administrator, 11g, unix, linux

Getting dates into the format you want in Oracle

I’m always amazed how much traffic some of my articles on the Oracle date datatype get, but dealing with dates in SQL can be as daunting for beginners as it is tedious for the experts.

Well, here’s another resource to help you sort out those pesky dates. This one focuses on the to_char function and how it can be used to get dates to output in the format you want.

This article from Don Burleson offers a couple handy examples of the to_char function, but more importantly has a table listing the options for output of the date format.

For more reading on the Oracle date format check out my other Oracle stories.

oracle, sql, pl/sql, dba, database, database administration