Coffee with Toad [Toad World Annual recap, 96 blogs]

This is the annual edition of Coffee with Toad, the Toad World® blog recap.

Published the annually, Coffee with Toad is organized 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.

This year Toad World published nearly 100 blogs! You’ll find blogs on our products, thought leadership, cutting edge technology and even a few on Oracle. 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. 

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.

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.

Like this recap? Share it with your friends now via the social media icons at the top of this post.

96 Toad World blogs published in 2019

The list is long! Skip the scroll and click the link below to jump to your favorite Toad product.

ApexSQL

Benchmark Factory

Database management tools solutions

Toad products (in general)

Toad Data Modeler

Toad Data Point

Toad Data Point Workbook

Toad DevOps Toolkit (and continuous integration tools)

Toad Edge

Toad for IBM DB2 Tools

Toad for Oracle (in general, new release, tutorials) 

Toad for Oracle: Ask Toad webcast series

Toad for Oracle: SQL Optimizer

Toad for Oracle - Sensitive Data Protection

Toad for SAP Solutions

Toad for SQL Server

Toad Intelligence Central

Toad World

Oracle

ApexSQL

An introduction to 8 ApexSQL tools

With its proven SQL expertise and solutions, ApexSQL provides competitive SQL solutions for database auditing, recovery, change management, development and documentation. Check out these eight ApexSQL tools that we think might interest you.

Benchmark Factory

7 Benchmark Factory® tools to speed your DB dev process

Stay ahead. How to use 7 tools. Industry standardized testing, workload replay, SQL scalability testing, test stored procedures, goal-based testing, run rest APIs and reports.

Benchmark Factory: Six-figure savings

Learn how a financials company used Benchmark Factory to save over $100,000 in their hardware migration.

Database management tools solutions

Moving Your Data to the Cloud? Location Matters—SharePlex can help

Two major challenges on the journey to the cloud are security and performance. Learn how SharePlex and other Quest tools can help you mitigate these challenges.

The rise of NoSQL databases and what the future holds for DBAs

John Pocknell of Quest Software shares his thoughts on what changes we can expect to see in database management for 2020.

Migrating Oracle databases to Amazon Web Services

If you are undertaking an Oracle database migration to AWS from your on-premises data center, ask yourself these time and money savings questions first.

What is structured data and its hold on DBAs about?

Structured or unstructured data? What will fuel data growth? What technology will have the most impact on DBAs? And, see an infographic for answers at a glance.

Toad products (in general)

Raiders of the “Lost” Toad: Undiscovered Gems

Even if you're happy with what you already know, there's more to gain from Toad. Read this new blog series to help direct your path to more “hidden” gems. 

How to license Toad products

Watch a quick video tutorial on how to add Toad licenses, manage seats and more.

Toad Data Modeler

5 essential Toad® Data Modeler videos

By the time you finish this blog and watch these videos you can have a model of your database.

Using Application Variables for Naming Relationships and Entities

Using Application Variables for Updating Relationships within Toad Data Modeler.  This Blog post will guide you in how make use of Toad Data Modeler to improve how you represent relationships.

Toad Data Point

12 Days of Toad® Data Point

One tool to rule all: relational databases, flat files, Excel Worksheets, Microsoft Access, sources in the cloud, business intelligence data stacks, NoSQL data. Plus how-to blogs.

Top 10 most popular Toad® Data Point blogs

Toad Data Point: The 10, all-time most popular  blog posts on Toad World today. Year after year, month after month and even daily—these posts get the most visits.

How to prepare data for machine learning

Data can be the most critical piece of a project, even outweighing your choice of algorithm. What steps should you take to create a quality data set?

Data modeling for the business analyst

Need to be more data driven? With massive data growth and multitudes of different data sources, how can you gain the insights you need to help drive business?

How to Write a Cross-Connection Query Correctly

Helpful information on how to write a cross-connection query correctly.  Oracle, SQL Server, Salesforce, MySQL.

Data preparation using Toad Data Point - 1

Learn why data preparation is needed and how you can perform it using Toad Data Point. Toad expert Deepak Vohra demonstrates. Part one of three-part series.

Data preparation using Toad Data Point - 2

