In our new reality of social distancing and remote work, it’s nice to hear a friendly voice that isn’t your spouse, kids or dog! It’s even better when that friendly voice is imparting words of wisdom that make your job easier. So, that’s what Quest has lined up for you over the next few weeks in our Database Training Days webcast and conversation series with SQL Server and Oracle experts.
We’ve got a full lineup, too, with well-regarded experts like Pinal Dave, Brent Ozar and Janis Griffin. They’ll be sharing best practices and answering your questions on SQL Server and Oracle performance monitoring, providing SQL training and sharing an overview of new features in SQL Server 2019.
Best part of all? No shoes required! You heard it here. We will not know if you choose to watch these programs sans shoes (or even trousers).
What can you expect? All sessions will run one hour or less. Here’s the full lineup.
Session 1 - Kick Start! SQL Server 2019 Performance Tips and Tricks
Featuring Pinal Dave
Wednesday, April 8 | 12:00 pm ET
Every new release of SQL Server brings a load of new features that increase efficiency. SQL Server 2019 has introduced many new features and you’re about to see how to get the most from them. Pinal will provide invaluable guidance to help any DBA or developer who wants to get a jump start on SQL Server 2019.
Session 2 - Do You Feel the Need … the Need for Speed? Top Five SQL Server Query Tuning Tips
Featuring Janis Griffin
Wednesday, April 15 | 12:00 pm ET
Query tuning is key to peak performance in SQL Server databases. However, lots of developers and DBAs struggle to pinpoint the root cause of performance issues and spend too much time trying to fix them. In this session, Janis will share tried and true best practices for tuning queries in this SQL training. You’ll learn an approach that will lead to the correct SQL performance tuning with no guessing, saving countless hours and optimizing performance of your SQL Server databases.
Session 3 - How to Measure Your SQL Server
Featuring Brent Ozar
Tuesday, April 28 | 12:00 pm ET
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 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.
Session 4 - Why Defragmenting Your Indexes Isn't Helping
Featuring Brent Ozar
Tuesday, May 5 | 12:00 pm ET
For years, you've heard that reorganizing your indexes will 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 helps prevent fragmentation, and you're doing that too - but your indexes keep getting fragmented, and users aren't happy with SQL performance. In this session, Brent will explain how your daily index maintenance jobs might just be making the problem worse and what to do instead.
Session 5 - The New Robots in SQL Server 2017, 2019 and Azure
Featuring Brent Ozar
Tuesday, May 12 | 12:00 pm ET
The robots are coming to automate SQL performance tuning and make your life easier, right? Is this reality or marketing hype to get your management to upgrade or move to the cloud. In this session, Brent will cut through the hype, demonstrate 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 product robots for everyone’s benefit.
Session 6 - Oracle 19c Automatic Indexing Inside & Out!
Featuring Janis Griffin
Wednesday, May 20 | 12:00 pm ET
Oracle 19c offers 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 session, Janis will discuss the finer points of automatic indexing and how to control it at the schema level. She’ll also demonstrate automatic indexes in action.
Session 7 - Need for Speed? My Top Five Oracle Performance Tuning Tips
Featuring Janis Griffin
Thursday, May 28 | 12:00 pm ET
Continuing the focus on performance tuning, Janis will detail 5 steps to quickly identify Oracle performance issues and resolve them. She’ll demonstrate how to quickly fine tune a SQL statement, identify performance inhibitors to help avoid future issues, and understand how new Oracle features can change and/or support different execution plans.
Watch the sessions live, or binge-watch them at the end. Either way, be sure to hold your spot.
