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.
Database management tools solutions
Toad DevOps Toolkit (and continuous integration 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
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.
Start the discussion at forums.toadworld.com