 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.
|
|
|
|
|
|
|
Author: |
Bert |
Created: |
Monday, October 30, 2006 2:02 PM |
 |
|
Providing useful “how to” and “tips and tricks” covering topics such as database admin and development best practices, Toad for Oracle feature insights, and Toad Data Modeler topics.
|
|
Database Version Control via Toad |
|
Bert
|
Wednesday, February 27, 2008 9:01 AM
|
|
|
|
One key task for many DBAs is maintaining a database version control or change revision history. Database version control affords the DBA the ability to restore the database to any prior state, or to detect unplanned database revisions that cause the database to be out of compliance with its specification. One could argue that the latter scenario would unlikely happen in a well controlled production environment ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
|
Toad and Monitoring Indexes |
|
Bert
|
Wednesday, February 13, 2008 10:11 AM
|
|
|
|
Ever wonder which indexes are being used in your database? Well Oracle 9i introduced the capability to track index usage. But you had to learn new ALTER INDEX command syntax to support this and then how to query V$OBJECT_USAGE view to see the index usage information. Well I’m too darn lazy, and why not be – as with most things in Oracle, Toad cleanly exposes this feature and increases its us ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Toad Dynamic SQL Scripting |
|
Bert
|
Wednesday, February 06, 2008 7:36 AM
|
|
|
Sometimes people will request that Toad have a certain special new feature, often special to the task at hand which they’re trying to accomplish. Keeping in mind my recent Toad blog about SQL*Plus compatibility, there are very often easy ways to use existing Toad features to do what the ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Toad and SQL*Plus Compatibility |
|
Bert
|
Friday, February 01, 2008 12:17 PM
|
|
|
|
Sometimes people will ask why can’t Toad work more like SQL*Plus – and the funny thing is the answer is quite often it does. You really just need to know how SQL*Plus works – and then look for the same feature within Toad. Let’s take a very, very common scenario that gets asked almost every quarter. Look at my SQL*Plus SELECT command in the screen snapshot below. Suppose ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Toad’s New & Improved Database Browser |
|
Bert
|
Thursday, January 03, 2008 11:08 AM
|
|
|
|
There are many different types of Toad® users, and since job titles and descriptions vary so widely, it’s tough to say a typical Toad user looks like this and thus needs this. Thus Toad has evolved over time to meet the ever growing needs of our customers. Quest has two key Toad Yahoo discussion groups to fa ...
|
|
|
|
Comments (3)
|
Read More...
|
|
|
Speed Up Toad |
|
Bert
|
Monday, December 17, 2007 1:20 PM
|
|
|
|
It’s not uncommon for software to increase in install size and memory footprint over the years – and Toad®
|
|
|
|
Comments (1)
|
Read More...
|
|
|
Super & Sub Type Option #1 |
|
Bert
|
Friday, November 30, 2007 3:50 PM
|
|
|
|
When we create a super-and-sub type (a.k.a. Inheritance) entity relationship in a logical data model, it’s very clear what the business requirements being communicated are – that different subsets of attributes comprise the “cumulative entity” being modeled depending upon the business context. &l ...
|
|
|
|
Comments (2)
|
Read More...
|
|
|
Oracle 11g on a notebook: Tread Lightly |
|
Bert
|
Friday, November 16, 2007 10:41 AM
|
|
|
|
This blog posting is not meant to demean or slander the Oracle database in anyway. I’ve staked almost my entire career on Oracle technologies – and I intend to finish these last 7-10 years doing more Oracle stuff. To quote a funny Saturday Night Live skit: “Oracle has been very, very good to me.” So my comments are mo ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
|
|
|
|
|
|
|