If you’ve never attended a SQL Server performance tuning session with Brent Ozar or Pinal Dave, you’re in for a treat when the two of them team up during Quest EMPOWER, a virtual conference occurring November 10-11, 2021.
Brent Ozar is a Microsoft Certified Master and independent consultant specializing in solving the thorniest SQL Server performance issues. With more than 20 years’ experience in database administration and tuning, there isn’t much about SQL Server that Brent doesn’t know – particularly when it comes to indexes, queries, blocking and settings.
Pinal Dave is a SQL Server performance tuning expert and consultant at SQLAuthority.com. With over 17 years of experience, he also helps clients with the myriad issues that slow down their SQL Server environments. Pinal knows nearly everything there is to know about execution plans, wait statistics and server configurations.
During Quest EMPOWER, Brent and Pinal will present a session of rapid-fire SQL Server performance tips and tricks. You can expect them to address a range of topics, and answer questions like:
- How do you predict what the cost of the cloud is going to be?
- How important is index management? Would you err on the side of too many or too few indexes?
- When and where should we use column store indexes?
- Is Oracle ever a better option than SQL Server?
- When is the right time to shrink a SQL Server database?
- What are the top three performance counters or metrics that you look at to understand SQL performance?
- What is your one top tip or lesson learned that you would tell a DBA looking to ensure database performance?
- What would you recommend to a newbie getting started with SQL Server?
- What are DBAs doing that slow their systems down?
Every session with Brent and Pinal is inevitably filled with useful tidbits, SQL code snippets and sage advice – it’s also generally a lot of fun. Don’t miss this opportunity to get SQL Server performance tips from two of the leading experts in the business.
Their session is on Day 1 of Quest EMPOWER, November 10 from 2:00 – 2:45 pm ET. Visit the event site and register to attend.
