• Toad Data Point: How do I know that my data is accurate?

    How data is stored in databases is generally driven by the concepts of normalization – where you try to reduce data redundancy and improve data integrity. This has been the foundation of relational databases since their inception. However, when data is…

  • Get a single view of all your company’s data without the need for a data warehouse

    Over time, as more and more applications introduce more and more databases into your company, your data becomes siloed and getting accurate information becomes challenging.

    The popular answer to this challenge has been the introduction of data warehousing…

  • Database development and management while working from home [IT and Covid-19]

    Just when you thought your database development was running on all cylinders, **BAM** the pandemic hit, and now your database developers are practicing social distancing and working from home (WFH).

    As shelter-in-place orders have spread across entire…

  • Three Quick and Easy Ways to Improve Data Preparation

    By next year, there will be more digital bits than stars in the universe, according to IDC. That’s a daunting prospect for any data professional. Add to that the complexity of data types and the ever-growing number of data sources, and it’s easy to see…

  • Comparing The Compare - Quest Foglight and Toad

    To compare is to measure, estimate, or make note of two or more “ things’ “ similarities and/or differences. It helps us better understand the items. A versus B. Sometimes it is done to learn which one is ‘better’. Other times, it is to determine those…

  • These Editor Tricks are Treats!!

    For a Happy Halloween and a happy time anytime in Toad! Enjoy these five sugar free Toad Treats!!

     

    1. Toad Script Runner (TSR) - Have long running SQL Statements in Toad and think you need to open up another session of Toad? Don’t do that, instead go to…
  • Videos, videos, videos for the NEW Toad Edge

    In our Toad World community, there are new Toad Edge tutorials videos available to accelerate the learning and functionality process.

    The latest three videos are:

    • Covering how to use snapshots
    • How to use the JSON editor and
    • How to access the SQL recall…
  • Toad Turnpike: Real Stories from the Road

    Off-roading, Maps, and Nine Gray Hairs

    We all tend to spend most of our time on the “turnpike” of a product’s feature set: you know, the “power” set of its features that get us to many of our endpoint destinations within the product as productively as…

  • Toad Data Point 4.1’s NEW 64-bit Installer is now available!

    One of the big new features of Toad Data Point 4.1 release is a 64-bit installer offering.

    There is a unified installer that contains both a 32 and 64-bit Toad Data Point 4.1 installer.

    (Note:  The Toad Data Point beta will only come in a 64-bit installer…

  • Using Toad to generate data for SharePlex replication

    When installing SharePlex one of the things you need to do is verify the installation is working by using the SharePlex test tables before using your own tables. 

    There are a couple of scripts you can run to do this but in the video I recorded I show you…

  • Toad for Oracle's Multifunctional and powerful connection window

    Connecting.
    We do it every day.
    Person to person – and on a network level, database client to database platform.

    Toad for Oracle’s legacy has always been about increasing performance, configuration, and internal self-help in solving technical…

  • Toad Turnpike: Real Stories from the Road

    Friends in High Places

    I’m starting a blog series about our Toad solution family, and how it’s changed lives for almost 20 years now.  Sometimes a vendor’s product does something extraordinary for its customers.  The stories you read…

  • Using Oracle Enterprise Manager? See How Toad™ DBA Suite for Oracle Complements It - Part 3 of 3

    Under the Hood: Change Management

    In my two previous posts I covered performance management and database maintenance in Toad™ DBA Suite for Oracle®. I’ve been emphasizing how Toad complements Oracle Enterprise Manager (OEM) for most DBA tasks and can…

  • What is the Toad for Oracle License Key, Site Message and Authorization Key?

    Sometimes authorizing a product can be confusing with the terms that are used.

    As with many Quest products, there is a two-step authorization process.

    A license key or Authorization key will need to be inputted; along with its Site Message string.

    These…

  • Accurately Predict the Lifetime of your Database Hardware

    I’m sure as DBAs we’ve all been there; your IT manager comes to you saying the warranty is expiring on the production database server and asks “do we extend or replace the server”? Both choices lead to further questions. If you decide to extend the warranty…

  • Three Ways (TNS, Direct and LDAP) Toad for Oracle Can Connect to an Oracle Database

       
       

     

    Connecting to your Oracle databases is one of the simplest tasks until you can't connect. This becomes the ultimate roadblock stifling your ability to get your work done.

    Fortunately, Toad for Oracle users have a useful Login Connection…

  • Our Products Aren’t Good; They’re *#$#$@ Great!

    We're awesome

    Dollar Shave Club’s founder Michael Dubin said something like that in his first viral video about his company, and it completely changed the razor market. For a few bucks a month, his company would ship razors and blades directly to your home once a…