|
What's New In JProbe® 8.3? |
|
JohnPocknell
|
Sunday, February 07, 2010
|
|
|
The next release of our popular enterprise-class Java profiler is about to hit the streets and we thought we'd give you a heads-up now to let you know what's coming!
The primary focus of this release is all about usability – right from installation and licensing to configuration ready for use. We've significantly revamped the whole user experience which should get you up-and-runni ...
|
 |
|
|
Read More...
|
|
|
Just Bottom Line it for me, will ya? |
|
BBoise
|
2/5/2010
|
|
|
I have to giggle whenever I read the title of this entry. No, it’s not because I think I’m the King of Comedy (though, I do look pretty funny). The title came from a quote spoken by a former boss I had in a previous life. We were in a meeting with one of those co-workers who notoriously covers all the details of a topic, but rarely gets to the point. After about an ...
|
 |
|
|
Read More...
|
|
|
|
Coming down the pipe, sneak peak at Toad for Oracle v10.5 |
|
JeffSmith
|
1/26/2010
|
|
|
|
A full preview is in the works, but sometimes a new feature is so compelling you just want to start telling strangers on the street about it right away. Rather than make you wait till tomorrow to hear all about Apple’s new tablet device, here’s some juicy Toad gossip right now!
|
 |
|
|
Read More...
|
|
|
|
|
|
Continuous Integration |
|
QCTOblog
|
Wednesday, January 13, 2010
|
|
|
|
Written by Finn Ellebaek Nielsen.
A short introduction to Continuous Integration (CI) and a description of how to integrate testing Oracle code with QCTO in a CI environment.
|
 |
|
Comments (0)
|
Read More...
|
|
|
A New Toad® DBA Suite...for Oracle RAC |
|
JohnPocknell
|
Tuesday, January 12, 2010
|
|
|
|
Oracle Real Application Cluster (RAC) is a single database that is shared by multiple Oracle instances. It provides opportunities for improved database availability, performance and scalability. Oracle RAC lowers the TCO of a high-end database and IT assets, since a complex Oracle database can be set-up on low-cost, standard, modular parts. Oracle RAC has matured into a true enterprise, scalable solution, but t ...
|
 |
|
|
Read More...
|
|
|
Proactive Index Usage Analysis with Quest SQL Optimizer for DB2 LUW |
|
BBoise
|
1/6/2010
|
|
|
Using indexes can improve the performance of applications using the database. This is well known to many, many people. However, the application of too many indexes can have the reverse effect. There’s a balance that must be struck and you may find yourself needing to locate indexes that aren’t being used. If you’re already using the Quest SQL Optimizer for DB2 LUW, ...
|
 |
|
|
Read More...
|
|
|
Book Review: Toad Handbook, 2nd Edition |
|
JeffSmith
|
12/30/2009
|
|
|
|
An exhaustive look at Toad, that doesn’t take that long to read and see immediate improvement in your day-to-day use of the tool. If you are new to Toad, this will shorten the learning curve. If you have been using Toad for 10 years, this will ensure you are not overlooking features or workflows that have snuck in while you weren’t looking.
|
 |
|
|
Read More...
|
|
|
Migrating your BMF Repository |
|
Kuljit
|
12/30/2009 4:39 PM
|
|
|
This blog will give you the necessary steps to migrate your MySQL BMF repository to another database of your choice. The following databases are supported by BMF: Oracle, SQL Server, MySQL and Sybase. We will be using the Data Migration Wizard that is provided to us by BMF.
The first step is to decide which database platform you would like to do the migration for. Once th ...
|
 |
|
|
Read More...
|
|
|
TOAD Database Connections Problems |
|
Bert
|
Monday, December 21, 2009 12:07 PM
|
|
|
One of the most common TOAD questions or problem areas is with connecting to remote and/or local databases. The process and requirements are actually quite simple – yet this remains a high frequency question that seems to cause remarkable confusion. And not just for new Oracle or new TOAD users, as sometimes even old pros can forget and ask. They just often do a Homer Simpson “
 |
