Lewis Cunningham is an Oracle ACE Director, Oracle Certified Professional (OCP), Database Architect and self-professed database geek. Lewis has almost 20 years of database experience. Follow along as he builds a working Oracle encyclopedia, sharing his knowledge and experiences, and describing ways to integrate that technology in various projects and business areas.
Updated: 1 day 2 hours ago
Oracle OpenWorld/JavaOne/Oracle Develop 2010
The OOW 2010 schedule builder is up and ready to run. It's pretty cool. You can do various searches for sessions, vendors, exhibits, etc. You can also find content by user tagging. Something I would like to get a look at is the recommendation engine that's using Oracle Data Mining.
Modeling Address Types
In my previous post on Modeling Addresses, we worked through a logical model where we normalized out the parts of an address that are important to us. Now we want to model how we would attach those addresses to a person. We aren't going to cover the person entity this time. We'll save that for the future. For now we are just going to say we have a default person entity that contains a first name and a last name.
Modeling Addresses
I am going to be working mostly in a logical model and showing a potential physical representation of that model at times. I'm not going to be strict about the terms I use and I won't be digging into the meaning behind the concepts, per se. My brain doesn't work like that when I'm working and this is really to show how my brain works, and what I'm thinking about, when I do this kind of work. I will put some conceptual stuff in the first logical model and I will put some physical stuff in the logical model; it's just the way I work.
Microsoft won because it was easy
I know you must be wondering if I have just become a microsoft fanboy or possibly have lost my mind. Neither actually. Give me a few minutes to explain.
ODTUG Kaleidoscope 2010 - Why Guess When You Can Know?
So I believe I left off at Monday in my last post about ODTUG. As a matter of a fact I said I would post again the next day but didn't quite meet that. The conference has been over for a few days now but I still want to get my thoughts down.
ODTUG Kaleidoscope 2010 - The Journey So Far
So, I got to Washington on Thursday. I brought my wife and older son with me for the weekend. Getting there was an uneventful trip.
The Wardman Park Marriott, where the conference is being held, is an aswesome hotel. Plenty of food near by when you don't want to eat hotel food (which I usually don't). In the last few days I've had Indian, Italian, Thai (3 times) and a sandwich.
Friday was the ace di
Yahoo Sucks! Google wins.
From An Expert's Guide to Oracle Technology
I originally published this on the database-geek blog but I want to share a warning about yahoo.
I'm pissed. Really pissed. Advance warning: I will rant now.
I forget the exact year but in the early 90s (I think 1993 or 94), I signed up for a novel service. Online email. Remember this is the early 9
We've had problems with that!
I totally get that Oracle is not bug free. But bugs in Oracle are usually a transient phenomena. Oracle employs a lot of people to fix bugs. They produce patches and new releases that fix bugs all the time.
Stupid Proc Tricks -The Weird and Wonderful Overload
From An Expert's Guide to Oracle Technology
Ran into something the other day and thought I would blog about it. No great shakes but an interesting side note. Everyone knows what procedure overloading is right? If not, read Overloading Procedures in PL/SQL before continuing.
In the post from the link above
Ran into something the other day and thought I would blog about it. No great shakes but an interesting side note. Everyone knows what procedure overloading is right? If not, read Overloading Procedures in PL/SQL before continuing.
In the post from the link above
Tips for Blogging and Commenting on ItToolbox
Learn how to efficiently search on it toolbox, format text and learn how to display HTML and XML tags in posts and comments.
PHP for PL/SQL Developers: Using Stored Procedures Instead of DML
From An Expert's Guide to Oracle Technology
I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback.
My PHP Online References
From An Expert's Guide to Oracle Technology
I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback.
PHP for PL/SQL Developers: More Include Files, Inserting Data and Must See Sites
From An Expert's Guide to Oracle Technology
I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback.
Oracle 11g - Underground Advice for Database Administrators [Review]
One of the questions I get asked most frequently is: "how do I get started as a dba?" I am always on the lookout for a book that I can point to that will help answer this question. When I heard about this book, I had hopes that this would be the one.
PHP for PL/SQL Developers: Include Files, Connecting to Oracle and Selecting Data
We've finally arrived at some juicy code. This series of slides shows how to do some basic code reuse, connect to an Oracle database and then select some data. Of course, it's pointless to select the data and do nothing with it so that's covered also.
Know Thy Audience - Lessons on Public Presentations
The fact that Oracle would rewrite my query at runtime used to scare the crap out of me. After seeing the magic (which is what it felt like at first), I got used to it and have come to expect it (in the right situations).
MySQL Track at ODTUG Kaleidoscope
It looks like MySQL will be making a splash in DC this year at ODTUG Kaleidoscope. The conference organizers have announced a new MySQL track. Is this a good thing? MySQL is not really an Oracle tool, per se. It is, however, an Oracle database. As a database geek, and as an Oracle ACE Director, I like it.
PHP for PL/SQL Developers: Finally, some real code
From An Expert's Guide to Oracle Technology
I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback.
ProjectManager.com - A Review
From An Expert's Guide to Oracle Technology
Full disclosure: In exchange for an honest review, ProjectManager.com is giving me 3 licenses for the Project Management Methodology from mpmm.com. I will give those licenses away and will have details on that at a later date. Proj
PHP for PL/SQL Developers: A First Look
From An Expert's Guide to Oracle Technology
I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback. This is the third post,