Learn why data preparation is needed and how you can perform it using Toad Data Point. Toad expert Deepak Vohra demonstrates. Part two of three-part series.

Data preparation using Toad Data Point - 3

Learn why data preparation is needed and how you can perform it using Toad Data Point. Toad expert Deepak Vohra demonstrates. Part three of three-part series.

Toad Data Point Workbook

How to optimize Toad® Data Point Workbook

6 ways to optimize Toad Workbook to work with large result sets.

Using Transformation and Cleanse in Toad Data Point Workbook

Learn how to use Transformation and Cleanse in Toad Data Point Workbook to help you prep data without having to write complicated SQL.

How to combine workflow result sets in Toad Data Point Workbook using Toad Intelligence Central

In this video you learn how to combine data from different workflows within Toad Data Point Workbook using Toad Intelligence Central.

Learn how to use Dimensional Views in Toad Data Point Workbook

Toad Data Point Toad Data Point Workbook Dim View Dimensional View

Toad Data Point Workbook FAQ

Frequently asked questions about Toad Data Point Workbook.

Guide to using Toad Data Point Workbook

10 short videos to learn more about Toad Data Point Workbook.

How to create a workflow in Toad Data Point Workbook

In this video learn how to create a Workflow in Toad Data Point Workbook.

What is Toad Data Point Workbook?

In this video you will get a brief introduction to Toad Data Point Workbook.

Understanding Toad Data Point Workbooks and Workflows

This video will explain the difference between Workbooks and Workflows in Toad Data Point Workbook.

Learn how to combine data in Toad Data Point Workbook

Toad Data Point Workbook version 5.0 video combining result sets.

Learn how & when to use Toad Views in Workbooks

In this video you will learn how to use Toad Views in Toad Data Point Workbook—specifically to combine workflow results.

Learn how to create reports in Toad Data Point Workbook

In this video you will learn how to create report outputs in Toad Data Point Workbook.

Learn how to email reports with Toad Data Point Workbook

In this video you will learn how to email your reports created in Toad Data Point Workbook. 

Toad DevOps Toolkit (and continuous integration tools)

Bridging the gap between data management and DevOps

Is data critical to driving tech? What's a velocity gap? Can we achieve CI/CD? Plus link to the webinar where 3 subject matter experts explore these questions.

What is database DevOps?

DevOps: Understanding the concept, its practices and how to get there. Bonus Oracle OpenWorld interview video, tech brief and more thought leadership links.

What is DevOps? 3 blogs for a jump start on our toolkit

Do you ask yourself, "What is DevOps?" Read this collection of blogs to gain product insight to our toolkit and learn about continuous integration environments.

How to compare schemas with Toad® DevOps Toolkit 1.3

Read about the basics and how to get started using the new REST API feature in Toad DevOps Toolkit 1.3.

Modernizing Your Database Infrastructure

Database development is catching up with our application development. Integrating database change management with DevOps processes such as Continuous Integration and Continuous Deployment.

Toad Edge

5 blogs that teach you to effectively work in Toad Edge®

Read these blogs that teach you about the most important features of Toad Edge, you’ll be up and running fast.

7 hacks to use Toad Edge like a boss

Read about 7 hacks to get you up and running on Toad Edge, the next-gen toolset for open source relational database environments.

Introducing Toad Edge 2.1

A DBM tool that targets open source relational databases and now supports: Postgres 11, EDB Advanced Server 11, MariaDB v10.2, multi-session views, plus a new DBMS output window.

Toad for IBM DB2 Tools

3 favorite DB2 blogs: Find, detect and compare [How to]

Three tutorials to help you get even more value from your Quest tools.

DBA heroics subdue DB2 performance problems

Familiar with other DBMS? Understand the DB2 process model and learn to quickly identify where performance bottlenecks are occurring on the DB2 database or partition.

What's new in Toad for DB2 v7.0

New in Toad for DB2 v7.0: Custom connection strings, SQL Recall, number of rows to fetch, auto highlight selected word, LUW specific enhancements, z/OS specific enhancements.

Toad for Oracle

In general

5 types of posts in the Toad for Oracle® forum

Toad for Oracle Forum: The best of the best posts. Helpful, entertaining, innovative, bug reports and FAQs.