|
|
Read More...
|
|
|
How to reference IN argument values in outcomes |
|
QCTOblog
|
Monday, December 21, 2009
|
|
|
Sometimes you need to reference the value of an IN argument (an input, in Code Tester terminology) in your outcome. For example, under certain circumstances, the string returned by your function should be the same as the input value. Or perhaps the out value should be some part of the input value.
You could har ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
Toad® for Oracle 10.1 Updates |
|
JohnPocknell
|
Thursday, December 17, 2009
|
|
|
|
For those of you who haven’t yet upgraded to Toad 10, or were perhaps waiting until the first minor release, here’s a quick synopsis of what really characterizes Toad 10.
Toad for Oracle v10 offers new features and many enhancements to existing features, all of it designed to augment your workflow and to enable you to get your job done more productively ...
|
 |
|
|
Read More...
|
|
|
Toad for DB2 LUW and Spotlight on DB2 LUW play well together |
|
BBoise
|
12/15/2009
|
|
|
|
Did you know that you can call Spotlight on DB2 LUW from Toad for DB2 LUW and vice versa? Well, ok maybe you did. If that’s the case, please move along, there’s nothing to see here. Still with me? Then read on!
Toad for DB2 LUW and Spotlight on DB2 LUW exist as separate executables on your workstation. You might now be thinking “no ...
|
 |
|
|
Read More...
|
|
|
Really Cool 'TOAD-Like' Freeware |
|
Bert
|
Monday, December 14, 2009 6:42 AM
|
|
|
|
We all love TOAD – both the commercial and freeware versions. We love it because it’s simply the best Oracle productivity enhancing tool out there. A few weeks back, I mentioned the many other freeware offerings from Quest. So this week I thought I’d mention a few other freeware offerings that serve me nearly as much as TOAD – just in different functional areas. Here are my top five.
|
 |
|
|
Read More...
|
|
|
|
Why Toad? |
|
JeffSmith
|
12/9/2009
|
|
|
Toad for Oracle is a world-class enterprise query-develop-tune-administration tool for the Oracle database platform. This document attempts to differentiate Toad from the average Oracle IDE or query tool so that the reader can make an informed decision to invest in the Toad product family.
Following is a list of features and concepts that most commerc ...
|
 |
|
|
Read More...
|
|
|
Execute TOAD Scripts on Multiple Databases |
|
Bert
|
Sunday, December 06, 2009 6:33 PM
|
|
|
|
Many TOAD users ask “How can I run my SQL script against a collection or even all my databases all at once (i.e. in a single step)?” The problem is they generally ask this question while in the Editor – which by definition works with but a single active database connection at a time. But if you simply save the editor contents to a SQL script file – you can then use the TOAD Script Manager to execute that script ...
|
 |
|
|
Read More...
|
|
|
Quest Database Freeware |
|
Bert
|
Monday, November 30, 2009 5:26 AM
|
|
|
Often database professionals need good freeware tools to get their job done. Sometimes it’s because there’s no funding for software. And in some cases a tool is needed to replace the purchased tool that ends up not being able to do the job. Finally in today’s world of open source, some people just hate to pay for tools – even if there is budget and/or the job clearly could benefit from commercial qua ...
|
 |
|
|
Read More...
|
|
|
Binding sparse arrays in a FORALL statement |
|
StevenFeuersteinTW
|
Monday, November 23, 2009 8:44 AM
|
|
|
|
FORALL was introduced into PL/SQL in Version 8i. It is a fantastic feature; you should use it in place of all loops that contain DML statements performing row-by-row processing. You will generally see performance improvements of at least an order of magnitude.
If you are not familiar with FORALL, make it a priority to
|
 |
