Hello, you are not logged in.  Login or sign up
Community >> 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.

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.

Bert Scalzo's Blog
 
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.

Oracle 11g Introduces Invisible Indexes
Bert Monday, August 27, 2007 6:09 AM
As I wrote last week, Oracle 11g has a plethora of really great new features. One that should really hit a home run with data warehousing DBAs is “Invisible Indexes.” The name is not a joke – they are exactly what they say. An invisible index is ignored by the query optimizer when forming an explain plan for a SELECT statement, ...
Comments (0) Read More...

Oracle 11g Improves Partitioning
Bert Tuesday, August 21, 2007 4:21 AM
Oracle 11g has a plethora of great new features. One area that has improved with each of the last four releases has been partitioning, i.e. the method to break larger tables into smaller, more manageable and efficient sub-tables. While it was originally touted as a boon for just the data warehousing world, partitioning no ...
Comments (0) Read More...

Oracle 11g Adds Virtual Columns & Indexes
Bert Wednesday, August 15, 2007 6:18 AM

Oracle 11g is out for Linux – and like every new release, there’s tons of cool new stuff. So over the next few weeks, I will write about some of Oracle 11g’s new features. This week, I’ll look at Virtual Columns and Virtual Indexes.

Comments (3) Read More...

What is Oracle ASM and does Toad for Oracle support it?
Bert Wednesday, August 08, 2007 5:35 AM

We all know that “a picture is worth a thousand words,” so I provided a few pictures (shown below) to try and briefly yet succinctly explain what ASM is and how it’s different than the previous ways of managing disk space within Oracle.

Comments (2) Read More...

DBA Hardware Options “Over the Years”
Bert Thursday, August 02, 2007 6:55 PM

Ever hear people say they miss the good ole days – when times and things were much simpler than now? Well the same is true for Oracle DBAs, the early 90’s (circa 1993) were much simpler in terms of hardware selection for an Oracle server as summarized below.

Comments (0) Read More...

Toad Database Tune and Optimize Check-List
Bert Monday, July 23, 2007 6:53 AM

I use Toad® for Oracle almost everyday to tune and optimize problematic databases for customers, partners and friends. And I noticed that I followed a pattern – which seemed consistent across all such attempts. And although I wrote the whitepaper “

Comments (2) Read More...

Welcome to the new TPC-E Benchmark
Bert Monday, July 16, 2007 10:48 AM
One of the most widely recognized and often quoted database benchmarks is the TPC-C. For over 14 years, the TPC-C has been the industry standard OLTP test; however, it’s very clearly showing its advanced age. The TPC-C does not adequately mimic today’s ...
Comments (0) Read More...

Switching Data Modeling Tools? Ouch!
Bert Monday, June 25, 2007 7:52 AM

Probably the single most painful task in data modeling (or any modeling for that matter) is switching tools. Forget the high direct costs like purchasing licenses and the obvious indirect costs of retraining your staff, because it’s the migration of all your meta-data from one tool to the other that looms large on t ...

Comments (0) Read More...

We don’t need no stinking modeling tool
Bert Friday, April 13, 2007 3:49 PM

You’ll have to forgive me for spoofing the famous movie line “We don’t need no stinking badges” (Treasure of the Sierra Madre, 1948 and Blazing Saddles, 1974), it just seemed quite apropos

Comments (5) Read More...

Toad Data Modeler 3.0 Preview
Bert Monday, March 19, 2007 1:09 PM

In this installment I thought I'd write about the exciting, and soon to debut, Toad Data Modeler 3.0 release rather than yet another boring academic or technical topic on data modeling. TDM 3.0 is quite exciting. While it has not yet been made available for public beta – it will be very soon (so please email the product manager

Comments (2) Read More...

Search Blog Entries
 
Blogger and Topic List
 

 

All Recent Entries
 

 

Johannes Ahrends
Unicode

Steven Feuerstein
Oracle PL/SQL

Daniel Norwood
Toad for Data Analysis
John Pocknell
Toad for Oracle
Bert Scalzo
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
  Henrik "Mauritz" Johnson
Toad Tips & Tricks on the "other" Toads
  Toad World Editor
Toad World issues

  Toad Data Modeler Opens in a new window
Data Modeling
 

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