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.
Written by Quest Software