Welcome to Coffee with Toad® 2020, the Toad World® blog monthly recap. Published the first Tuesday of every month, Coffee with Toad 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.
Read other Coffee with Toad flavors:
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.
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.
December 2020
Toad Data Point
Free database training for analysts [Toad Data Point]
Be data driven. Cross-platform Toad Data Point streamlines data access, prep and provisioning. It enables blending of multiple sources into a single data pool.
Toad for Oracle
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 use Toad® for Oracle with Oracle Autonomous Database – I
Using the Autonomous Transaction Processing service with Toad for Oracle, a five-step tutorial. Work fast, with better quality output.
How to use Toad for Oracle with Oracle Autonomous Database – 2
Learn about six Toad for Oracle features you can use to create a table in Oracle Autonomous Database.
November 2020
Toad for Oracle
4 ways Toad for Oracle Base is stronger than Oracle SQL Developer
Toad for Oracle Base for the database professional. Handle heavier lifting of dbdev and dbadmin than SQL Developer.
How to compare two schemas in Oracle using Toad®
Are you an Oracle Developer? Learn to effortlessly compare two Oracle database schemas to rebuild or replicate environments using Toad for Oracle.
Why an Oracle Ace thinks Toad® has the best SQL editor in the business
Learn about five plus features that have Oracle Ace, Dan Hotka, convinced that Toad is the best SQL editor around in this blog and video demo.
October 2020
GDPR
Sensitive Data Protection Best Practices [Webinar]
Spending too much time looking for sensitive data to meet GDPR compliance? Attend this Ask Toad® webcast and learn how to automatically find sensitive data.
Toad Data Point
Data Preparation Made Easy webcast series [Quest® Toad® Data Point]
Discover ways to navigate data preparation like a wizard. Our webcast series is designed to help you maximize your investment in Toad Data Point.
Toad for Oracle
How a Code Review Tool Can Help You Write Team-friendly PL/SQL [Webcast]
Need a good code review tool? Attend this Ask Toad webcast and learn about a fast and easy way to ensure code quality.
How to install and activate Toad for Oracle Base Subscription
Learn how to install and activate your copy of Toad for Oracle subscription.
What happened to Toad® for Oracle Freeware? It’s a matter of focus.
Perfect for Toad for Oracle Freeware and single users, Quest® is offering a new way to buy Toad for Oracle Base edition: by yearly subscription.
How Toad® for Oracle Base Edition is better than Toad for Oracle Freeware
Toad for Oracle Freeware vs. commercial. Leapfrog from Toad for Oracle Freeware and subscribe to Base: 7 ways to boost productivity. Special intro offer.
A Toad® subscription delivers full features, support, and auto update
Full-featured, Toad for Oracle Base subscription, perfect for freeware and single users at a low price. Get complete access to tech support and auto updates.
September 2020
Toad Data Point
Data Preparation Made Easy webcast series [Quest® Toad® Data Point]
Discover ways to navigate data preparation like a wizard. Our webcast series is designed to help you maximize your investment in Toad Data Point.
Toad for Oracle
How a Code Review Tool Can Help You Write Team-friendly PL/SQL [Webcast]
Need a good code review tool? Attend this Ask Toad webcast and learn about a fast and easy way to ensure code quality.
EMEA Quest Database Days 2020 Virtual Conference
Attend this virtual event to get a full day of learning with many tracks on topics related to database performance, data operations, virtualization and more.
Copying database data to Microsoft Excel via Toad for Oracle
Export Oracle table data to Excel using Toad for Oracle, simple how-to for any user experience level.
Webcast: Boost Database Performance with SQL Optimizer
Need help with writing optimized queries for your Oracle databases? Attend this Ask Toad webcast and learn how Toad SQL Optimizer analyzes and rewrites queries.
How to download Toad for Oracle
Need a Toad download? Download Toad for Oracle, one of the most used, integrated development environments for connecting to and using with Oracle Database.
August 2020
Toad Data Point
Data Preparation Made Easy webcast series [Quest® Toad® Data Point]
Discover ways to navigate data preparation like a wizard. Our webcast series is designed to help you maximize your investment in Toad Data Point.
Toad DevOps toolkit
What are database management tools and what features are must-have?
Without the right database management tools, you’re missing out on automation and collaboration. See how to write better SQL, share it more and test it faster.
Toad for Oracle
Webcast: Boost Database Performance with SQL Optimizer
Need help with writing optimized queries for your Oracle databases? Attend this Ask Toad webcast and learn how Toad SQL Optimizer analyzes and rewrites queries.
SQL tools – 8 ways you can’t live (or work) without them
There are many ways to export data from Oracle. Be it application, meta or both, Toad for Oracle has you covered.
July 2020
Toad Data Point
Feeding your database: Techniques for building automated Excel imports
Learn how to automate batch Excel imports into relational database systems like Oracle and SQL Server.
Data Preparation Made Easy webcast series [Quest® Toad® Data Point]
Discover ways to navigate data preparation like a wizard. Our webcast series is designed to help you maximize your investment in Toad Data Point.
Data preparation free trial now 90 days: Quest® extends Toad® Data Point trial
Data preparation free trial. In the wake of COVID-19 businesses need to query and prepare data to act quickly, try this cost-effective and easy to use tool.
Database Management Tools
What an ER diagram is and tools that help build and alter them
For database design, application development, and access to data from database objects, an ER diagram (Entity Relationship Diagram) is an essential resource.
Toad for Oracle
Ask Toad® brings you five cool DBA features in Toad for Oracle Base Edition [Webcast]
Toad for Oracle Base Edition is an amazing tool for Oracle administration that lets you manage all your on-premises and cloud databases.
So you want to export data from Oracle? Let's count the ways.
There are many ways to export data from Oracle. Be it application, meta or both, Toad for Oracle has you covered.
Webcast: Banish Bad Code with Toad® for Oracle Pro and Xpert Editions
Learn how features like static code reviews and SQL optimization address the issues and risks that arise from bad coding practices.
The performance teeter-totter part 3: Toad® Turnpike [Finding indexes]
Optimizing SQL? Index tuning is hard. Really, really hard. Part three in a blog series about SQL optimization, index tuning and yes … even quiz answers.
How to improve database performance with Oracle query optimization — Basic concepts
Learn how Oracle query optimization can help you reduce page reads, remove performance bottlenecks and keep your applications and web pages responsive.
June 2020
ApexSQL
Does your SQL code satisfy SQL formatting standards?
How many times have you created a database object without the option to check if the SQL code satisfied the SQL writing standards? ApexSQL Enforce can help.
Toad Data Point
Conquering your data preparation challenges [Webcast]
In this webcast demo, product manager Julie Hyman will provide some insight into overcoming common data preparation challenges.
Data preparation free trial: Quest® extends Toad® Data Point trial to 90 days
Data preparation free trial. In the wake of COVID-19 businesses need to query and prepare data to act quickly, try this cost-effective and easy to use tool.
Data Preparation Made Easy webcast series [Quest Toad Data Point]
Discover ways to navigate data preparation like a wizard. Our webcast series is designed to help you maximize your investment in Toad Data Point.
Toad for IBM DB2
Db2 performance tuning: process model + real-time diagnostics = 1-2 punch
Part 2. Db2 performance tuning? Consider the IBM DB2 Process Model and Quest Spotlight. Clearly define a path of action and at the same time watch the results.
Toad for DevOps
Quest® Database Training Days: The biggest names in tech [Free Webinars]
Free webinar series to learn about SQL query optimization, SQL performance tuning, cloud migration, DevOps, open source database adoption and more.
Toad for Oracle
Ask Toad® brings you five cool DBA features in Toad for Oracle Base Edition [Webcast]
Toad for Oracle Base Edition is an amazing tool for Oracle administration that lets you manage all your on-premises and cloud databases.
How to install an Oracle Instant Client for Toad® for Oracle
How to install an Oracle instant client for use with Toad for Oracle: a step-by-step guide with screenshots.
Top Five Use Cases for Developers for Toad® for Oracle Base Edition
Session 3 in our 2020 Ask Toad database tools free tutorials. Join top Toad for Oracle experts in 30-minute lessons, with Q&A. Save time, get more from Toad.
The performance teeter-totter part 2: Toad® Turnpike [Finding indexes]
Which SQL statements should you consider to index-tune? Do you know WHAT or WHERE they are? And why is finding effective indexes so difficult?
Database Browser Utility: How to keep track of database activity
Database browser utility tutorial, part 2. Learn about the four tabs in the Toad Database Browser Utility: Instance, Database, Options and Parameter.
Toad for SQL Server
SQL Server audit and GDPR compliance: Configure, alert and report [How to]
Not sure how to ensure your SQL Server environment adheres to GDPR? Set up a SQL Server audit and comply with 5 articles, complete with alert and reporting.
May 2020
Toad Data Point
Conquering your data preparation challenges [Webcast]
In this webcast, product manager Julie Hyman will provide some insight into overcoming common data preparation challenges. Toad for Oracle.
Dive right in with Toad Data Point 101 – the basics
Discover ways to navigate data preparation like a wizard. Our webcast series is designed to help you maximize your investment in Toad Data Point.
Data Preparation Made Easy webcast series [Quest Toad Data Point]
Discover ways to navigate data preparation like a wizard. Our webcast series is designed to help you maximize your investment in Toad Data Point.
Toad for DB2
Performance tuning IBM Db2 to quickly solve slowdown causes
Db2 performance tuning? Consider the IBM DB2 Process Model in combination with Spotlight to identify causes of slowdowns.
Toad for Oracle
How to monitor database activity with the Toad® Database Browser Utility
Part 1, in a blog series that covers monitoring and reporting on memory usage, database parameters and options, user session information and rollback activity.
Managing database user accounts with Toad® for Oracle [How to]
Read this blog to learn how to create a new user, alter an existing user, close a user and drop an existing user in Toad for Oracle.
Toad for Oracle Release History
Toad for Oracle Release History showing different product versions and the enhancements in each.
Ask Toad brings you five cool DBA features in Toad for Oracle Base Edition [Webcast]
Toad for Oracle Base Edition is an amazing tool for Oracle administration that lets you manage all your on-premises and cloud databases.
Toad for SQL Server
Is managing your SQL Server environment too expensive? [Redgate alternative]
Spending too much on your Redgate SQL server environment? Want to reduce spend? Read how one customer saved and compare: ApexSQL Solution vs. Redgate.
April 2020
ApexSQL
SQL create database automation with ApexSQL Build
Want to create a SQL database from any input and automate builds from source control? Learn about ApexSQL Build.
Benchmark Factory
Integrate database load testing in your build pipelines
Video tutorial of scripting Benchmark Factory database load, scale, and performance testing using PowerShell, REST API, and Jenkins.
Database Management Solutions
2020 DBTA Reader's Choice Awards
Voting open for 2020 DBTA Readers’ Choice Awards. Vote for Quest Foglight, Spotlight, SharePlex and Toad best database management tools until May 8.
Monitor DB Performance in Cloud and on Premises While WFH
Database monitoring is how to assure your WFH users of good database performance. Monitor with Foglight for migrations, SQL optimization and reporting.
Two ways database performance affects #WorkingFromHome [IT and COVID-19]
Feeling the pressure about database performance when your co-workers are WFH? Run benchmarks now and auto-optimize your SQL statements.
Toad Data Point
Data Preparation Made Easy webcast series [Quest Toad Data Point]
Discover ways to navigate data preparation like a wizard. Our webcast series is designed to help you maximize your investment in Toad Data Point.
Toad for Oracle
3 reasons to upgrade your Toad® database development solution
Your current Toad for Oracle database development solution has some fantastic features, and it's working well. So should you upgrade to the latest version?
The performance teeter-totter—Toad Turnpike: Real stories from the road
Which SQL statements should you consider to index-tune? Don’t know WHAT or WHERE they are? How can you come up with the best potential for improvement?
Short-cuts for repeatable actions: Ask Toad [Free Webinar]
Session 1 in our free 2020 Ask Toad database tools tutorials. Join top Toad for Oracle experts in 30-minute lessons, with Q&A. Save time, get more from Toad.
What is a beta program? Be an influencer. Sign up now.
Toad is an extensive family of industry-leading products empowering you to manage and optimize databases. Join our beta team and help guide our future.
Database development and management while working from home [IT and Covid-19]
Keep your working-from-home database developers productive. Info on your Toad for Oracle license rights and steps for connecting to remote databases.
March 2020
ApexSQL
Want to optimize your workflow and maximize usability?
Need to graphically represent dependencies between objects in your database? Learn how ApexSQL Analyze can optimize the developer’s workflow and maximize usability.
Benchmark Factory
Automate database load testing with Benchmark Factory®
Automate database load testing using Benchmark Factory's REST API using PowerShell. Plus load testing, performance testing, scale testing, regression testing.
Toad Data Point
What's new in Toad Data Point Workbook 5.1.3?
The most noticeable enhancements in this release is the newly redesigned Workbook, drag and drop workflow steps, pivot grids and dimensional views.
Toad for IBM DB2
Top 10 most popular Toad® for IBM DB2 blogs
The 10, all-time most popular Toad for IBM DB2 blog posts on Toad World today. Year after year, month after month and even daily—these posts get the most visits.
Toad for Oracle
Free training: Toad for Oracle Fundamentals
Access this free training course. Automation Designer, Script Manager, Schema Browser, Object Compare, and Query Builder are just a few of the features you'll learn about.
How will you know if the cloud is really saving you money?
Gain not only a clearer picture of how to migrate your Oracle databases to the cloud but also insight into balancing cost and performance.
3 free training courses for Toad® for Oracle developers
Self-paced classes—specifically for database developers—on using key features like: PL/SQL Profiler, SQL Optimizer, PL/SQL Debugger, and Code Tester.
Off-roading, maps, gray hairs—Toad Turnpike: Real stories from the road
Learn how this customer could have saved two man-days of troubleshooting with this one feature of Toad for Oracle.
Three free Toad® for Oracle DBA training classes
Access these free DBA training courses, presented in three, self-paced classes—specifically for database administrators.
Webcasts on DevOps, SQL Server monitoring & tuning
Pinal Dave discusses DevOps, SQL Server performance monitoring & tuning in Monthly Mentor on-demand webcasts from Quest.
Help for database pros working from home
DBAs and developers are measured against speed and quality of work. Learn about tools to stay effective no matter where “work” is located.
Toad for SQL Server
5 SQL Server DB dev tasks DBAs can bet on, cloud or not
Cloud or not, experienced or not—read about 5 SQL Server database development tasks that take away the bane of a DBA’s existence: uncertainty.
February 2020
ApexSQL
SQL data compare and sync: 10 blogs to get you started
Learn about a tool that can compare and synchronize SQL Server data between databases and backups—and compare data under script folders and source control projects.
Continuous Integration/ Continuous Deployment
Webcast: Integrate Your DB Change Management into DevOps
Register to attend this Quest Software and IOUG webcast on February 25. Learn how you can make database changes faster, safer and prevent deployment delays.
Thought Leadership
Quest® and 7 other industry leaders talk data privacy
Read this BetaNews article about the newly enacted California Consumer Privacy Act (CCPA) and how it could renew a focus on data privacy in the United States.
Toad Data Modeler
How to create macro for assign domain to attributes
Step-by-step illustrated directions on how to create a macro and how to assign attributes with data type for the Oracle models. [Tutorial]
Toad Edge
Amazon Redshift queries to run? 2 data-agnostic tools
Why you need tools to help develop queries and execute them against relational databases, multiple database and file types, MySQL, PostgreSQL and Amazon Redshift.
Toad for Oracle
Using McCabe's Cyclomatic Complexity to design unit tests in Toad for Oracle
Utilize McCabe's Cyclomatic Complexity to design utPLSQL unit tests in Toad for Oracle.
Toad® Turnpike: Real Stories from the Road—Tuning makes friends
Read how this Toad for Oracle customer achieved hero-status when she saved her company an $40,000 and reduced a query-run time from 13 hours to 16 minutes.
Move Oracle DBs to AWS? Questions to ask. [Webcast]
Watch this on-demand webinar and learn how to migrate your Oracle databases to AWS —while mitigating cost and risk so there’s minimal impact to your business.
Predict the future performance of your Oracle databases
Using Spotlight® on Oracle you can predict the future performance of individual SQL statements and use the predictions to lessen future performance issues.
Toad for SQL Server
Top 10 most popular Toad® for SQL Server blogs
The 10, all-time most popular Toad for SQL Server blog posts on Toad World today. Year after year, month after month and even daily—these posts get the most visits.
Toad Intelligence Central
6 new features in Toad Intelligence Central 5.1 [How to]
Learn how 6 new features work in Toad Intelligence Central 5.1. Auto backup, transfer group owner, create user group are just 3 of the 6. Read this how-to.
January 2020
ApexSQL
10 blogs to help you ramp up on ApexSQL Diff
ApexSQL tools are built for the Microsoft SQL Server—with you in mind. Need to compare database schemas, review and synch changes? Read how.
Database Management Tools (more than 1 tool mentioned)
What is automated SQL tuning? Time saving DBA tips.
SQL tuning alternative statements generated in hours not days. Alternative rewrites, compared with the original, easily executed side-by-side to prove which is fastest.
Quest® and 23 other thought leaders predict 2020 trends
Software Development Times (SD Times) gathered opinions from 24 thought leaders about where they see the software development industry heading in 2020.
Coffee with Toad [Toad World Annual recap, 96 blogs]
In 2019 Toad World published nearly 100 blogs. You’ll find blogs on our products, thought leadership, cutting edge technology and even a few on Oracle.
Toad Data Modeler
How to save your Data Models into your GIT repository
Need to rollback a change to a database model? Use Toad Data Modeler, plus reverse engineering and learn how to easily pull a model from your GIT repository.
Toad Data Point
Why Toad® Data Point is the perfect replacement for Brio
Still using Brio (Hyperion IR)—which is no longer supported? Created with Brio user input, Toad Data Point is even better.
Toad Edge
Top 10 most popular Toad Edge® blogs
The 10, all-time most popular Toad Edge blog posts on Toad World today. Year after year, month after month and even daily—these posts get the most visits.
Toad for Oracle
Raiders of the “Lost” Toad: Undiscovered Gems- Cameras and Watches
Cameras and Watches are featured in the 2nd blog of this series that helps Quest Software Toad users find those “hidden” gems that will increase productivity.
Quickly Deploy High-Quality Code with utPLSQL [Webcast]
Watch this webcast to learn how to improve code quality entering your CI/CD pipeline with powerful utPLSQL testing, available in every edition of Toad for Oracle.
Toad® for Oracle: Historical and future space usage
Learn how to manage your space usage and predict future needs in your Oracle Databases using Toad for Oracle.
Toad for Oracle – Sensitive Data Protection
CCPA takes effect in 2020: Is your data protected?
Toad for Oracle now lets you identify and safeguard personally identifiable information and sensitive data across your entire database environment.