Welcome to Coffee with Toad®, the Toad World® blog monthly recap. Published the first Tuesday of every month, Coffee with Toad newsletter is organized by month, then by product, followed by each blog title and a brief description. Go directly to the product of your choice or peruse products that you're interested in. Each month this running blog is updated to include the most recent month first.

So, get your steaming or iced brew-of-choice and get ready to learn about tips and tricks, industry trends, and new releases by reading our knowledge-building, career-enhancing articles written by experts and thought leaders. 

If you would like to keep up to date on the latest trends in database tools and management, subscribe to the Toad World blog via the RSS feed.

Photo of sunrise, coffee and computer for Coffee with Toad, the Toad World Monthly recap.

December 2021

Toad Data Point

Quest® Toad® Data Point 5.6 supports Snowflake

On December 6, Quest® announced the general availability of Toad® Data Point 5.6 with native support for Snowflake, a SaaS cloud data platform.

 

How to use Quest® Toad® Data Point to leverage data automation

Learn how to use data automation features within Toad Data Point to quickly script, reuse and schedule repetitive tasks.

 

Three data preparation challenges that Quest® Toad® Data Point can solve

Toad Data Point is perfect for your data discovery and data preparation needs. Learn how easy it is to use subset and automation features in our latest blog.

 

Toad for Oracle

Free webcast: Dark mode preview, plus Toad for Oracle Base vs. Xpert

Explore the differences and evaluate your needs between Toad® for Oracle Base Edition and Toad® for Oracle Xpert subscriptions in this upcoming webcast.

 

How to load data from Excel into Oracle using Toad®

Are you trying to figure out how to load data from Excel into your database? Learn how easy it is with a powerful tool like Toad for Oracle.

 

How to install an Oracle instant client for use with Toad for Oracle

How to install an Oracle instant client for use with Toad for Oracle: a step-by-step guide with screenshots.

 

November 2021

Apex SQL

Free webinar: ApexSQL Consolidated Audit API and Virtual Lab

Join Software Solutions Consultant, Gary Jerep, to review security market conditions and explore the new capabilities of the ApexSQL Audit virtual lab. 

 

Toad for Oracle

How to schedule batch jobs in Toad for Oracle Pro DB Admin

Scheduling batch jobs allows database admins to run programs at pre-determined times and intervals. Here's a step-by-step tutorial using Toad for Oracle.

 

How to alter and drop database objects with Quest® Toad® for Oracle Pro DB Admin

In part 2 of this blog series, author Deepak Vohra explains how to create, alter and drop database objects using Quest® Toad® for Oracle Pro DB Admin.

 

Free Webcast: Quest® SQL Navigator vs Quest® Toad® for Oracle

Webinar: Explore the differences between SQL Navigator and Toad for Oracle, and see how Toad replicates SQL Navigator at a lower up-front subscription cost.

 

Simplify SQL Trace with Quest® Toad® for Oracle DBA edition

Toad for Oracle provides an intuitive interface to the SQL Trace file for enhanced SQL performance tuning.

 

Free gift: Toad for Oracle Winter Toad icon and wallpaper

Toad for Oracle provides an intuitive interface to the SQL Trace file for enhanced SQL performance tuning.

 

Toad Data Point

How to use Quest® Toad® Data Point to improve data integrity

Toad Data Point helps improve data integrity by performing transformation and cleanse operations and enforcing database referential integrity.

 

October 2021

Toad Data Point

Sales data: How to extract more data value for competitive advantage

Need to understand your sales data? Compare and contrast data with dimensional views to make smarter decisions for a competitive edge. Here’s how.

Winter is coming and so is Snowflake — Toad Data Point 5.5 and 5.6 [Free Webcast]

Learn how to easily access, prepare and report on data from 50+ data sources, including Snowflake. Demo: share data and collaborate using Toad Data Point and Toad Intelligence Central.

 

Toad for Oracle

Free webcast: How can a Quest® Toad® for Oracle Xpert Plus Subscription help me?

Webinar: why should you get a Quest® Toad® for Oracle Xpert Plus Subscription? You get DB admin module, SQL Optimizer and sensitive data protection.

 

How to create database objects with Toad for Oracle Pro DB Admin

Learn how to create, rename and set attributes for database objects in Toad for Oracle Pro DB Admin using this tutorial by Deepak Vohra.

 

Toad for Oracle Release History

Toad for Oracle Release History showing different product versions and the enhancements in each release.

Check out Toad for Oracle subscriptions in the eStore.

 

Toad Data Modeler, erwin

Data modeling tools: a comparison for enterprise vs department use

A comparison of data modeling tools for enterprise vs department use – why erwin Data Modeler and Toad Data Modeler come out on top.

 

September 2021

Quest EMPOWER

Get the power to transform everything at Quest EMPOWER

Quest EMPOWER brings together Quest’s global customers to learn about and expand their understanding of our data empowerment solutions.


ApexSQL

Free database webinar: Toad® loves ApexSQL

Toad product experts introduce ApexSQL tools and how they integrate with SQL Server Management Studio, Azure, DevOps, moving to the cloud and more.

 

Toad for Oracle

DB performance: 120-point database health check across multiple databases

Toad for Oracle Pro DB Admin subscription runs 120 different database health checks to ensure database stability across applications.

 

7 steps to create a successful logical database schema design

Don't know how to start the process of database schema design? Follow this simple 7-step guide to success.

 

Privacy regulation, data protection and how NOT to expose personal and sensitive data

Learn about privacy regulation, data protection and how not to expose personal and sensitive data.

 

Toad Data Point

How to use Toad Data Point to solve data preparation issues

Learn about multiple database/data source connectivity, data cleansing/transformation and data subsetting and data maintenance.

 