Top 10 most popular Toad® for Oracle blogs

What's going on in database management? Toad World Blog Monthly Recap highlights the news, tips and tricks and industry trends from the best and brightest.

There’s Something for Everyone at Oracle OpenWorld 2019

Visit Quest at Oracle OpenWorld 2019, Booth 1911, for networking opportunities, cool prizes, and tips on monitoring and managing data.

Quest Software sweeps DBTA Readers’ Choice Awards

Quest Software takes top spots in every single category for the 2019 DBTA Readers’ Choice Awards, winning first in four categories.

New release 

Toad® for Oracle 13.2 new release: Unit test options

Code Tester vs. utPLSQL: Which tool is best for your experience level? Storing, importing and exporting code. Report and production format. [Comparison.]

What is McCabe Cyclomatic Complexity?

Toad has a code analysis feature that scores and grades code. Get familiar with new terms. Join me as I break down the concepts into simple language.

13 new features in Toad® for Oracle 13.2

Top 13 improvements. At-a-glance format: utPLSQL, sensitive data protection, updated Create/Alter DB object windows and updated Analyze Objects. Toad free trial link.

Why can’t database ops align with DevOps processes?

Toad evolves to ease challenges presented by DevOps. The new release of Toad for Oracle 13.2 includes a utPLSQL unit test creation module in all Toad editions.

5 fitness tips for PL/SQL code

Code testing is like fitness training—you know it's a good idea, so why don't you make it happen?  Make functional unit testing part of your regimen.

Tutorials

What is a Toad Snapshot and why should I use it?

This blog will tell you how you can take a picture or snapshot of your Oracle database using Toad for Oracle.

How to use the Toad® SQL Tracker to troubleshoot issues

Find out what SQL Toad and your other Oracle applications are sending to the database. This is really helpful for troubleshooting a variety of issues.

5 reasons why Toad® beats Oracle SQL Developer

Series 1 of 5: Toad for Oracle vs. SQL Oracle. 5 key reasons why a commercial grade software application outperforms a quasi-free tool.

How to save your workspace in Toad® for Oracle

Learn how to create a workspace in Toad for Oracle, so you can quickly resume work after restarting Toad.

How to integrate source control into Toad for Oracle

Learn how to integrate source control into Toad for Oracle with this short video.

Moving your existing Toad for Oracle settings to a new computer

How to move your existing Toad for Oracle settings over to a new computer.  This also shows how to save your settings on a regular basis in case of a computer crash.

Quick tip: Toad for Oracle Jump Search

Learn the many ways the Toad for Oracle 'Jump to... ' feature can help you.

Toad code review - useful to the programmer

The Toad code review feature can help programmers show that their code is clean and compliant with rules. Dan Hotka provides an overview of this feature. Learn how you can use it.

Toad templates

Toad comes with a ton of code templates, which often have substitution variables as well.  Toad expert Dan Hotka explains. Learn more.

Toad for Oracle: Ask Toad webcast series – quick lessons in 30 minutes or less.

Introducing Ask Toad webinar series!

Learn about Ask Toad, a  new web series in which Toad professionals will field your questions about database related topics, trends, and issues. Watch the first episode and sign up to see more!

Session 1: How Do You Enforce Coding Best Practices in Toad® for Oracle?—Ask Toad

Session 2: How can you simplify and automate SQL optimization for developers in Toad for Oracle?—Ask Toad

Session 3: How do I reduce risk by automating database changes?—Ask Toad

Session 4: The simple way to convert an Oracle database to a new database—Ask Toad

Session 5: Integrate your version control system with Toad—Ask Toad

Session 6: How can I recover from an unplanned transaction?—Ask Toad®

Session 7: Mapping your PL/SQL dependencies—Ask Toad®

All Sessions: Ask Toad: A webcast series for Toad® for Oracle users

Toad for Oracle: SQL Optimizer (available in Expert edition and above)

9 blogs to help solve your most challenging SQL tuning

A SQL optimization component that is unique in the industry and will empower you to optimize your SQL whether it be via rewrite, adding Indexes or even Plan Control.

SQL in COBOL? Find and tune your SQL wherever it is.

