|
Collaborate Coming – with Special Toad Tips & Tricks |
|
Bert
|
Wednesday, February 25, 2009 6:11 AM
|
|
|
|
The joint IOUG and OAUG Collaborate 2009 conference is a just over two months away. Not only is Collaborate a premier event for Oracle database technology and applications technical sessions, it’s a good format for hobnobbing with fellow database professionals.
This year’s event is being held Sunday, May 3rd, through Thursday, May ...
|
 |
|
|
Read More...
|
|
|
Customizing Toad Code Templates |
|
JeffSmith
|
2/24/2009
|
|
|
|
I recently got an email from a user, and after I replied figured that it might be helpful for others to see as well.
The Question:
“I was at the ROUMG conference and have a question. You guys showe ...
|
|
|
|
|
Read More...
|
|
|
Oracle Configuration for Toad Usage |
|
Bert
|
Wednesday, February 18, 2009 8:04 AM
|
|
|
|
Like most things in life, there are prerequisites and preparations for Oracle databases. Regardless of version, this is especially true for application access and usage. Oracle is a highly scalable and configurable database, therefore DBAs must configure their database for how it will be used to guarantee meeting their users’ expectations – including database developers. Failure to do so can lead to p ...
|
|
|
|
|
Read More...
|
|
|
|
|
Creating a minimalist Oracle 11g database |
|
Bert
|
Wednesday, February 04, 2009 8:09 AM
|
|
|
|
The Oracle 11g database is nothing short of a modern technical marvel. From the features it offers to the many platforms it runs upon – it’s amazing how far they’ve come. But as a “true enterprise” database, Oracle 11g requires some DBA oversight to be applied when creating databases. Although Oracle supplies a very simple and yet fully capable database creation ...
|
|
|
|
|
Read More...
|
|
|
|
|
What Version of Toad Should We Use? |
|
Bert
|
Wednesday, January 21, 2009 6:39 AM
|
|
|
|
We don’t get this particular question per se as often as one would expect, but we do see enough user problems where this fundamental issue becomes the underlying question to answer for problem resolution. Below is a chart for the release dates for both Toad and Oracle. The “blue highlighted” dates are when Oracle first releases a major new version, such as Oracle 10g in January of 2004. But it’s the “red highli ...
|
|
|
|
|
Read More...
|
|
|
|
Black Box Data Store: Lessons Learned from the NTSB |
|
JohnWeathington
|
Friday, January 16, 2009
|
|
|
|
US Airways flight 1549 teaches us that improbable events actually do occur sometimes. When the NTSB goes to investigate, the airplane’s black boxes will prove vital in the determination of cause. We can leverage this concept to fortify our chances of surviving a serious investigation. In this article I introduce design considerations for what I call the Black Box Data Store, the important data you need to prove your innocence in an investigation.
|
|
|
|
|
Read More...
|
|
|
Toad “Explains” It Best |
|
Bert
|
Wednesday, January 14, 2009 7:31 AM
|
|
|
|
Oracle explain plans – they are considered by many as critical when optimizing or tuning SQL statements (I however prefer to look at trace data in conjunction with explain plans). For those who prefer primarily to rely on explain plan interpretation, comprehension and improvement – Toad offers numerous capabilities to make the entire process simpler and more productive. Because let’s face it, explain plans are li ...
|
|
|
|
|
Read More...
|
|
|
|
How to Survive a Break Without Breaking the Company |
|
JohnWeathington
|
Thursday, January 08, 2009
|
|
|
|
Coming off of a break myself, it seems appropriate to discuss the architectures what support continuity, when your company takes a break from following compliance policy. In this article, we discuss why this might happen, and what you can do to minimize the disruption this type of break can cause.
|
|
|
|
|
Read More...
|
|
|
|
Run Toad Freeware on Linux! |
|
Bert
|
Wednesday, January 07, 2009 7:48 AM
|
|
|
I’ve got Toad Freeware installed and running on my Ubuntu 8.10 Linux machine – and so far, not a single problem has yet occurred (knock on wood).
Here are the basic steps that I had to perform in order to “
|
|
|
|
|
Read More...
|
|
|
|
DB2 2009 |
|
JimWankowski
|
Tuesday, January 06, 2009 8:19 AM
|
|
|
|
Happy new year everybody. I hope everyone had a great holiday season. It’s tough getting your head back in the game after a long holiday, that’s for sure! But there is a lot to look forward to in 2009 with our DB2 products. Toad for DB2 came a long way in 2008. As y ...
|
|
|
|
|
Read More...
|
|
|
|
How to use Quest SQL Optimizer to Tune Complex SQL - A Real Life Example #1 |
|
RichardTo
|
Friday, December 19, 2008 12:16 PM
|
|
|
|
Recently, I received an email from the presales support team. They asked me to help them tune three SQL statements for a benchmark database provided by a customer. Our presales support said that our SQL Optimizer was not providing any alternatives for two of these three complex SQL statements. I found two of these SQL statements were very complicated and I knew that there should be a lot of alternative SQL genera ...
|
|
|
|
|
Read More...
|
|
|
Toad + Excel = Easy Data Access |
|
Bert
|
Wednesday, December 17, 2008 6:27 AM
|
|
|
|
Many business analysts rely heavily upon Microsoft Excel as one of their primary tools for manipulating and reporting upon their business data. Sometimes they will send data extraction requests to their information systems (IS) people to perform and then deliver, sometimes they’ll instead access it themselves in place via the external data interface within Excel, and sometimes they’ll extract the data ...
|
|
|
|
|
Read More...
|
|
|
Virtual Paranoia? |
|
Bert
|
Wednesday, December 10, 2008 7:24 AM
|
|
|
|
Lately I’ve been seeing what I think might be an interesting yet disturbing new trend: whenever there’s a problem that initially seems unusual and/or unexplainable, it’s not uncommon to quickly question virtualization as a potential source of the issue. I fully understand that virtualization adds a new variable to the basic equation – and represents greater complexity due to more moving parts. But it seems to b ...
|
|
|
|
|
Read More...
|
|
|
Automatic refactoring in PL/SQL tools – Part 1 |
|
StevenFeuersteinTW
|
Tuesday, December 09, 2008 12:23 PM
|
|
|
|
I have long been attracted to the idea and process of refactoring (explained below). It is now very exciting to see that automated refactoring features are working their way into tools for PL/SQL development. I will analyze these features over the next few entries in my ToadWorld blog, starting with SQL Develop ...
|
|
|
|
|
Read More...
|
|
|
Happy Holidays: A Toad AppsDesigner App Just for You! |
|
JeffSmith
|
12/5/2008
|
|
|
For most users, the significant new feature for v9.7 will be the AppsDesigner. This technology allows a Toad user to take a collection of Toad commands or Actions and create a miniature Toad App or macro that you can then replay on demand or schedule to run when needed.
Like most new features, you gen ...
|
|
|
|
|
Read More...
|
|
|
|
Oracle + VMware = Success Part IV |
|
Bert
|
Wednesday, December 03, 2008 10:47 AM
|
|
|
A few weeks ago I wrote Part III of this series – and fortunately (or unfortunately for my poor ego) an astute reader wrote to ask for some clarification on my Excel chart. Ends up my Excel formula had a mistake – so many than ...
|
|
|
|
|
Read More...
|
|
|
|
|
F-what? |
|
JeffSmith
|
11/20/2008
|
|
|
After working with Toad for almost a decade (I think I first saw it as a new grad in ’99…), I tend to start taking things for granted when I do demonstrations for customers or present at conferences on the beauty of Toad. It’s very easy to get excited about CRUD Matrices and the beauty of PL/SQL debuggers, but overlook the critical core features that users often miss out on.
|
|
|
|
|
Read More...
|
|
|
Run Toad off a USB Flash Drive |
|
Bert
|
Wednesday, November 19, 2008 1:32 PM
|
|
|
Lot’s of people have asked “How can I setup Toad to run off a flash drive?” The reason for this question varies in nature and intent by requestor – but the general concept is that some users need the ability to carry Toad with them. Some are contractors who must use whatever computer and/or desk is open that day. Some are database developers who must travel around their company to perform or assist w ...
|
|
|
|
|
Read More...
|
|
|
Speeding-Up Oracle on Your Notebook PC |
|
Bert
|
Wednesday, November 19, 2008 7:29 AM
|
|
|
|
Just a quick blog this week – some relatively easy suggestions on how to make Oracle run as fast as possible on minimal computer setups such as a notebook PC. My goal is simply to squeeze as much performance blood from the Oracle turnip as possible when deployed on limited capacity equipment. The suggestions below should work for most operating systems, including Windows, Mac-OS and Linux – simply interpret and ...
|
|
|
|
|
Read More...
|
|
|
Just Make Oracle Go Faster |
|
Bert
|
Wednesday, November 12, 2008 8:25 AM
|
|
|
|
Catchy title – huh? But don’t laugh, in today’s hectic world many database professionals (whether DBA’s or developers – and sometimes even end users) just wish that the Oracle database would go faster. That may seem self evident – but let’s just accept that premise for now. So what does this mean for Toad users?
Toad offers numerous database monitoring, ...
|
|
|
|
|
Read More...
|
|
|
|
Getting to know the Query Builder in Toad for Data Analysis |
|
dnorwood
|
11/5/2008 3:04 PM
|
|
|
|
Query Builder is the heart and soul of Toad for Data Analysis. We've spent lots of time and effort working to make it very useful and intuitive. Recently, in version 2.0 of Toad for Data Analysis, we introduced a few new features including reverse engineering SQL to a Query Builder model, creation of DDL scripts and better connection awareness. The linked doc is a very nice write up that Shawn Pickett (Senior Developer) and Alan Bala (Development Team Lead) have put together.
|
|
|
|
|
Read More...
|
|
|
|
Unicode Migration |
|
Johannes
|
11/3/2008 9:24 AM
|
|
|
|
Migrating to a database that supports Unicode is a challenge. You are safe if you are currently using US7ASCII for you Oracle database because Oracle provides a mechanism with ALTER DATABASE SET CHARACTERSET UTF8 which allows you by just bouncing the database to switch to this new character set. But what if you are currently on a different character set? In Europe we have a bunch of WE8 (Western Europ ...
|
|
|
|
|
Read More...
|
|
|
Congratulations to the newest Oracle Magazine PL/SQL Developer of the Year! |
|
StevenFeuersteinTW
|
Monday, November 03, 2008 8:03 AM
|
|
|
|
As I travel certain parts of the globe doing presentations on PL/SQL, I meet many extremely talented PL/SQL programmers – people who meet the most complex challenges you can imagine with a deft combination of intense creativity, hard work, and of course Oracle PL/SQL.
Oracle Magazine names only one as the PL/SQL Developer of the Year at each Oracle Open World, and this year the award was g ...
|
|
|
|
|
Read More...
|
|
|
|
Play games to become a better developer! |
|
StevenFeuersteinTW
|
Tuesday, October 28, 2008 9:23 AM
|
|
|
|
Part 2: The Game of Mastermind
Software development is one heck of a serious job. It turns out, however, that there are several games you can play to improve the quality of code you write. This is the second of two blog entries that introduce you to two of my favorite brain development and training games:
|
|
|
Read More...
|
|
|
|
Inside the application data directory |
|
Mauritz
|
Thursday, October 23, 2008 12:28 AM
|
|
|
|
If you have ever looked in the Toad data directory you were probably a little bit bewildered about all the stuff in there. This article will try to shed some light on what all the files in there are used for by the Toad application.
|
|
|
|
|
Read More...
|
|
|
Oracle + VMware = Success Part II |
|
Bert
|
Wednesday, October 22, 2008 2:40 AM
|
|
|
Last week I wrote about how simply adjusting various virtualized infrastructure default settings that a database could perform up to 440% better. Of course “ your mileage” will vary, but the key point is ...
|
|
|
|
|
Read More...
|
|
|
Code completion revealed |
|
Mauritz
|
Tuesday, October 21, 2008 5:44 PM
|
|
|
|
From the first version of Toad we have always had some form of code completion (It was originally called Toad insight or something like that) but it has always been a fairly simple affair where you either got a list of columns in select statements or a long list of objects of many different types completely unaffected by the context in which you invoke the code completion. Starting in 4.0 the c ...
|
|
|
|
|
Read More...
|
|
|
Connection and transaction handling explained |
|
Mauritz
|
Monday, October 20, 2008 12:10 PM
|
|
|
|
In an application like Toad connection and transaction handling will invariant become a complicate affair. During the years we have been working on this we have tried to make it as intuitive as possible so that you usually don't have to think about it. However, in some cases you can still run into problems so this post will try to explain how we handle connections and transactions so that you can avoid the pitfalls.
|
|
|
|
|
Read More...
|
|
|
Toad version numbers explained |
|
Mauritz
|
Monday, October 20, 2008 12:08 PM
|
|
|
|
Version numbers between the different components of the different products can be pretty confusing ever for us who work on it. Before 3.0 of the Core (The part of Toad that is shared between the products) each product had it's own release schedule and with that each had it's own release version of this. After release 3.0 we now try to coordinate releases between the different products (They are usually staggered ...
|
|
|
|
|
Read More...
|
|
|
Reducing startup time |
|
Mauritz
|
Monday, October 20, 2008 12:08 PM
|
|
|
|
For the upcoming 4.1 release I have actually been able to spend quite a lot of time to reduce startup time in Toad and hopefully there should be a quite noticeable difference. One of the changes made is to make the initialization multithreaded so the improvement should be even more pronounced if you have more than one CPU core.
There are a couple of other things you can do yourself in both 4 ...
|
|
|
|
|
Read More...
|
|
|
Toad nomenclature |
|
Mauritz
|
Monday, October 20, 2008 12:06 PM
|
|
|
|
We have a bunch of terms referring to different aspects of the Toad application internally and I thought I would share some with you because it's not that uncommon that it slips out in the Yahoo Boards when we talk about it so why not just go through them and explain them.
|
|
|
|
|
Read More...
|
|
|
Command line reference |
|
Mauritz
|
Monday, October 20, 2008 12:03 PM
|
|
|
|
The documentation of what command line options are available on the Toad.exe is not necessarily that well covered in the documentation. True there is rarely any need to specify anything on it unless something goes wrong. I just thought I'd go through what is available.
First of all the format. Toad allows any parameters to be specified regardless of if it knows what they are or not because s ...
|
|
|
|
|
Read More...
|
|
|
The history of Toad for SQL Server |
|
Mauritz
|
Monday, October 20, 2008 11:55 AM
|
|
|
|
I recently took some time to look through the different releases we have made of Toad over the years since we started and just thought I would share it with you guys. I chose the Toad for SQL Server release because that was the one which had made the most releases (For instance
|
|
|
Read More...
|
|
|
Starting this blog |
|
Mauritz
|
Monday, October 20, 2008 11:44 AM
|
|
|
|
Every once in a while I've been writing Toad stuff on my personal blog and I figured it is time to stop doing that and try to do this blog into something a little bit more useful. Entries in this blog will also be cross posted on the site Toad Wrangling
I will try to write tips and tricks about how to use Toad as I can think of them ...
|
|
|
|
|
Read More...
|
|