|
Two approaches to SQL Tuning using the Quest SQL Optimizer for Oracle |
|
BBoise
|
7/30/2009
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
Making Database Changes Logically |
|
Kuljit
|
7/30/2009 8:03 AM
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
|
Configure your Toad! |
|
dnorwood
|
7/29/2009 12:21 PM
|
|
|
|
We all come from different backgrounds... some of us are old Toadies, and some of us are used to different tools. Did you know that Toad for Data Analysts can be configured to act and look much like Toad for Oracle and many other tools? Even down to the keyboard shortcuts? I'll show you how.
|
 |
|
|
Read More...
|
|
|
Test Approach |
|
QCTOblog
|
Tuesday, July 28, 2009
|
|
|
|
Written by Finn Ellebaek Nielsen. Best practices for a test approach that implements the strategy and test policies for Oracle code laid out in a previous blog post.
|
 |
|
Comments (3)
|
Read More...
|
|
|
|
|
Toad for DB2 V4.5 has arrived! |
|
JimWankowski
|
Wednesday, July 22, 2009 1:24 PM
|
|
|
|
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:
&l ...
|
 |
|
|
Read More...
|
|
|
Must Know Features of PL/SQL |
|
StevenFeuersteinTW
|
Wednesday, July 22, 2009 7:50 AM
|
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
SQL Navigator behavior in Toad for Oracle |
|
JeffSmith
|
7/20/2009
|
|
|
|
We got an interesting question into our sales support queue this week. A new Toad user was frustrated because they weren’t seeing the type of feedback they were used to seeing in SQL Navigator.
|
 |
|
|
Read More...
|
|
|
Extended ALTERs and Handling Data in Toad for DB2 LUW |
|
BBoise
|
7/20/2009
|
|
|
|
Last week, I was demonstrating some of our DBA-focused features of Toad for DB2 LUW (Linux, Unix, Windows). When we came to the topic of Extended Alters, the audience voiced some concerns about the efficiency of this feature. Specifically, they were concerned with how Toad for DB2’s generated script was handling the data stored in the table we were altering. The customer is dealing with very large data sets, so simple INSERT statements were not going to help. They wanted to know if Toad for DB2 could take advantage of some DB2 utilities that make this process more efficient. Let’s explore the scenario a little further.
|
 |
|
|
Read More...
|
|
|
|
Data is an Asset |
|
Bert
|
Wednesday, July 15, 2009 5:02 AM
|
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
Toad Tips ‘N’ Tricks |
|
JeffSmith
|
7/13/2009
|
|
|
|
This blog recaps a few of the major highlights that Jeff covers in a typical two hour Toad for Oracle tips and tricks session.
|
 |
|
|
Read More...
|
|
|
Toad's Export File Browser - Developers and DBAs Secret Weapon |
|
MichaelLumbard
|
7/13/2009 6:54 AM
|
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
Executing SQL In Tuning Lab – Part 7 – Testing SQL with Variables |
|
RichardTo
|
Friday, July 10, 2009 5:33 AM
|
|
|
|
A SQL statement with a variable that is provided at run time poses an extra challenge when trying to determine which alternative SQL statement is going to give the best overall performance. Each time the SQL statement is executed, a different variable could be supplied.
|
 |
|
|
Read More...
|
|
|
New TOAD Book Coming Soon!!! |
|
Bert
|
Wednesday, July 08, 2009 6:57 AM
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
Introducing a New Free Utility Download – Toad Group Policy Manager |
|
JohnPocknell
|
Tuesday, July 07, 2009
|
|
|
|
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.
& ...
|
 |
|
|
Read More...
|
|
|
Introducing a New Free Utility Download – SQL Monitor |
|
JohnPocknell
|
Tuesday, July 07, 2009
|
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
Always like to be on the latest version? |
|
JohnPocknell
|
Tuesday, July 07, 2009
|
|
|
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 8th
|
 |
|
|
Read More...
|
|
|
Extending Toad for Oracle’s Code Xpert with the SonarSource dashboard |
|
JohnPocknell
|
Monday, July 06, 2009
|
|
|
|
Written by Olivier Gaudin
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 ...
|
 |
|
|
Read More...
|
|
|
|
Are Database GUI Tools Evil? |
|
Bert
|
Wednesday, July 01, 2009 1:01 PM
|
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
|
|
|
|
TOAD Database Setup Wizard |
|
Bert
|
Wednesday, June 17, 2009 6:07 AM
|
|
|
|
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. ...
|
 |
