If you are traveling to SQL PASS, Seattle this year, you do not want to miss out on my pre-con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs. This session is going to be amazing fun and very unique. It is full day demo-oriented learning session.
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)