I have for many years now promoted "Write tiny little chunks of code" as one of the most impactful and important steps we can all take to improve the readability and maintainability of code. The basic idea is that you should not let your executable sections get to be more than 50 or 60 lines of code in length. You should, in other words, be able to at a single glance take in the full algorithm/logical flow of the subprogram....

My database crashed today. My ‘production’ database that is. The one I rely on for product demonstrations, that thing I do that Quest gives me money for. Pretty funny considering in the last few weeks my blogs have included such gems as:

• Are You a Real DBA — I argue that you are indeed NOT if you have not went through the crash and recovery nightmare
• What Databases Should You Back Up — I argue that any database you depend on should be backed up, production or not.

For Part I, Part II & Part III please visit:

How to Use Quest SQL Optimizer to Tune Data Warehouse SQL – Part I

How to Use Quest SQL Optimizer to Tune Data Warehouse SQL – Part II

...

Ever spin up a database for some quick and dirty work, and you JUST WANT TO CONNECT (!!) without going through the whole ‘add the service to your local TNSNames.ORA’ rigmarole (Oracle Net Configuration Assistant)? Oracle’s Net Configuration Assistant was one of the first JAVA powered GUIs I had run into as an Oracle user. It has been improved greatly over the past few years, but I’m pretty sure there are still much faster ways to connect to the database.

...

Are you a PL/SQL developer? Do you think your IDE should promote better coding practices, and guide you to build more robust and reliable programs? If so, then Toad v11 might be just the IDE you are looking for.

Toad version 11 introduces a new feature in the Professional and higher editions — Code Analysis.

As you develop your PL/SQL code, Toad will highlight any code that violates its set of best practice...

Use coding style to avoid hints...TOAD is full of tuning tools...

TOAD has many features I illustrate during my SQL Tuning for Developers course...

On-site class this week in Cork and Dublin Ireland.  This is a 2-day on-site class exactly like the 4-half day web class being offered by Quest Software the week of June 20.

 

The last day of the Adv PL/SQL class covers large objects and TOAD Debugging and Profiling Tools

（原文： “A NEW INTELLIGENT TEST RUN FUNCTION IS UNDER RESEARCH” 作者：虹天软件(珠海)有限公司 杜伟业(Richard To） 原文投稿日期：2008年6月13日 星期五）

Dan covered Ref Cursors and PL/SQL Collections in yesterday's Advanced PL/SQL class.

Dan covered compiler options including conditional compilation in yesterday's Advanced PL/SQL class.  He also covered advanced topics using database triggers including updateable views and audit trails.

Hi! Watch for my blogs on SQL Tuning and PL/SQL Tips and Techniques.



Right now I am teaching the Advanced PL/SQL class for a client over the web. I'll keep you posted with how it is going. 

I am focused on training and Quest Software and I have worked out an arrangement where I teach my popular Oracle SQL Tuning for Developers using TOAD and Advanced PL/SQL Tips and Techniques using TOAD (and of course...

Disclaimer: I work for Quest Software. I am paid to promote and help sell their software.

Did you know we also give away a lot of software, with no intention of selling it?

One of the most popular database platforms out there is MySQL. I’m going to guess that’s because it is free (for now). Apparently it is downloaded more than 70,000 times a day.

WOW.

I don’t use MySQL Jeff. If you are a blogger,...

Written by Finn Ellebaek Nielsen

This blog post describes a best practice for comparing datasets with Quest Code Tester for Oracle (CT).