Get more from Toad in our "Ask Toad" webcast series - 2020

Anyone in your organization writing PL/SQL code is creating code that other team members may eventually need to read, interpret, alter, and maintain. That’s why using a robust code review tool is crucial to ensure coding standards are consistently met.

With Toad® for Oracle by Quest®, you can define and enforce coding standards using a selection of 200 pre-built rules or create new ones tailored to your needs. This ensures that development teams can correct code as they type, improving overall quality and making future maintenance easier while reducing the likelihood of defects.

In this session, you’ll learn about:

• The importance of running code reviews on PL/SQL objects
• Running code reviews using out-of-the-box rules in Toad for Oracle
• Creating custom rules for your code reviews
• Automating code reviews to streamline the process

Speaker:

• Albert Rodriguez
  Software Sales Engineer, Database Management Solutions, Quest Software

Are you struggling to tune your SQL statements and PL/SQL code? Are you reliant on your DBAs to assist you and can't get their time? According to Forrester Research, 60 percent of database performance issues can be attributed to poor SQL statement execution. You don’t want your queries to bog down the database, but you may not know where to start your tuning efforts.

Fortunately, you can automate the SQL optimization process and maximize the performance of your SQL statements with the SQL Optimizer functionality in Toad® for Oracle Xpert edition.

SQL Optimizer analyzes, evaluates and rewrites SQL statements located within database objects, files, or collections from Oracle's System Global Area (SGA). Once SQL Optimizer identifies problematic SQL statements, it optimizes the SQL and provides replacement code that includes the rewritten statement.

In this session of Ask Toad, Gary Jerep, software solutions consultant, will demonstrate how the SQL Optimizer in Toad for Oracle Xpert edition works to improve your code. You will learn:

• Why you should use SQL Optimizer
• Optimization steps and results
• How to scan existing code for performance problems
• Capturing running SQL and identifying issues

Join us to learn how the SQL Optimizer will ensure poorly-written queries don’t affect the performance of your Oracle databases.

Poorly-written SQL queries and PLSQL code can bring an Oracle database to its electronic knees – and it’s not a pretty sight. Database professionals spend a lot of time mitigating the effects of bad code on performance, and Toad® is one of the most powerful tools available to get this done. 

Depending on whether you have the Professional or Xpert edition of Toad, there are different features available that you can leverage in your ongoing efforts to address poor code. 

In this session of Ask Toad, Mathew Phan, Software Sales Engineer, will showcase these two editions of Toad for Oracle and how features like static code reviews, sensitive data awareness and SQL optimization address the issues and data governance risks that arise from bad coding practices. 

In Toad Professional, you’ll learn about:

• Code Analysis
• Generate Test Data
• Sensitive Data Awareness

In Toad Xpert, Mathew will cover:

• SQL Optimization
• Auto Optimizer
• Advanced Optimizer
  

Join us to learn how these features will keep your Oracle databases standing 24x7.

Do you find yourself taking the same actions every day in Toad® for Oracle? Did you know that you can create hotkeys to perform those actions and streamline your tasks? You can also create filters to remove items you don’t use frequently or don’t need to see. Additionally, there are other configurations you might not know about that can significantly affect how Toad looks and behaves.

In this on-demand session, we’ll explore these settings and share a few more tips to help you get the most out of Toad for Oracle.

Topics that will be discussed include:

• Creating hotkeys for repetitive tasks to save time
• Setting up filters to remove unnecessary items from your view
• Configuring Toad for Oracle to suit your workflow
• Additional tips and tricks to enhance your productivity

Speaker:

• Mark Kurtz
  Software Sales Engineer I, Quest Software

Toad® for Oracle Base Edition is an exceptional tool for Oracle administration, allowing you to manage all your on-premises and cloud databases, control database access, browse and navigate database objects, and run SQL and PL/SQL. Additionally, Toad offers numerous ways to enhance your organization, productivity, and collaboration.

In this session, you’ll gain insight into five of the most useful DBA features in Toad for Oracle Base Edition, including how to:

Topics that will be discussed include:

• Automate various Toad and non-Toad functions
• Manage all your scripts from a central location
• Browse, view, and edit data across tables regardless of referential integrity (RI)
• Manage and view all your sessions in a single view
• Generate database documentation easily for all database objects across multiple databases

Speaker:

• Russell Tuttle
  Quest Software

Oracle database developers are facing pressures to code faster while still producing high-quality PL/SQL that doesn’t break anything or slow down the database.

Additionally, developing on Oracle databases poses challenges like finding object references and dependencies in your code, validating code flow and minimizing connections without sacrificing performance. If not addressed properly, any one of these challenges can cost your company time and money.

In this 30-minute on demand Ask Toad session, Gary Jerep, Software Solutions Consultant, will demonstrate five use cases, and how Toad for Oracle Base Edition helps developers:

• Quickly find all object references and dependencies in their code
• Guarantee that code is following the correct flows of control
• Identify the most expensive lines in their code
• See how program connections affect database performance
• Automate tasks for greater efficiency and accuracy