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.
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.
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.
Learn how a financials company used Benchmark Factory to save over $100,000 in their hardware migration.
Database management tools solutions
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.
John Pocknell of Quest Software shares his thoughts on what changes we can expect to see in database management for 2020.
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.
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)
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.
Watch a quick video tutorial on how to add Toad licenses, manage seats and more.
Toad Data Modeler
By the time you finish this blog and watch these videos you can have a model of your database.
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
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.
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.
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?
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?
Helpful information on how to write a cross-connection query correctly. Oracle, SQL Server, Salesforce, MySQL.
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.
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.
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
6 ways to optimize Toad Workbook to work with large result sets.
Learn how to use Transformation and Cleanse in Toad Data Point Workbook to help you prep data without having to write complicated SQL.
In this video you learn how to combine data from different workflows within Toad Data Point Workbook using Toad Intelligence Central.
Toad Data Point Toad Data Point Workbook Dim View Dimensional View
Frequently asked questions about Toad Data Point Workbook.
10 short videos to learn more about Toad Data Point Workbook.
In this video learn how to create a Workflow in Toad Data Point Workbook.
In this video you will get a brief introduction to Toad Data Point Workbook.
This video will explain the difference between Workbooks and Workflows in Toad Data Point Workbook.
Toad Data Point Workbook version 5.0 video combining result sets.
In this video you will learn how to use Toad Views in Toad Data Point Workbook—specifically to combine workflow results.
In this video you will learn how to create report outputs in 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)
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.
DevOps: Understanding the concept, its practices and how to get there. Bonus Oracle OpenWorld interview video, tech brief and more thought leadership links.
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.
Read about the basics and how to get started using the new REST API feature in Toad DevOps Toolkit 1.3.
Database development is catching up with our application development. Integrating database change management with DevOps processes such as Continuous Integration and Continuous Deployment.
Read these blogs that teach you about the most important features of Toad Edge, you’ll be up and running fast.
Read about 7 hacks to get you up and running on Toad Edge, the next-gen toolset for open source relational database environments.
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
Three tutorials to help you get even more value from your Quest tools.
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.
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
Toad for Oracle Forum: The best of the best posts. Helpful, entertaining, innovative, bug reports and FAQs.
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.
Visit Quest at Oracle OpenWorld 2019, Booth 1911, for networking opportunities, cool prizes, and tips on monitoring and managing data.
Quest Software takes top spots in every single category for the 2019 DBTA Readers’ Choice Awards, winning first in four categories.
Code Tester vs. utPLSQL: Which tool is best for your experience level? Storing, importing and exporting code. Report and production format. [Comparison.]
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.
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.
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.
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.
This blog will tell you how you can take a picture or snapshot of your Oracle database using Toad for Oracle.
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.
Series 1 of 5: Toad for Oracle vs. SQL Oracle. 5 key reasons why a commercial grade software application outperforms a quasi-free tool.
Learn how to create a workspace in Toad for Oracle, so you can quickly resume work after restarting Toad.
Learn how to integrate source control into Toad for Oracle with this short video.
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.
Learn the many ways the Toad for Oracle 'Jump to… ' feature can help you.
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 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.
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 2: How can you simplify and automate SQL optimization for developers in Toad for Oracle?—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)
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.
How to proactively scan for SQL that may not be running using the “Scan SQL” feature within Toad SQL Optimizer. [Tutorial]
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.
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
“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.
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.
Sensitive data protection tutorial (Part 1 of 2): defining rules and default policy actions within Toad for Oracle.
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.
5 top questions answered.
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.
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.
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
Watch and learn about database mapping and understanding data using this Toad solution.
Learn how to contact support and prepare support requests when having problems with Toad for SAP.
Learn how to automate repetitive tasks in Toad for SAP in this two-minute overview.
Watch how to organize your content in Toad for SAP Solutions from Quest.
See how to update your production environment in Toad for SAP Solutions in our quick video.
Watch our quick video to learn how to keep test data updated 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
Learn how to use this powerful feature that allows you to easily compare and synchronize properties between SQL Servers.
Toad Intelligence Central
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.
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.
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.
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.
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.