Saturday, September 26, 2009

Joel Silva, How Could You Be So Mean?

Got this email from my Dad (turns 80 next month) yesterday:

Subject: Twitter
From: sheldon feuerstein

I took a look at Twitter and asked to see what was there for you and found one comment that asked "hasn't anyone told Steven that PL/SQL is dead?" I hope not...

I tracked down this message to Joel Silva, who wrote: "Going to attend Steven Feuerstein conference today. Can anyone tell him PLSQL is dead!?"

First of all, if it is dead, why are you coming to my event in Porto, Portugal? :-)

Second, you got my dad all worried....
Joel, Joel, how could you be so mean?

So please people: be careful what you say on the Internet (about me, anyway). There are the tender sensibilities of parents to keep in mind!


Monday, September 21, 2009

OOW PL/SQL sessions with a multimedia focus

My friend and PL/SQL expert, Marcel Kratochvil, will be at OOW (up from Australia) to talk about his experiences using PL/SQL to deliver multimedia-rich applications. If you have any interest in this area, I strongly encourage you to check out his two sessions.

The first is at the Unconference, and covers Internet PL/SQL development Tips:
Wednesday - Oct 14, 1 PM
Overlook II: Mod PL/SQL Development Tips - including Google Maps, Spatial Integration and sending HTML formatted emails with graphics.

The second is a workshop to be held at the Oracle Develop Conference at the Hilton, and is a hands-on workshop for building an internet based multimedia PL/SQL application. Here are the details:

Tuesday Oct 13, 2.30pm -3.30pm Hilton Hotel
Build Fast, Secure Web Applications with the PL/SQL Gateway and Oracle Multimedia
In this hands-on lab, learn to build fast multimedia Web applications on Oracle Database with minimal code. Build a Web interface to query and view multimedia data with relational data. For example, query and retrieve a photograph, audio clip, or document in one piece of code. Tune the database so multimedia data will fly off the disk into the application.

Tuesday, September 08, 2009

Online Training for the New Economy

When the going gets tough and budgets get tight, money for training is often cut first. You still, however, need to learn how to best leverage the PL/SQL language and write high quality code. To help you, Quest is offering a three-part, webcast training series that I will be teaching. Each session consists of two hours of in-depth coverage of a specific functionality area or best practice.

The cost is far less than you would be for an onsite or public training - and I don't have to travel (and neither do you)!

More information about session logistics and registration are available through these links below. For much more detail on each session, please check out the descriptions at the end of this posting.

Webcast Details
I hope that you can take advantage of this opportunity. Click here toget more details and to register.

Optimize PL/SQL Execution with Bulk Processing

This session focuses on how to turbo-charge the performance of multi-row SQL statements executed from within a PL/SQL using FORALL and BULK COLLECT. These features have been around since Oracle8i, but many developers still don't use them or only scratch the surface of what is possible.

The Bulk Processing webinar will talk about why these features were needed and how they work. Steven will start with simple examples and syntax and drill down into all nuances, including the LIMIT clause for BULK COLLECT and the SAVE EXCEPTIONS, INDICES OF and VALUES OF clauses for FORALL.

After attending this webinar, you will be able to both create new programs built around these features and also redesign existing programs safely to improve performance.

Writing Maintainable PL/SQL Code

Software managers (and, therefore, their developers) are very focused on delivering applications "on time" (that is, to meet the current production deadline). Sure, that's important. But as (or maybe even more) important is to build applications so that they can be maintained and enhanced without consuming all the resources of the development team (thereby interfering with new development).

This webinar offers a wide-ranging set of techniques to make your code easy to understand and maintain over time. These techniques include: the use of subtypes and local modules; how to activate and check compliance with standards; and encapsulation (information hiding).

After attending this webinar, you will be able to write code that minimizes the amount of development resources needed to maintain that code.

Error Management Features of Oracle PL/SQL

Consistent, robust error management is a critical feature of any successful application. Developers need to know all that is possible in PL/SQL regarding the raising, handling and logging of errors, and that standardize the way in which those tasks are performed.

This webinar takes you beyond the basics of exception handling in PL/SQL to explore the wide range of specialized error management features in Oracle, plus recommendations for best practices for consistent, robust application construction.

We will cover FORALL's SAVE EXCEPTIONS, DML error logging with the DBMS_ERRLOG package, the AFTERSERVERERROR trigger, the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, and more. In addition, we will talk about hiding error management functionality behind a PL/SQL packaged API and then deploying it as a set of services for application developers.

After attending this webinar, you will be able to fully leverage PL/SQL error management features and follow best practices for consistent error management across your entire development team.

Thursday, September 03, 2009

Those Europeans are so sensible

When I first read that Oracle would buy Sun, my immediate reaction was:

"How bizarre, to think that Larry Ellison, the King of Proprietary Software for so many years, now would own and control Java and mySQL!"

I have no doubt that Oracle will strongly support and enhance Java; it committed itself to the Java platform years ago.

But you've got to wonder about the future of mySQL. Sure, Oracle would royally piss off millions by letting mySQL dwindle, but it would likely offer a powerful alternative (like the free Oracle XE) - and would also likely be able to ride out the firestorm of protest.

Of course, the U.S. Justice Department said "No problem, Oracle. You go and swallow up Sun."

But the European Union is much more suspicious of corporations, which makes perfect sense to me. After all, the stated purpose of a corporation (maximize profits) has many unavoidable "conflicts of interest" with the stated purpose of democratic and civilized nations. As a consequence, it has raised concerns about this acquisition, specifically as it concerns mySQL.

I expect the acquisition will go through, but perhaps Oracle will have to make some sort of commitment to maintain and enhance mySQL, or maybe shed it entirely (reversing Sun's $1B acquisition of the software a year ago, which I think was a darned strange thing to do for a company in such bad shape).