Toad DevOps Toolkit

Toad DevOps Toolkit wins Continuous Delivery Product 2021

Looking for the best database devops tool? Quest® Toad® DevOps Toolkit wins Computing Best Continuous Deployment Product in the DevOps Excellence Awards. 

 

August 2021

Database tools

Best data and database tools: Quest® Information Management — DBTA Readers’ Choice Awards

DBTA magazine unveils best data and database solutions for the 2021 Readers’ Choice Awards. Quest Information Management business is best in 5 and finalist in 3.

 

May 2021

Toad for Oracle

What is database schema? Objects, owners, tables and indexes

Are you a new Oracle developer? Learn what an Oracle database schema is and how to use it to build your applications.

 

8 ways to increase your database power and flexibility

Sluggish database? Get your database power and flexibility back. Read this blog, watch the video

 

What is a code review and why PL/SQL code quality is important

Skipping code review? Find what you should look for in a code review tool that can speed the process and position your database for success.

 

Code analysis: Why PL/SQL code quality matters

See the original and best automated, rules-based PL/SQL code review and analysis tool in action in this how-to. Then, try it for free.

 

 

April 2021

Quest

Please vote before May 7! 2021 DBTA Reader's Choice Awards

It doesn't get any better than your customers selecting you as their favorite! Please vote before May 7, in the 2021 DBTA Readers’ Choice awards.

 

Toad Data Modeler, erwin

May 18-20: Data Empowerment Summit [Free Virtual Event]

Learn about the latest trends, best practices and technologies to align Data Operations, Data Protection and Data Governance at this free virtual event.

 

What is data modeling and which tools are the best?

Find out why data modeling is important and which are the best data modeling tools for individuals and enterprises.

 

Toad Data Point

6 questions to ask before you start data prep: Data volume is #1

Starting a new data prep project? This blog/video IDs 6 questions you need to ask before you start any data prep project. Data volume is first on the list.


Toad Edge

How to use Toad developer tools to migrate to open source databases – 3

Migrating to an open source database platform? Which developer tools should you use? Third in a 3-part blog series, read about steps 12-17 in this 17-step tutorial.

 

Toad for Oracle

SQL query optimization: Level up your SQL performance tuning

Can’t find time for SQL performance tuning? Reliant on overstretched DBAs? Learn how to optimize SQL query — in minutes. Video and blog.

 

March 2021

Toad Data Point

What is data preparation and why is it key to the business analyst?

Find out what's behind good data preparation and how it's key to unlocking truth for business analysts by revealing stats for good business decisions. Blog and video.

 

Toad for Oracle

Why You Should Keep Using Quest® Toad with Oracle Databases in the Cloud [Webcast]

Toad in the cloud? A resounding yes! Use Toad to identify cost savings with Oracle databases in the cloud. Product experts show how in this free webinar.

 

How to use Toad® developer tools to migrate to an open source database – 2

Migrating to an open source database? Which developer tools should you use? First in a 3-part blog series, read about steps 5-11 in this 17-step tutorial.

 

SQL performance tuning using Toad® for Oracle Base Explain Plan

What's an explain plan and how do you get one? This questions and many others answered in this blog and video tutorial on SQL performance tuning.

 

How to compare multiple database schemas in Oracle using Toad®

Learn how to compare multiple Oracle database schemas to rebuild or replicate environments using Toad for Oracle in this blog and video tutorial.

 

February 2021

Toad for Oracle

Cyber Security – Why upgrading your Toad® matters – Part 3

Learn how Quest Toad implements three security controls: code signing, software integrity, and FIPS compliance in part 3 of this 3-part blog series.

 

Best developer tool: An Oracle Ace's favorite things in Toad for Oracle Base

Code templates, data export, PL/SQL debugger and SQL editor. An Oracle Ace id's his favorite things about the developer tool, Toad for Oracle Base edition.

 

How to use Toad® developer tools to migrate to an open source database – 1

Migrating to an open source database? Which developer tools should you use? First in a 3-part blog series, read about steps 1-4 in this 17-step tutorial.

 

Coffee with Toad® 2020 [Toad World® blog monthly recap]

Get news, tips and tricks and industry trends: Toad World's database management blogs published in 2020, sorted by product and month.

 

January 2021

SQL Optimizer for Oracle

Index/SQL tuning on relational databases, why is it so darn hard?

Read the blog and watch the webcast to get insights to help you appreciate why query and index performance tuning is so difficult on relational databases.

 

Toad Data Point

Easy data preparation: Toad Data Point v5+ new features

Learn about data prep features: Workbook Interface, Sharing workbooks/ Internal Steps, New Scheduling Features for Workbooks, A hidden gem: Dimensional Views. 

 

Toad for Oracle

Cybersecurity — why updating your Toad® matters — Part 1

Learn how Quest Toad implements three cybersecurity controls: security training, SSDL and third-party software in part 1 of this 3-part blog series.

Cybersecurity – Why updating your Toad® matters – Part 2

Learn how Quest Toad implements three security controls: vulnerability scanning, penetration testing, and malware scanning in part 2 of this 3-part blog series.

 

Read other Coffee with Toad flavors:
Coffee with Toad® 2020 [Toad World® blog monthly recap]
Coffee with Toad® 2019 [Toad World® blog monthly recap]
Coffee with Toad [Toad World Annual recap, 96 blogs]

Toad is a database management toolset from Quest Software, and Toad World® is a community built by Quest®. Toad World has a huge following for good reason—we publish meaningful content. Visit Toad World often for free advice via our blogs, free interactive help via our forums and free trial downloads.

Like this Toad World monthly recap? Share this Toad newsletter with your friends now via the social media icons at the top of this post.

Start the discussion at forums.toadworld.com