Quest Database Training Days: On-Demand

A query that was once efficient can slow down significantly as the workload and data in the underlying table change. With numerous parameters impacting query performance, it’s crucial to monitor and adjust configurations to ensure optimal performance as data and workloads evolve. In this session, we will explore various server and database configurations that influence performance in a changing DevOps environment. Developers and DBAs will gain valuable knowledge and scripts to immediately improve the performance of their slow-running queries.

Topics that will be discussed include:

• Monitoring and adjusting query parameters for optimal performance
• Understanding the impact of data and workload changes on query efficiency
• Server and database configurations critical to performance in DevOps
• Practical scripts and strategies to enhance query performance

Speaker:

• Pinal Dave, SQL Server Performance Tuning Expert at SQLAuthority.com

Speaker: Brent Ozar

You've moved to the cloud, and now management is asking questions about your monthly bills. They've asked you to cut costs. Now what? In this webcast, Brent Ozar will examine the top expense-causing configurations and workloads for Azure SQL DB and Microsoft SQL Server. You'll learn how to tell when you've got too much hardware, and where you can safely cut costs without sacrificing end user performance experiences.

Speaker: Janis Griffin

Are you under pressure from your business to build, test and release software changes faster? Is it unclear how to bring database processes into your DevOps infrastructure? Are you concerned about the risks of making compromises while shortening your release cycles? Are you wondering how to effectively monitor the performance impacts of your database changes?  Are you required to replicate fast-moving changes to your hybrid database environments? If the answer is yes to any of these questions, then this presentation is for you. Future proof your databases and achieve continuous database operations.

Speaker: Neil Buchwalter

Most organizations understand the critical nature of their data assets and the role they play in support of their business.

A solid data foundation is necessary to ensure business decisions are based on valid and verifiable events and that the decisions made will have a positive impact on the organization. Hence, the need for a data warehouse.

Unfortunately, data warehouses are limited by their inability to quickly evolve over time due to their somewhat rigid structure. That's where Data Vault 2.0 modeling comes in. The Data Vault process facilitates the creation of a flexible normalized data architecture that can easily evolve as required to maintain a valid and auditable representation of an organization's data assets over time. Additionally, the nature of the Data Vault objects consistent structures encourage the development and use of automation solutions to generate more of the data warehouse and using fewer resources in the process.

Every query has a cost, typically measured through three critical resources: CPU, IO, and memory. When queries are not optimized for the cloud, they often lead to the need for expensive upgrades to cloud subscription models or result in extremely slow query performance. In this session, we will focus on how to tune queries for optimal efficiency when deployed to the cloud, ensuring they run smoothly with limited resources. Developers and DBAs will receive actionable knowledge and scripts to immediately enhance the performance of their slow-running queries.

Topics that will be discussed include:

• Understanding the cost of queries in terms of CPU, IO, and memory
• Strategies for optimizing queries for cloud environments
• Techniques to avoid unnecessary cloud subscription upgrades
• Practical scripts and tips for immediate performance improvements

Speaker:

• Pinal Dave, SQL Server Performance Tuning Expert at SQLAuthority.com

All four experts answered questions submitted by this seasons attendees.

Take advantage of this rare opportunity to get these renowned database gurus live on the same (virtual) stage answering  top database performance questions.