I sometimes worry that people are confused about how to use the Quest SQL Optimizer for Oracle to help them tune their SQL statements. The solution is extremely powerful and provides you with the options to control numerous aspects of the optimization process. In fact, I suggest you read Richard To’s articles on Toad World to get an in depth understanding of the optimization process ...

Our experts at Quest continue to work hard to develop educational material for our end users to learn from, thus allowing them to become product experts themselves. Unfortunately, due to the hectic schedule of our end users, they are sometimes unable to put all the pieces together. In this blog, I piece together some steps for using the Toad Data Modeler and tying it back to Toad for Oracle ...

I am very happy to announce that we went GA with Toad for DB2 V4.5 on 7/21. This is by far the biggest, best release of Toad for DB2 to date. With this version we have introduced a full featured database administrator’s tool capable of handling the largest DB2 environments.

 

Some of the highlights of the 4.5 release are:

I spend way too much of my life on airplanes zipping around to different places, doing presentations and trainings on PL/SQL. In the process, I meet many PL/SQL developers – and I continue to be surprised and disappointed at how many developers do not know about or at least do not seem to take advantage of very powerful and useful features of PL/SQL. So I have to decided to list below all those elements of PL/S ...

Sometimes information systems professionals can get “caught up” in our own worlds. For example, project managers and their developers might focus on latest and greatest application development methodologies such as Extreme Programming (XP) or Agile Development. Likewise enterprise architects might be adopting some new or updated modeling conventions. While database administrators (DBA’s) ar ...

 

Have you ever had a need to recover data? Have you ever looked at data or maybe scripts and thought something is not correct? When working with databases there are times when we may have a loss of data or files. Has this ever happened and there is no backup information to rely on?

 

During my t ...

Dan Hotka and I wrote the TOAD Handbook back in 2003. Of course since then TOAD has changed quite a bit – both in terms of the graphical user interface and functionality. Thus we have updated the content and created th ...

You may already be familiar with the Toad World Exclusive Freeware area from where you can download and use really useful utilities such as the PL/Vision Code Library and the Freeware version of Quest Code Tester for Oracle.

 

Well here is another utility you’re going to find really interesting and it’s called the Toad Group Policy Manager.

You may already be familiar with the Toad World Exclusive Freeware area from where you can download and use really useful utilities such as the PL/Vision Code Library and the Freeware version of Quest Code Tester for Oracle.

 

Now there are two more which I’d like to introduce you to – one which has been around for many years and the other a relative newc ...

As many of you may be aware, Toad for Oracle is available in a number of different Editions and Suites. For those of you who have Toad Development Suite for Oracle or Toad DBA Suite for Oracle, there are a number of recent product updates which you can take advantage of now (GA Release Date July 8^th

 

Toad for Oracle’s Code Xpert utility (part of the Toad Professional Edition) is one of the best PL/SQL code analyzers available on the market, embedding the know-how of leading PL/SQL experts such as Steven Feuerstein. However, although there is the option to st ...

There are always those DBA’s who refuse to use GUI tools because they prefer scripts. And that’s OK – it’s a personal preference. But recently I’ve seen some stuff posted on the web and sent in email blasts suggesting that people who do use DBA GUI tools like TOAD and OEM are somehow suspect as to their skill levels. And yes, I am sure there are some people who might not know Oracle very well but get along just ...

As I promised earlier, the focus of this blog entry will be using the Editor in Toad for Data Analysts. The Editor is where you can enter your own SQL code to query the database. Since you’re already familiar with Toad for Oracle’s Editor, you’ll notice some similarities in Toad for D ...

In Part III of this series of blogs, I’ll discuss the Query Builder in Toad for Data Analysts. In my previous entry, I said that I would talk about both the Editor and the Query Builder in Part III. Both features are so rich that I feel that separating the topics would be the best ...

Sometimes people will have a problem getting a TOAD feature to work – such as the PL/SQL debugger or profiler. For example a user might run TOAD and not be able to select or highlight the debugger icon on the main toolbar. So when they’re in the editor they cannot seemingly invoke or use the debugger. The initial conclusion is that TOAD must have a bug. But 90% of the time, it’s actually a database setup issue. ...

This blog is the third in a series about misconceptions surrounding SQL tuning that are quite common. It covers the misconception that there is always some SQL syntax that is the best across different databases and hardware environments.

I was on the phone with a Quest Code Tester user the other day and he asked me if I was working on the next edition of my original "magnum opus", Oracle PL/SQL Programming, which would include Oracle11g features.

 

I cannot describe to you how good it felt to say: &q ...

So if you’re reading this blog, hopefully that means you’ve just finished watching my ‘Discover the Hidden Treasures of Toad for Oracle, Developers’ presentation at our 2009 Toad Virtual Expo. If not, then you can still watch this 45 minute presentation for the immediate 60 days after the conference.

Previously, we discussed how to establish connections to the database. If you’re interested in a refresher, the entry can be found here: http://www.toadworld.com/Community/Blogs/tabid/67/EntryID/382/Default.aspx Now that we’v ...

I am often asked about the naming conventions and coding standards that I use. My answer is usually a combination of muttering and vague statements and hand-waving.

 

That's because I have a confession: I don't have a single naming conventions and coding standards document that I use. Why not? Because I am a software developer! That is, I feel (well, I &l ...

In this series of blog topics, I will attempt to translate certain features in Toad for Data Analysts for those of you who are more familiar with Toad for Oracle. As you may (or may not) know, Quest Software allows licensed owners of Toad ...

The last two posts have covered popular misconceptions or “urban myths” myths when measuring and performing benchmarks. That might seem like the “whole enchilada”, but there's yet one more critical aspect to successful benchmarking – preparation. I encounter numerous people who believe that they can simply assemble the necessary hardware, install the OS, install the database software, creat ...

The title says it all – there is no such thing. This is the second benchmarking myth or “urban legend” that needs exposed. However this is the most prevalent frustration or exasperation that people attempting database benchmarks experience – and experience the hard way (i.e. their efforts majorly or totally fail to meet their initial expectations).

 

Ther ...