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
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:
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
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
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
For those of you who are interested I have now posted the complete Bloc-Troic manual in my gallery!
From cover to cover (well, not really, the back cover was blank so I didn’t scan it.) the manual contains 163 electronic experiments. Each experiment illustrates the block layout for the kit and also includes a standard schematic for those who want to breadboard or permanently build any of the projects.
The experiments span from a simple conductor/insulator tester to a sound level meter to a basic radio with microphone mixing. While the Bloc-Tronic set was designed for children completing every, or even most projects in this book would be quite an accomplishment!
Unfortunately I have not transcribed the text from these pages to make them searchable. Perhaps someday I’ll get around to that, or better yet, maybe some fan of the set will volunteer to do part or all of them for me. (It took me a year to even get the images up, so don’t hold your breath on my account.)
If you’re having trouble making out something in the images notice that you can switch to a high-res version. The shadows in the image are the experiment on the back of each page bleeding through which should give you an idea of the quality of paper used in this manual. I have made it available because it seems to be orphaned. It is no longer made or distributed, the company named on the manual and box seems to have disappeared and there isn’t a copyright to be found anywhere in the materials.
I hope some others can find this useful with either the set or for building experiments on a breadboard.
electronic, toy, project, make, build, build your own, electronics kit