Quest® Database Virtual Summit

This year is seeing unprecedented changes in IT that are accelerating the pace of what was already happening around data operations, cloud adoption, application delivery and data privacy.

The use of new technologies built around AI and ML such as autonomous databases and the growth of hybrid databases, at a time when data privacy is under the spotlight, have the potential to significantly impact the traditional role of the DBA. 

This session will explore some of these new technology trends and what to expect from an increasingly dynamic market.

With on-premises systems, the scope of the DBA’s duties was generally consistent. Today, however, the role of the DBA is continuously evolving. Why?

Increasingly, movement to hybrid cloud and “Ops.” 

We’ll explore the effects of hybrid cloud on the DBA. We’ll also look at opportunities where DBAs can make a difference.

What if you could make cloud migration and management simple and predictable? With Foglight Evolve Cloud, you can migrate workloads to the cloud with confidence, knowing how much it will cost, expected savings and the anticipated performance impact.

After migration, you can use Foglight to easily manage all your workloads in the cloud.

See how to achieve a cloud-first or cloud-only mandate.

Databases and applications are not islands in a calm sea. They run as part of a bigger infrastructure, perhaps as a VM on-premises or in the cloud.

Poor conditions impact the availability and performance of databases and applications.

See how to visualize, analyze and optimize the bigger environment to reduce complexity, improve performance and troubleshoot issues.

Most large and medium companies have at least some data stored in an Oracle database. Many use the data analytics tools in Microsoft Azure.

The challenge is how to make that Oracle data available to data scientists using the Azure platform.

Learn how to use Quest® Toad® Data Point and SharePlex® by Quest® to create and update a replica of your data in Azure SQL, which is the “gateway” to Microsoft Analytics.

This session will provide a brief introduction to DevOps concepts. Then, we’ll focus on how DevOps impacts DBAs.

You’ll see how DBAs can better understand changes occurring to their database servers, as well as how DBAs can provide performance-focused dashboards to developers to enhance collaboration between teams. 

Azure DevOps is the go-to platform for Microsoft shops looking for a single-vendor solution for developing, testing, deploying and hosting their applications.

But classic database management tools like SSMS don't provide enough integration into DevOps workflows. We'll review cost-efficient solutions to bridge the gap and apply common database tasks to an Azure DevOps pipeline.

In this talk we will talk about the backbone of core engineering principal of DevOps. We will discuss why companies embark on transformation and benefit from cultural changes for DevOps.

We will discuss how we work with DevOps, How we architect DevOps and shed light our engineering system at Microsoft.

Protecting sensitive and personally identifiable (PII) data is challenging in a DevOps CI/CD pipeline. Quest database management, security and compliance solutions for SQL Server increase the velocity of SQL Server database changes and ensure compliance throughout the development lifecycle.

See how easy it is to provision and mask data in a DevOps CI/CD pipeline and ensure you can audit data changes across the environment.

2019 saw 1,506 reported data breaches and 165 million sensitive records exposed (Clement, 2020).

Actual numbers are likely higher than those reported.

As regulatory requirements and potential fines around sensitive data increase, there’s focus and investment in securing sensitive data. We’ll explore DevSecOps concepts and processes and how Quest solutions help.

Your on-call duties shouldn't consume your entire day, but balancing everyday responsibilities with solving new and recurring issues can be challenging. How can you efficiently manage these tasks while still keeping projects and timelines on track? In this session, you'll explore key features of Quest® Toad for Oracle®, such as DB Health Check, Capture and Replay, and History Browser. Discover how these tools can simplify and streamline your on-call duties, allowing you to focus on what truly matters.

Topics that will be discussed include:

• Simplifying on-call duties with DB Health Check
• Managing issues efficiently using Capture and Replay
• Keeping track of changes and troubleshooting with History Browser

Speaker

Albert Rodriguez

What is it about performance tuning that makes it so difficult?

Solutions Consultant Gary Jerep will provide insight into why query and index optimization is so challenging. He’ll also demonstrate the Quest Software approach to tuning, so you can see how to simplify your work.

When it comes to SQL Server database performance, query tuning is critical. However, identifying the root cause of performance issues can be challenging, leading to frustration and time-consuming efforts. If you’re struggling with query tuning, this webcast is tailored for you.

In this session, Oracle ACE Director Janis Griffin will demonstrate how Foglight® for Databases by Quest® simplifies the process of finding and fixing problematic queries. You’ll learn to harness the powerful functionalities of tools like the multi-dimensional Performance Investigator and Quest SQL Optimizer to quickly rewrite queries or identify the best indexes. This systematic approach, regardless of your database's complexity or your skill level, will guide you to the correct tuning path, eliminating guesswork and saving countless hours on query tuning and SQL Server performance optimization.

Topics that will be discussed include:

• Using wait types to quickly identify bottlenecks and determine the best tuning approach
• Identifying inefficient operations through query execution plan reviews
• Rewriting queries to achieve optimal execution plans

Speaker

Janis Griffin
Oracle ACE Director, Quest Software

One day, you “accidentally” became a SQL Server DBA. Now, you’ve “accidentally” become a multi-platform DBA. It can be overwhelming. 

If you’ve been thrust into the open-source or NoSQL arena, maintaining availability and performance, you’re not alone.

We’ll explore how Foglight can help and dive into open-source and NoSQL technologies. You’ll see how Foglight simplifies performance scenarios in MySQL, PostgreSQL, MongoDB and Cassandra. You’ll learn how to efficiently monitor cross-platform database health.