Hello, you are not logged in.  Login or sign up
BLOGS
Search Toad World Search

Blogs
Toad and Database Commentaries

Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies.  Have some views of your own to share?  Post your comments!  Note:  Comments are restricted to registered Toad World users.

Do you have a topic that you'd like discussed?  We'd love to hear from you.  Send us your idea for a blog topic.

Most recent blog entries
 
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...

What's Next: Toad for Data Analysts v2.5 New Features (part I)
dnorwood 6/30/2009 4:10 PM
Toad for Data Analysts v2.5 is just around the corner. In anticipation of the release, I want to highlight a few of the enhancements that we've made to the product. I'll be posting a new feature every few weeks, so stay tuned!
Read More...

Toad for Data Analysts for the Toad for Oracle User – Part IV
BBoise 6/29/2009
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 ...
Read More...

Executing SQL In Tuning Lab – Part 6 – Testing in a Development Environment
RichardTo Friday, June 26, 2009 6:05 AM
This blog covers testing the SQL alternatives in a development environment when it is not possible to do extensive testing in the production environment.
Read More...

Toad for Data Analysts for the Toad for Oracle User – Part III
BBoise 6/21/2009

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 ...

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...

No single SQL syntax is always the best - 10 Common Misconceptions in SQL Tuning#3
RichardTo Tuesday, June 16, 2009 6:26 AM
Written by Richard To
 
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.
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 (0) 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...

Oracle PL/SQL Programming 5th Edition - "Early Warning"
StevenFeuersteinTW Wednesday, June 10, 2009 11:19 AM
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 ...
Read More...

Dev Tips/Tricks Cheat Sheet
JeffSmith Wednesday, June 10, 2009 7:15 AM

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...

Quest Code Tester for Oracle 1.8.3 Now Available
QCTOblog 2009-06-10 01:26:22Z

Version 1.8.3 of Quest Code Tester is now available for downloading from Quest's on-line SupportLink (after being prompted to log in you will be taken directly to the d ...

Comments (0) Read More...

What Is Unicode? (Part 2)
JohnPocknell Monday, June 08, 2009 6:13 AM
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...

Toad for Data Analysts for the Toad for Oracle User – Part II
BBoise 6/7/2009
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 ...
Read More...

What Is Unicode? (Part 1)
JohnPocknell Monday, June 01, 2009 6:18 AM
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...

Executing SQL In Tuning Lab – Part 4 – Equal Comparison for Run Times: Eliminating the Effect of Network Traffic
RichardTo Friday, May 29, 2009 3:13 AM
When you are executing SQL statements to find which one is the best, you need to take into consideration the factors that can skew the accuracy of the results of the testing. This blog discusses eliminating the effect of network traffic when you are comparing SQL run times.
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...

Toad for Data Analysts for the Toad for Oracle User – Part I
BBoise 5/27/2009

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 ...

Read More...

You might be a Toad user if…
JeffSmith Wednesday, May 27, 2009 5:45 PM

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!

  1. ...
Read More...

Search Blog Entries
 
Blogger and Topic List
 

 

All Recent Blog Entries
 

 

Johannes Ahrends
Unicode and Toad

Ben Boise
Toad SC Discussions

Kevin Dalton
Benchmark Factory

Steven Feuerstein
Oracle PL/SQL

Devin Gallagher
Toad SC discussions

  Henrik "Mauritz" Johnson
Toad Tips & Tricks on the "other" Toads
  Mark Kurtz
Toad SC discussions
Daniel Norwood
Toad for Data Analysts
John Pocknell
Toad for Oracle
Bert Scalzo Indicates Oracle ACE status
Toad for Oracle, Data Modeling, Benchmarking
Jeff Smith
Toad product family
Richard To
SQL Optimization
Jim Wankowski
DB2 - LUW and z/OS
John Weathington
Compliance
Doug Williams
Database Musings
  Toad World Editor
Toad World issues

  Toad Data Modeler Opens in a new window
Data Modeling
 
  Real Automated Code Testing for Oracle
Quest Code Tester blog
 

Copyright 2009 by Quest Software  | Terms Of Use | Privacy Statement | Contact Us