|
|
Read More...
|
|
|
Investigating and Managing Differences with SQL Navigator |
|
BBoise
|
11/23/2009
|
|
|
|
Quest Software has two of the most powerful tools for PL/SQL development: Toad for Oracle and SQL Navigator for Oracle. Personally, I spend more time working with Toad for Oracle and I truly enjoy the solution. Before I proceed any further, I want to clarify a point. I am not advocating one solution over the other for PL/SQL development. That’s a conversation I refus ...
|
 |
|
|
Read More...
|
|
|
|
|
The Subtleties of Programming |
|
StevenFeuersteinTW
|
Monday, November 16, 2009 8:54 AM
|
|
|
|
I recently published the following puzzle in the ToadWorld newsletter:
Which of the following queries return the names of programs (without duplication) defined in the currently connected schema whose source contains a call to DBMS_OUTPUT.PUT_LINE (assume that this program name does not appear inside ...
|
 |
|
|
Read More...
|
|
|
|
De-cluttering Your Toad Desktop |
|
JeffSmith
|
11/11/2009
|
|
|
Quick, what’s the number one complaint about Toad for Oracle?
“The User Interface is waaaaaaaaay too complicated!”
Out of the box, Toad’s setup to pretty much have everything enabled. If we hid stuff, there’s a good chance users would assume the functionality just wasn’t there to be taken advantage of.&am ...
|
 |
|
|
Read More...
|
|
|
Data Warehousing Tools |
|
Bert
|
Monday, November 09, 2009 6:05 AM
|
|
|
Many people these days have to work on both traditional “online transactional processing” (i.e. OLTP) systems as well as data warehouses. But just what is a data warehouse? Generally speaking a data warehouse is nothing more than a specialized business reporting system used by mid to senior level manag ...
|
 |
|
|
Read More...
|
|
|
Handling Complicated Tasks More Easily |
|
QCTOblog
|
Monday, November 09, 2009
|
|
|
Did you know that in Code Tester 1.8.5 you can now perform in-line validation of your customization code? For more complex tests, this will save you lots of time and make it easier to build your regression tests.
The ultimate objective of Code Tester is easy to state: allow de ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
Free TOAD Book Contest Results |
|
Bert
|
Monday, November 02, 2009 12:32 PM
|
|
|
|
I want to start by thanking everyone who participated in the free TOAD book contest by submitting new feature ideas or enhancement requests. I received numerous good ideas. I also received about a third that were already in TOAD – and have been for a long time. I actually can benefit from those emails too, since Quest can probably better expose and/or offer training on those issues. Remember too this wa ...
|
 |
|
|
Read More...
|
|
|
The Most Important Language to Learn |
|
StevenFeuersteinTW
|
Monday, November 02, 2009 6:54 AM
|
|
|
|
I was recently in Germany, and did an interview with Erik Franz of database|pro. One of the questions he asked me was: "Which programming language would you recommend a college student learn to give them the strongest chance at a good job upon graduation?"
I would have loved to be able to answer: "Learn PL/SQL!
|
 |
|
|
Read More...
|
|
|
|
Generate Schema Documentation in Toad for DB2 |
|
BBoise
|
10/26/2009
|
|
|
|
In one of my previous lives, I worked at a startup company testing software. Our application used Oracle as the back-end and the nature of my role had me working closely with our Oracle DBA. As part of our processes, our DBA had to build documentation describing the schemas our application needed. The reports included things like table names, column names and their data type ...
|
 |
|
|
Read More...
|
|
|
More Toad Tips and Tricks |
|
JeffSmith
|
10/26/2009
|
|
|
So with Toad v10 being released, my Tips & Tricks guide became a bit out of date. You can find an updated copy, as well as our v9 copy, here. All of your favorite keyboard shortcuts and workflows rem ...
|
 |
|
|
Read More...
|
|
|
An Amazing Visit to Mexico City |
|
StevenFeuersteinTW
|
Friday, October 23, 2009 5:38 AM
|
|
|
|
As I write this, I am flying back to Chicago now, 9 PM Oct 21, from Mexico City, after a very nice two day visit.
Quest Mexico asked me to come down to help celebrate the release of Toad Version 10
|
 |
|
|
Read More...
|
|
|
Good Database Design – It's Never an Accident |
|
Bert
|
Thursday, October 22, 2009 3:48 AM
|
|
|
|
When designing and constructing a successful (i.e. effective and efficient) relational database, there are two fundamental sets of rules or design principles that are universally accepted and generally practiced by database architects.
|
 |
|
|
Read More...
|
|
|
|
Toad for Oracle Database Connection Styles |
|
Bert
|
Wednesday, October 14, 2009 3:34 AM
|
|
|
|
TOAD offers three distinct ways to connect to your database, as shown by the three tabs circled below on the connection screen. In this week’s blog we’ll examine the differences between the first two: TNS and Direct. No matter which of the three methods you choose, TOAD requires the Oracle “SQL*Net” client to be on your PC. TOAD needs to talk over the network to your database, and that requires certain ...
|
 |
|
|
Read More...
|
|
|
|
|
|
Flow control for your script |
|
Mauritz
|
Wednesday, October 07, 2009 12:16 PM
|
|
|
|
Undocumented functionality in TDA, Toad for SqlServer, Toad for DB2 and Toad for MySQL to use advanced flow control when executing scripts.
|
 |
|
|
Read More...
|
|
|
What’s New in Toad® for Oracle 10 – Part 2 |
|
JohnPocknell
|
Tuesday, October 06, 2009
|
|
|
|
The very latest generation of Toad for Oracle is about to hit the streets (early October) so we thought we’d give you a quick preview now so you’ll be up to speed when it’s released. This blog is part 2 and covers more of the new features and updates.
|
 |
|
|
Read More...
|
|
|
JProbe's new JDBC component nodes |
|
StuartHodgins
|
10/5/2009 11:13 AM
|
|
|
|
JProbe's new JDBC component nodes help link Java and SQL performance analysis together, to identify the root causes of performance issues in your applications, and to help you resolve those issues.
|
 |
|
|
Read More...
|
|
|
Toad's DB Health Check - Is There a Doctor in the House? |
|
MichaelLumbard
|
10/5/2009 7:42 AM
|
|
|
|
As DBAs it seems that we are always faced with issues of Database Performance. As gate keepers to our multiple database environments many of our Service Level Agreements (SLA's) can be directly tied into the health of our databases. Working with Quest's Toad solution we can now take a comprehensive look at the health of our databases with the DB Health Check. ...
|
 |
|
|
Read More...
|
|
|
Highlights of SQL Optimizer 7.5 |
|
RichardTo
|
Friday, October 02, 2009 3:59 AM
|
|
|
Version 7.5 of Quest SQL Optimizer for Oracle will be released in October. The major effort for this new release was in the optimizer engine and the new UI for the optimization, index generation and execution functions. The following is a screen shot of the new UI. It looks tidy and easier to use compared to the old version. All the statistics names now use the Oracle standard na ...
|
 |
|
|
Read More...
|
|
|
A Recent Customer Walk-through of Toad for Data Analysts |
|
BBoise
|
9/30/2009
|
|
|
Sometimes, I’m asked to help a customer work through a particular challenge they’re facing when using one of Quest’s solutions. Many times, the meetings are one-on-one sessions with the customer where we take turns sharing our desktops to better understand the problems being faced and how the solution might be able to address the problems. I actually enjoy the one-on-one sessions, b ...
|
 |
|
|
Read More...
|
|
|
New in JProbe 8.2.0 |
|
StuartHodgins
|
9/30/2009 8:17 AM
|
|
|
|
With General Availability of JProbe 8.2, here is a preview of some of the changes and improvements that you will find in this new release:
The JProbe 8.1 release focused on improvements to JProbe Memory analysis. The JProbe 8.2 release focuses on improvements to JProbe Performance analysis.
Users asked us for the ability to track the runtime execution status of threads. JPr ...
|
 |
|
|
Read More...
|
|
|