|
Compelling Features for Upgrading to Toad v9.7 |
|
JeffSmith
|
9/25/2008
|
|
|
|
So, another version of Toad has been released. It happens a few times a year. If you’re lucky it’s up to you if and when you want to upgrade to get your bug fixes or new features. If you’re in a larger organization, there’s a standards committee that decides who gets what when. I thought I’d spend a few minutes to document what I see to be the key features available in v9.7 t ...
|
 |
|
|
Read More...
|
|
|
Policy Data Management in 3 Stages |
|
JohnWeathington
|
Thursday, September 25, 2008
|
|
|
|
In this article, we talk about policies – an important area of your companies governance, risk, and compliance program. We discuss what a good policy looks like, and how you can evolve a policy data management system in 3 stages.
|
|
|
|
|
Read More...
|
|
|
Configuring Toad’s Team Coding with Subversion |
|
JohnPocknell
|
Monday, September 22, 2008
|
|
|
|
With Toad for Oracle 9.7 now available, I thought I’d cover how to configure and use Subversion with Toad’s code sharing utility – Team Coding. We had a lot of requests for this integration and here it is !
The Subversion implementation in Toad allows you to use the conventional file-based check-out and check-in via the Editor’s File Open bu ...
|
|
|
|
|
Read More...
|
|
|
For loops or While loops to scan collections? |
|
StevenFeuersteinTW
|
Monday, September 22, 2008 9:21 AM
|
|
|
|
I have generally recommended in the past that whenever you are writing code to iterate through the elements of a collection, you should use a while loop, combined with the FIRST-NEXT or LAST-PRIOR collection methods.
The key advantage of this approach is that the code will not raise a NO_DATA_FOUND exception if your collection is sparse (there is an index value be ...
|
|
|
|
|
Read More...
|
|
|
|
People Make Mistakes |
|
JohnWeathington
|
Thursday, September 18, 2008
|
|
|
|
Human beings, by their very nature, make mistakes. Even seasoned professionals make simple errors on occasion. In this article we explore the “mistake database”, an architecture to help your company minimize errors.
|
|
|
|
|
Read More...
|
|
|
RAC the Casba |
|
Bert
|
Wednesday, September 17, 2008 5:44 AM
|
|
|
On many occasions, people will email or call me to get help with perceived RAC connectivity issues for various client applications – Toad and other Quest products included. Now some times they may have setups that we’ve not pre-tested, so they have a potential bug – or at least another regression testing scenario for us. But many times, it’s simply a SQL*Net configuration issue. While it’s easy to dr ...
|
|
|
|
|
Read More...
|
|
|
|
New Search tool |
|
ToadWorldAdmin
|
9/10/2008 12:03 PM
|
|
|
|
We know that a lot of users have been frustrated by the search that was being used by Toad World. It's no fun to know that Toad World probably has the answer to your question, the white paper or utiltiy you're looking for and not able to find it. Well, we were feeling your pain, too. Toad World has so much content that we were having problems finding stu ...
|
|
|
|
|
Read More...
|
|
|
Speed Up Toad - Updated |
|
Bert
|
Wednesday, September 10, 2008 3:38 AM
|
|
|
|
It’s not uncommon for software to increase in install size and memory footprint over the years – and Toad is no exception. But, that does not mean that these newer versions have to run more slowly. We take great pride in keeping Toad expedient as it matures. Thus do not simply assume that if your Toad is running slower these days – that it’s just the “cost of progress”. Most often t ...
|
|
|
|
|
Read More...
|
|
|
|
A Question from our Quest SQL Optimizer User |
|
RichardTo
|
Thursday, September 04, 2008 1:50 AM
|
|
|
Recently, we got a question from a customer:
“Why does adding a ||'' to the end of a key value improve performance... in this case significantly, this query runs in 187 milliseconds regularly where without the ||'' it takes minutes to run... This is the only modification in the result set from SQ ...
|
|
|
|
|
Read More...
|
|
|
Getting Risk Right – How Probable is Your Probability? |
|
JohnWeathington
|
Thursday, September 04, 2008
|
|
|
|
Inaccurate risk probabilities can wreak havoc on the applicability of your risk database. Why go through the trouble of setting it up, if bad probability entries render your database unusable? In this article, we explore the importance of getting the risk probability correct, and ways to improve your accuracy.
|
|
|
|
|
Read More...
|
|
|
Automated Maintenance |
|
JimWankowski
|
Wednesday, September 03, 2008 7:31 AM
|
|
|
Automated maintenance began with DB2 LUW 8.2. At this time the behavior of automated utilities had to be controlled manually either through the Control Center or the automation wizard. Now with DB2 9.5 automation of RUNSTATS and REORG commands can be controlled by an XML document referred to as an “automatic maintenance policy” These policies control which objects are consi ...
|
|
|
|
|
Read More...
|
|
|
What’s Coming in Toad 9.7 - Part 2 |
|
JohnPocknell
|
Friday, August 29, 2008
|
|
|
|
It’s almost that time again as another exciting new release of Toad draws closer! We’ve decided that, rather than let you wait until Toad 9.7 is released before you see what’s new, we’ll give you a little fore-taste now! In this final blog (
|
|
|
Read More...
|
|
|
Beyond Compliance – Understanding Risk |
|
JohnWeathington
|
Thursday, August 28, 2008
|
|
|
|
Compliance usually starts with a fire drill, however intelligent companies take the time to step back and put their compliance into perspective. Risk is the key to understanding and optimizing your compliance program. In this article, we discuss risk as an evolution from compliance, and look at some ways to model it in the enterprise.
|
|
|
|
|
Read More...
|
|
|
|
What’s Coming in Toad 9.7 - Part 1 |
|
JohnPocknell
|
Friday, August 22, 2008
|
|
|
|
It’s almost that time again as another exciting new release of Toad draws closer !
We’ve decided that, rather than let you wait until Toad 9.7 is released before you see what’s new, we’ll give you a little preview now !
The main objectives of this release are to provide improved knowledge and e ...
|
|
|
|
|
Read More...
|
|
|
|
Who’s on First? How to Model Accountability |
|
JohnWeathington
|
Thursday, August 14, 2008
|
|
|
|
A consistent pattern that emerges in compliance best practices, is the notion of accountability. Demonstrating accountability is a key component of building a solid compliance program. In this article, we explore the motivation, requirement, model, and architecture to make accountability a reality in your company.
|
|
|
|
|
Read More...
|
|
|
|
|
Writing SQL in Toad for Data Analysis |
|
JeffSmith
|
8/11/2008
|
|
|
In my previous blog, I covered things that you should know about Toad for Oracle’s editor. I thought for today we could spend a few minutes on what users may benefit the most from Toad’s cousin, Toad for Data Analysis. This blog will concentrate on working with SQL. |
|
|
|
|
Read More...
|
|
|
How to Survive a Death March |
|
JohnWeathington
|
Thursday, August 07, 2008
|
|
|
|
A death march is a project that is doomed to fail. If you are in IT, and you are dragged onto a compliance project, chances are you will find yourself stuck here. In this article, I'll give you my tips for identifying a death march, and more importantly surviving one.
|
|
|
|
|
Read More...
|
|
|
|
How to Help Your Company with Financial Risk |
|
JohnWeathington
|
Thursday, July 31, 2008
|
|
|
|
The new SEC standards for SOX compliance have made it clear that your company should spend more time focused on financial risk. In this article, we’ll explore what’s driving this, how you as a database professional can help out, and some design considerations for a Financial Risk Compliance Data Mart.
|
|
|
|
|
Read More...
|
|
|
Toad Executing Scripts against Multiple Databases (Part 1) |
|
Bert
|
Tuesday, July 29, 2008 3:15 PM
|
|
|
|
One of the more frequent questions people ask me is why can’t Toad run scripts or commands against multiple databases at once? Of course as usual the answer is Toad already can – so I’m going to dedicate the next couple weeks’ blogs to this topic.
This week I’ll highlight the first method of running scripts for multiple databases using the “Toad Script Manager”. It ...
|
|
|
|
|
Read More...
|
|
|
Automated Storage management |
|
JimWankowski
|
Tuesday, July 29, 2008 12:30 PM
|
|
|
Continuing on with my discussions on autonomic computing in DB2 is the concept of self managing space. Proper space allocations are another critical factor when it comes to optimizing the performance of your database. Inadequate space allocations can result in application ...
|
|
|
|
|
Read More...
|
|
|
Coping with Disaster |
|
JohnWeathington
|
Thursday, July 24, 2008
|
|
|
|
This article wraps up the series on the types of controls and our discussion of architectures, by taking a look at the adaptive control. We’ll explore how you can support your business deal with the impact of risks, when there is no contingency plan.
|
|
|
|
|
Read More...
|
|
|
Toad Data Modeler Generates Best SQL |
|
Bert
|
Wednesday, July 23, 2008 5:11 AM
|
|
|
|
When you go through the entire exhaustive process of doing an effective (i.e. accurate) logical model so that you have properly captured all the true business rules and requirements, you sure don’t want your data modeling tool to compromise those findings as you move into the physical model – which is database platform dependent. Yet most data modeling tools do a very poor job of translating ...
|
|
|
|
|
Read More...
|
|
|
Toad...and Java??!! |
|
JohnPocknell
|
Tuesday, July 22, 2008
|
|
|
|
I thought that’d grab your attention!
We know there are a lot of PL/SQL developers out there who are looking to make (or have already made) a break into application development using a more popular programming language like Java as well as many Java developers who use Toad to make access to Oracle easier.
< ...
|
|
|
|
|
Read More...
|
|
|
Oracle Open World Presentations |
|
StevenFeuersteinTW
|
Tuesday, July 22, 2008 8:41 AM
|
|
|
|
Hey folks,
For anyone attending Oracle Open World this year, here is my schedule of presentations:
Session ID: S300184
Session Title: Weird PL/SQL
Track: Oracle Develop: Database
Room: Golden Gate C3
Date: 2008-09-21
Start Time: 15:45
|
|
|
|
|
Read More...
|
|
|
10 Things You Must Know about Toad’s Editor |
|
JeffSmith
|
7/22/2008
|
|
|
|
The editor window is probably where most users spend a majority of their time. In this blog, I’ll try to highlight the 10 features that will save you the most time when it comes to writing your SQL queries, SQL*Plus scripts, anonymous blocks, and PL/SQL stored procedures. Please note that all of these features are available in the standard edition of Toad for Oracle, version 9.6.
...
|
|
|
|
|
Read More...
|
|
|
3 Key Tips for Surviving a Firefight |
|
JohnWeathington
|
Thursday, July 17, 2008
|
|
|
|
Nobody likes a firefighting effort, but unfortunately it’s a fact of life that we need to deal with as database professionals. In this article I share my 3 favorite tips for getting through without getting burned.
|
|
|
|
|
Read More...
|
|
|
Only Toad can debug SQL Scripts |
|
Bert
|
Wednesday, July 16, 2008 3:45 AM
|
|
|
|
I have been doing Oracle work for just over two decades – and I’ve probably written thousands of SQL scripts. Many of those were DBA oriented in their task nature, but even application development presents times where SQL scripts are used. For example, the need may arise for the operating systems’ or third party schedulers to invoke a shell script to execute a SQL script to execute ...
|
|
|
|
|
Read More...
|
|
|
How to Correct a Bad Situation |
|
JohnWeathington
|
Thursday, July 10, 2008
|
|
|
|
This is a continuation of a skip series that I’m doing on the architecture of different control types. In this article, we discuss Corrective Controls; why we need them, and how to design for them.
|
|
|
|
|
Read More...
|
|
|
Toad and Dynamic SQL Scripting |
|
Bert
|
Wednesday, July 09, 2008 7:02 AM
|
|
|
|
Sometimes, even in today’s world of super GUI’s, a SQL script is still the best way to do something. Plus there are always those people who steadfastly prefer command line to GUI’s no matter what. Can Toad accommodate and even facilitate these needs? Of course you know that the answer is a resounding yes.
Let’s sa ...
|
|
|
|
|
Read More...
|
|
|
|
Toad Data Modeler Hits a Home Run!!! |
|
Bert
|
Wednesday, July 02, 2008 5:28 AM
|
|
|
|
I have always believed that Toad Data Modeler offers the best, easy to use data modeling tool on the market for the money. Now my faith has been confirmed – others are starting to see just what a gem Toad Data Modeler. Take a look at this review. I agree 100% of course – but everything there is true.
|
|
|
Read More...
|
|
|
Still Testing Your PL/SQL Manually? STOP-RIGHT-NOW. |
|
JeffSmith
|
6/30/2008
|
|
|
|
Anyone who develops, supports, or uses PL/SQL at some level also tests the PL/SQL. It may not be a formal testing environment, but there is a time where you will probably ask yourself, “Does this program actually do what it is supposed to?” I think this is something we can all relate to as computer users.
This type of testing ...
|
|
|
|
|
Read More...
|
|
|
DB2 LUW Autonomics |
|
JimWankowski
|
Monday, June 30, 2008 6:21 AM
|
|
|
Last week I did an IDUG sponsored webcast on the topic of autonomic computing. I wil be excerpting these features over the next few blogs. If you wish to view a recording of the webcast here is the link: http://www.quest. ...
|
|
|
|
|
Read More...
|
|
|
Toad and Oracle Licensing – What’s the Story ? |
|
JohnPocknell
|
Thursday, June 26, 2008
|
|
|
Toad for Oracle may use, but is not dependent upon, Oracle database options such as RAC, Partitioning and Spatial and Enterprise Management (OEM) Packs such as Tuning and Diagnostics depending on various factors. Such Toad features include (but not limited to) ADDM/AWR Reports and AWR Browser which are part of the optional DB Admin module add-on.
|
|
|
|
|
Read More...
|
|
|
When Prevention Fails, What’s Next? |
|
JohnWeathington
|
Thursday, June 26, 2008
|
|
|
|
Okay, we’ve already learned the prevention is the best medicine. But what do we do when we cannot put preventive controls in place? This article answers that question and more, with more examples and data architecture considerations.
|
|
|
|
|
Read More...
|
|
|
Making Toad Do What You Want |
|
Bert
|
Wednesday, June 25, 2008 8:55 AM
|
|
|
|
A lot of times people will ask Quest tech support or via our Yahoo discussion groups how to make the editor run SQL commands and do stuff more like SQL*Plus or how to better control the output look and feel (i.e. behavior). Along those lines and another very popular question is where one can set an option in Toad for the editor to do something specific (e.g. turn off feedback, etc) – because they have ...
|
|
|
|
|
Read More...
|
|
|
Always Bulk Collect |
|
StevenFeuersteinTW
|
Monday, June 23, 2008 7:34 AM
|
|
|
|
You learn something new every day, right? Well, I certainly do (more or less). Even about PL/SQL, about which I am sure many people think I already know everything. Far from it.
In fact, I learned just last week from the PL/SQL Product Manager, Bryn Llewellyn, that his recommendation regarding cursor FOR loops and bulk collect is different fro ...
|
|
|
|
|
Read More...
|
|
|
Writing Better Queries Starts With Understanding |
|
dnorwood
|
6/23/2008 6:52 AM
|
|
|
|
For those of you who may not come from a super-technical background, the term “ER Diagrammer” may sound strange or unfamiliar. Well, for the record, the term “ER Diagrammer” stands for “Entity Relationship Diagrammer” – a fancy name for a tool that displays the relationships between objects (like tables) in the ...
|
|
|
|
|
Read More...
|
|
|
ODTUG Post Mortem |
|
Bert
|
Thursday, June 19, 2008 5:22 AM
|
|
|
|
There are quite a few blogs out there about what happened or what’s new from this week’s ODTUG conference in New Orleans. So rather than restate what many others are reporting, I thought I’d try a slightly different approach – to instead report more on what was noticeably absent or different this year. J
|
|
|
|
|
Read More...
|
|
|
Automated Process Auditing |
|
JohnWeathington
|
Thursday, June 19, 2008
|
|
|
|
In this article, we discuss the importance of understanding your “Really As-Is” process, and the big mistake companies make when building process documents. Then, we explore a data architecture for continuously auditing your process in an automated fashion.
|
|
|
|
|
Read More...
|
|
|
Does a German Toad blog make sense? |
|
ToadWorldAdmin
|
6/18/2008 10:39 AM
|
|
|
|
Aufgrund der großen Anzahl Toad Anwender im deutschsprachigen Raum stellt sich die Frage, ob ein deutscher Toad Blog sinnvoll ist. Wir denken hier zum einen an Themen, die uns im Umfeld Internationalisierung interessieren aber auch an technische Detailfragen, die z.B. übersetzt und so einer größeren Benutzergruppe verfügbar gemacht werd ...
|
|
|
|
|
Read More...
|
|
|
Toad World Blogs |
|
ToadWorldAdmin
|
6/18/2008 10:38 AM
|
|
|
|
As the Admin for Toad World I want to welcome you and thank you for checking out the Toad World blog. This “experts corner” is a collection of blogs by some of the most respected names in the database community. Their blogs will cover a wide range of topics ranging from product insights to new technology developments to requests for your i ...
|
|
|
|
|
Read More...
|
|