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 full day demo-oriented learning session. I have previously blogged about it here.
I personally consider DBA’s superheroes as they have quite a lots of different responsibilities. They are responsible for quite a lots of different tasks from like – performance, security, backup, restore, monitoring, high availability, infrastructure, vendors, upgrades, compliance etc. While DBA’s are doing multiple different tasks, they often can’t pay attention to anyone task which they want to focus. For example, many DBAs often wants to focus on performance tuning area but they are not able to focus on this area because they are quite frequently pulled in various different directions.
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 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.
Do not forget to register today or you will miss the seats as they are limited. If you can’t make it to Seattle in November, alternatively you can register for my online course Practical Real World Performance Tuning.
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.
PASS is your invitation to a global community of over 250,000 like-minded data professionals who leverage the Microsoft Data Platform. Becoming a member unlocks incredible year-round learning and professional development opportunities, virtual webinars, in-person networking, and mentorship.
Here is the Unique Code, which will enable you with a USD 150 discount off the registration cost of the PASS Summit 2018.
Reference: Pinal Dave (https://blog.sqlauthority.com)