Today, I am going to talk about my the most anticipated pre-conference 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs scheduled at PASS Summit 2018. This session is going to be amazing fun and very unique. It is a full day demo-oriented learning session. Scroll all the way down to read about Extra Bonus!
Well, my pre-conference is for everyone who just wants to take their performance tuning expertise to next level but does not have enough time to spend learning about this topic. In this pre-con, I am going to share 21 unique and extremely essential scripts which every DBA’s must have if they want to keep the performance of their system to the next level.
Here is the 200 seconds video where I discuss what I am going to present at PASS Summit 2018 in my pre-conference 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs – PASS Pre-Con 2018. Please note that there are very limited seats available in each pre-conference, so if you ware thinking about registering for this pre-conference, do not delay at all. If you miss this pre-conference this year, I am not sure when and where this will be offered again.
Remember there are plenty of scripts available on the internet, this session contains the curated 21 scripts and with the detailed explanation of how to use the same to get maximum benefit out of it.
21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs
Date and Time: Tuesday, November 6, 2018
Location: Washington State Convention Center, Seattle
“Accidental DBAs” are the real superheroes for any organizations. When no one in the organization volunteers to solve the pressing problems, accidental DBAs often jump-in to save the day.
Accidental DBAs quickly learn all the routine administrative tasks as clear instructions are often available at various educational portals, product support website and on the internet. The real big challenge accidental DBAs often face when they have to identify and resolve application performance problems of the system under a heavy workload.
This quick-paced demo-oriented session will cover the real-world pain points for accidental DBAs who have keen interesting in catching performance troublemakers.
Here are the major topics which we will cover in this session:
- Optimal server configuration for performance
- Efficient database settings for balanced resource consumption
- Understanding self-healing index tuning mechanism
- Maintenance strategy and guidance
- Faster backup and restore strategy
- DBCC best practices
- Troubleshooting slow running query with Wait Statistics
- SQL Server 2017 New Features (Auto-Tuning, Query Store, Adaptive Joins, etc.)
In the last hour, we will play an interactive fun game with WHERE clause and Multi-Column index, where the individual who gets the maximum wrong answer will be a winner! In this session, we will explore 21 essential scripts which every DBA should keep handy, so they can stay alert fight and win the real-world problems. At the end of the pre-con, DBAs will learn how they can convert the accidents into opportunities.
You can click here to register for the session. I am looking forward to seeing you either in my session.
Bonus – Free 1 Hour 1:1 Mentoring
Everyone who attends Pre-con on Tuesday 6, 2018 “21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs“, gets FREE 1 hour 1:1 personalized mentoring online via (GoToMeeting or Skype) from the 90 days of the event. This 1-hour session will help users to further ask questions or ask for any clarification they need while they implement the learnings. If they no further questions, they can utilize this 1 hour for Express SQL Server Performance Health Check service (worth USD 495) for free.
Reference: Pinal Dave (https://blog.sqlauthority.com)