How to proactively scan for SQL that may not be running using the “Scan SQL” feature within Toad SQL Optimizer. [Tutorial]

SQL Optimizer for Oracle – Un caso real de optimización de una consulta SQL

Conozca cómo un DBA utilizó SQL Optimizer for Oracle para reducir un proceso que tomó más de seis horas originalmente a solo 23 minutos después de la optimización.

SQL Optimizer for Oracle - a success story

Learn how a DBA used SQL Optimizer for Oracle to reduce a process that took over six hours originally to just 23 minutes after optimization.

Toad for Oracle - Sensitive Data Protection

5 blogs on sensitive data protection. Start today.

“Am I keeping customer data safe?” Learn how you can edit existing rules, delete unneeded rules, and add completely new rules using PCRE(PHP) Regular Expression language.

How to find and protect sensitive data in your database

Sensitive data protection tutorial (Part 2 of 2): how to use the search feature within your database, apply default policies, and create a recurring task.

How to define sensitive data rules and default policies

Sensitive data protection tutorial (Part 1 of 2): defining rules and default policy actions within Toad for Oracle.

Amphibian Evolution, GDPR and Sensitive Data Protection

DBAs: Do you know where your private data is? Easily scan all your databases, identify where PII exists and enable your company to protect sensitive data.

Toad for Oracle Sensitive Data Protection Module FAQ

5 top questions answered.

Guide to the Toad for Oracle Sensitive Data Protection Module

Learn about the new Toad for Oracle—Sensitive Data Protection features that fall into two categories of functionality: Sensitive Data Awareness and Sensitive Data Search.

How to Activate the New Toad for Oracle Sensitive Data Protection Module

It's easy. Learn how to activate the new Toad for Oracle Sensitive Data Protection Module and you will be up and running in no time.

PII – It’s not just for dessert!

Learn about the new features available in Toad for Oracle that make it easier to identify and protect this sensitive data.

Toad for SAP Solutions

2 Toad for SAP Solutions videos on database and data

Watch and learn about database mapping and understanding data using this Toad solution.

Toad for SAP Solutions - How to troubleshoot

Learn how to contact support and prepare support requests when having problems with Toad for SAP.

Toad for SAP Solutions - How to automate repetitive tasks

Learn how to automate repetitive tasks in Toad for SAP in this two-minute overview.

Toad for SAP Solutions - How to organize your content

Watch how to organize your content in Toad for SAP Solutions from Quest.

Toad for SAP Solutions - How to update your production environment

See how to update your production environment in Toad for SAP Solutions in our quick video.

Toad for SAP Solutions - How to keep test data updated

Watch our quick video to learn how to keep test data updated with Toad for SAP Solutions.

How to easily move data with Toad for SAP Solutions

Learn how to easily move data with Toad for SAP Solutions from Quest. Watch this quick video to learn more.

Toad for SQL Server

Server Compare sets itself apart [Toad for SQL Server]

Learn how to use this powerful feature that allows you to easily compare and synchronize properties between SQL Servers.

Toad Intelligence Central

Toad® Intelligence Central + 3 blogs = Data collaboration

Toad World

Add Comments to the Toad World Blog

Toad World now supports adding comments to blog posts. Did you like a blog post? Start a new discussion or join a discussion in progress. Share your thoughts about a blog post with the Toad community.

Oracle

Oracle Hybrid Database Cloud using Enterprise Manager – Part XX

Explore hybrid cloud management using Oracle Enterprise Manager Cloud Control 13c installed on premises and an Enterprise Manager hybrid cloud agent on installed on the Oracle public cloud. Part XX of demo series.

Database as a Service using Enterprise Manager – Part XX

Follow an expert and explore the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database-as-a-Service (DBaaS) cloud. Part 20 of series.

Oracle Hybrid Database Cloud using Enterprise Manager – Part XXI

Explore hybrid cloud management using Oracle Enterprise Manager Cloud Control 13c installed on premises and an Enterprise Manager hybrid cloud agent on installed on the Oracle public cloud. Part 21 and conclusion  of demo series.

Database as a Service using Enterprise Manager – Part XXI

Follow an expert and explore the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database-as-a-Service (DBaaS) cloud. Part  21 and conclusion of series.