I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
General

I am continuously chiding my customers to upgrade their software, particularly the software they bought from Quest. Why? Well, for starters it’s in my financial best interest to do so. But, I have no problems sleeping at night because it’s also in their best interest. Why? Companies spend a lot of money on software maintenance renewals. Anywhere from 10-25% of the list price every year goes to this. Software companies love that revenue stream. It’s…

Expired

So this was my 3rd Oracle Open World, and not much has changed in terms of my experience as a ‘booth boy’ in the Vendor Exhibition Hall. However a few things definitely got my attention. I will need to re-evaluate how I treat the opportunity to attend this conference going forward. I should get registered as a blogger I should attend the blogger meet-up I should meet @jpiwowar in-the-flesh I should wrangle my way into…

Database Stuff

Don’t you just love managing your 3,247 accounts and passwords in cyberspace? Imagine being a DBA who manages several hundred databases and requires a password for each of those. And of course said passwords expire after X days, right? Password rules, which cover things like limit of failed login attempts password lifetime reuse max password expiration grace time are defined by Profiles. You can view profile information by querying SYS.DBA_PROFILES. I was approached for help…

Database Stuff

Microsoft has a lot to be proud of. They helped pioneer desktop computing. They have very successful platforms like SQL Server and Sharepoint. They are even working on a new mobile phone that doesn’t support copy and paste. But, I would argue their most popular product in use today is Excel. Mayhaps ‘popular’ isn’t the best word here. Most reasonable people will probably agree that Excel is the predominant number crunching tool in the marketplace.…

Expired

Updated for 2015! If I were attending as a developer/DBA, here are the things I would be doing: Take notes, collect materials. Come back to work, put on a lunch seminar sharing the biggest things you learned during the week – make it EASY for your boss to approve #OOW16. Put Twitter handle on name badge. Plan for sessions in advance using the Schedule Builder Only pack in carry-ons. You won’t want to be waiting…

Database Stuff

I spend a lot of time speaking to PL/SQL development teams. A conservative estimate would break down to about 200 presentations a year and 2,000 developers. I have several stock presentations, but I prefer to have conversations with my audience rather than just start throwing slides up on the projector. If we find a topic of interest, then I can jump into presentation mode. When I get desperate for audience participation, I’ll start throwing concepts…

Database Stuff

I travel quite frequently for my job. Number one on my list of ‘must have things’ on the road is a Navigation device. This used to be my trusty Garmin, but now thanks to my new Android device, I have Google Maps. There have been times and places where I don’t have the device available – either the GPS satellites cannot be acquired or i’m in D.C. where the accuracy of the positioning seems artificially…

Database Stuff

In an earlier post, I discussed the merits and deficiencies around using the * syntax in a SELECT statement. I have been using this topic as a way to bring up lively discussions while doing database tools demos for our SQL and Oracle customers. I must admit I am extremely dismayed by the amount of Senior level folks who do not understand why this is not an ideal way to write queries. In a lot…

Database Stuff

I had to check out Brent’s LinkedIn account to see just how long he had been at Quest. Wow, 2.25 years. It was only about a year ago that I became aware of Brent’s presence. I actually can’t remember if I stumbled across his blog first or heard his name mentioned in a conference call. Ahhh, as I type this, I now recall how I ‘met’ Brent. Via Twitter. @BetsyLM had compiled a list of…

Personal Tech

After waiting nearly six weeks to receive my Incredible, I can honestly say it WAS worth the wait. Updated: Friday, July 16, 2010 Two Weeks Later… I have had very few problems with the phone and have been able to successfully navigate around them. The very first problem was with activation. Phone would not activate on its own. First Verizon support guy would not activate my phone. Second Verizon support guy, Chris, did activate it…