Mar 25, 2020 3:15:00 AM by Quest Software
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.
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:
In his rapid-fire and humorous responses, Pinal laid it all out when it comes to DevOps and the role it plays in organizations.
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:
Pinal and Peter provided insight and expertise, along with some fond reminiscences about pagers!
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:
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.
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:
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.
Written by Quest Software