Quest Database Training Days

Every new release of SQL Server brings a load of new features you can add to your database management arsenal to increase efficiency. SQL Server 2019 has introduced many new features and Pinal Dave of SQL Authority will show you how to maximize them in this special session. 

Here’s a glimpse of the SQL Server features Pinal will cover:

• Adaptive query plans 
• Batch mode adaptive join
• New cardinality estimates for optimal performance 
• Adaptive query processing 
• Indexing improvements 
• Introduction to automatic tuning 
• Batch mode for rowstore storage 
• Accelerated database recovery 

This on demand session will provide invaluable guidance to help any DBA or developer who wants to get a jump start on SQL Server 2019 and its new features.

Query tuning is essential for achieving peak performance in SQL Server databases, yet many developers and DBAs struggle to identify the root causes of performance issues, often spending excessive time trying to resolve them. In this on-demand session, you'll discover proven best practices for tuning SQL statements and addressing other issues by leveraging Wait Time Analysis, reviewing execution plans, and applying SQL diagramming techniques. Additionally, real-world case studies will demonstrate the effectiveness of these practices.

Regardless of the complexity of your database or your skill level, this systematic approach will guide you to the correct SQL performance tuning path, eliminating guesswork and saving countless hours in query tuning and database optimization.

Topics that will be discussed include:

• Effectively using wait types to quickly identify bottlenecks and determine the best tuning approach
• Quickly identifying inefficient operations through query execution plan reviews
• Applying SQL diagramming techniques to find the optimal execution plan

Speaker

Janis Griffin
Senior Database Administrator, SQL Performance Expert

If you get into a car, how do you know if the car is fast or not? You hold down the gas pedal, and you time how long it takes before you're breakin' the law. 

Now what about SQL Server: how do you know if yours is fast...or a clunker? Database performance tuners need to know three metrics about their SQL Server: how fast it's going, how hard it's working, and how big it is. Brent Ozar will explain where to get those numbers, and what normal ranges are. You'll learn why advice is so different, depending on the kind of server you're driving.

For years, you've heard that you're supposed to reorganize your indexes to make SQL Server go faster. It sounds like it makes sense - keep things in order, right? But you keep doing it, and SQL Server isn't getting any faster. You've even heard that setting fill factor will help prevent fragmentation, and you're doing that too - but your indexes still keep getting fragmented every day, and users aren't happy with SQL performance. This advice made a lot of sense at the turn of the century, but today, things are different - and we're not just talking solid state drives. In just the first 15 minutes, you'll have a series of ah-ha moments when you realize that your daily index maintenance jobs might just be making the problem worse instead of better. Then, you'll learn what you need to do instead.

This on-demand session is for people responsible for the care and feeding of production SQL Servers. You don't have to have the word "DBA" in your job title - you just have to be the one responsible.

You've been hearing about all these robots that are coming to take your job. They're going to automate all the SQL performance tuning and make your life way easier, right? Or harder, I guess...since you'll be looking for a job. Thing is, most of that is just plain old marketing hype that Microsoft is using, trying to sell your management on upgrading to newer versions or moving to the cloud. In this on demand session, Brent Ozar will blow the marketing smoke away, show you these features in action, and show you which ones are ready for prime time. You'll walk away better equipped to have conversations with management about why you should (or shouldn't) upgrade, and how you can use these features not just to stay employed, but have a better career.

Oracle 19c brings us a very powerful new feature for index management called 'Automatic Indexes'. Automatic indexing requires very little effort from a DBA as it automates the creation, tests the validity and performance of indexes, removes obsolete or redundant ones, and continuously monitors their usage. 

In this on demand webcast, Janis Griffin will discuss all the components of automatic indexes and what they do.

You will further learn how to enable/disable automatic indexing, control it at the schema-level, and see several examples of automatic indexes in action. Finally, several system views and the activity report will be shown.   

Performance tuning can be complex, often leaving developers and DBAs uncertain about which adjustments will yield the most significant performance improvements. In this on-demand presentation, Janis Griffin, a seasoned System Consultant at Quest Software, will walk you through five essential steps to quickly identify and resolve performance issues.

Whether you're struggling with SQL statement optimization or trying to understand how new Oracle features impact execution plans, this session provides actionable insights to enhance your database performance.

Topics that will be discussed include:

• Fine-tuning SQL statements for immediate performance gains
• Identifying performance inhibitors to prevent future issues
• Understanding how new Oracle features can impact and support execution plans

Speaker

Janis Griffin
System Consultant, Quest Software

Hold on to your hats as two powerhouses of the SQL Server world come together on one virtual stage to answer your top database performance questions. Anything could happen! These two are:

• The Fred and George Weasley of the database wizarding world, always ready with a quip, explosion or skiving snackbox…

• The Kirk and Spock of the SQL Server universe, ready to boldly go where no one has gone before…

• The Batman and Robin of performance tuning, with an endless utility belt of database tools…

You get the picture.

Tune in for this one-of-a-kind opportunity to get advice and real-world insight from industry-leading experts, Brent Ozar, Microsoft Certified Master and Pinal Dave, SQL Server Performance Tuning Expert.