|
|
Read More...
|
|
|
|
Running Toad for Oracle in a 64 bit environment |
|
MarkQuest
|
6/16/2009 5:42 AM
|
|
|
|
Running Toad for Oracle in a 64 bit environment is really pretty easy and straight-forward, you just have to follow the installation instructions and verify your environment is setup properly.
I have created a short Power Point that shows the steps you need to follow. These instructions come directly from the installation guide as well.
I hope this helps you with your installation.
Mark
|
 |
|
Comments (2)
|
Read More...
|
|
|
Executing SQL In Tuning Lab – Part 5 – Selecting Alternatives to Test |
|
RichardTo
|
Friday, June 12, 2009 5:27 AM
|
|
|
|
In Quest SQL Optimizer when you generate alternative SQL statements for your original SQL statement you may be presented with hundreds of SQL alternatives. The only way to be completely sure that you have the fastest one is to run all the SQL alternatives. But unless the SQL statements run relatively quickly, this is not always practical. So then you are left to determine which SQL statements you should select to test.
|
 |
|
|
Read More...
|
|
|
|
Dev Tips/Tricks Cheat Sheet |
|
JeffSmith
|
6/10/2009
|
|
|
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.
|
 |
|
|
Read More...
|
|
|
|
What Is Unicode? (Part 2) |
|
JohnPocknell
|
Monday, June 08, 2009
|
|
|
|
In this blog, I hope to be able to help you understand how Unicode is handled on your Windows PC/notebook and how to configure your PC/notebook in order to be able to effectively use Unicode in Toad.
|
 |
|
|
Read More...
|
|
|
|
What Is Unicode? (Part 1) |
|
JohnPocknell
|
Monday, June 01, 2009
|
|
|
|
As some of you may already be aware, we are releasing our next version of Toad (version 10.0) later this year and it will have one or two “under the cover” differences. Unicode support is one of those differences and is probably one of the most significant technology upgrades in Toad’s history.
|
 |
|
|
Read More...
|
|
|
Update your Excel reports... automatically! |
|
dnorwood
|
5/29/2009 3:02 PM
|
|
|
|
If there's one thing we hear people asking about it's "How can I use Toad for Data Analysts to automatically update my Excel report?" This blog entry is dedicated to just that. I'll show you how you can get your Excel reports to update from the database in just a few steps - and automate the process for next time!
|
 |
|
|
Read More...
|
|
|
|
Naming Conventions and Coding Standards, the Feuerstein Way |
|
StevenFeuersteinTW
|
Thursday, May 28, 2009 10:32 AM
|
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
|
You might be a Toad user if… |
|
JeffSmith
|
5/27/2009
|
|
|
|
In humble tribute to the great southern comedian, Jeff Foxworthy, I thought I’d try a send up on this popular theme as it pertains to Toad. So here goes. If you have your own suggestions, just leave them as comments at the end of the blog!
-
...
|
 |
|
|
Read More...
|
|
|
Benchmarking Myths Continued |
|
Bert
|
Tuesday, May 19, 2009 5:33 PM
|
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
|
|
Customizing Data in your Toad Explain Plans |
|
JeffSmith
|
5/14/2009
|
|
|
|
When you ask Oracle for an execution plan with Toad, we insert the plan into a plan table (configurable by the user.) Wow, that’s 36 pieces of information that could be included in every single plan step. Now, when Toad shows you a plan for a query, it chooses to show only the most common pieces of information.
|
 |
|
|
Read More...
|
|
|
1 Company, 3 Different Toad Demonstrations |
|
DevinG
|
5/14/2009 6:16 AM
|
|
|
|
I recently performed 3 separate Toad for Oracle web demonstrations for a large company in the payroll and human resources industry. Rather than a general overview of all Toad features, these 3 demos were customized for 3 different types of Toad users: DBA's, Analysts, and Developers.
This group of DBA's had used Toad for years, but had not upgraded recently. As I have menti ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
Push Button Benchmarking |
|
Bert
|
Thursday, May 14, 2009 5:56 AM
|
|
|
|
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 ...
|
 |
|
|
Read More...
|
|
|
|
Sneak Peak at Toad v10 |
|
JeffSmith
|
5/7/2009
|
|
|
While we are still quite a few months away from officially releasing the next version of Toad for Oracle, there are a few exciting developments to share with you today. Of course, you can follow the development of the next version of Toad yourself via the beta program, b ...
|
 |
|
|
Read More...
|
|