A dose of knowledge from Pinal Dave in the Monthly Mentor series
With the pressures they face every day, database administrators and developers sometimes need a friendly voice of encouragement – someone who understands their struggles and can speak their language. That voice, in a beautifully-lilted accent, comes from Pinal Dave from SQL Authority. Pinal brings both knowledge and empathy to his interactive sessions, and we’re pleased to have three chats with Pinal as part of our Monthly Mentor webcast series.
These webcasts are now available on-demand and are sure to increase your understanding of database DevOps, SQL Server performance monitoring and SQL performance tuning.
Solving database challenges around DevOps and open source
In this conversational session, Pinal engaged with the audience and answered questions about DevOps – from basic to more advanced. He described DevOps as a philosophy that organizations can adopt and make their own when it comes to building, testing and releasing code, and continuously monitoring performance. Audience members peppered him with questions, such as:
- Does DevOps apply to SQL Server?
- What are the tools that can be used for DevOps?
- How is DevOps different than Agile?
- Do I really need to learn about DevOps?
In his rapid-fire and humorous responses, Pinal laid it all out when it comes to DevOps and the role it plays in organizations.
Secrets to keep your database running at optimal speed
In this “heart-to-heart” talk, Pinal was joined by Peter O’Connell of Quest as they fielded questions about the challenges associated with tuning SQL Server database performance.
Attendees asked what was on their minds and commented on what they dealt with daily, such as:
- Where do you start when SQL Server is running slow?
- What are the major components of performance diagnostics?
- How have smart phones changed the way we respond to alerts and notifications? (There was a great exchange about pagers – anyone remember those?)
- How can we overcome the complexity of root cause analysis?
- How can proactive performance management be done via health checks, and how frequently should it occur?
Pinal and Peter provided insight and expertise, along with some fond reminiscences about pagers!
SQL Server performance tuning and troubleshooting
In this session, Pinal gave a detailed demo on troubleshooting and tuning, particularly when upgrading SQL Server to a new version and experiencing slow performance. He talked about the ins and outs of three settings that should be adjusted when an upgrade occurs, but are commonly overlooked:
- Auto-create statistics
- Compatibility level
- Cardinality estimation
Using a simple query, Pinal showed how variations in these settings can dramatically affect database performance, and in most cases, can be fixed in under 60 seconds.
Kick Start! SQL Server 2019 Performance Tips and Tricks
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.
Watch the Monthly Mentor Webcast Series on-demand
Try Foglight for Cross-Platform Databases
Start the discussion at forums.toadworld.com