One of my favorite events is #SQLBits and this year it took place in Manchester. I really enjoyed being there as I had an opportunity to present one Preconference (a day-long training day) and 2 breaks out sessions. SQLBits is an amazing conference as it excels in the following area.
Amazing Volunteers
This is one true event which is run by Volunteers. I can’t thank enough to these volunteers to give their personal time to give back to the community and build one of the best SQL Server events across the planet. They are not great but I would rather say they are better than GREAT. I am forever debt to their hard work.
#SQLBits Videos are Live
One of the most remarkable successes of these year’s SQLBits is that they have released the videos of all the breakout sessions in just less than 48 hours. I think it is an amazing success. Please note that the pre-conference session is not recorded so, they are not yet available but the breakout sessions are available.
21 Essential Scripts: Performance Tuning for EVERYONE
This session solves many of the classic mysteries people have related to performance tuning. In this session, I will provide accurate, ready to get started scripts which will solve DBA`s day to day problems.
For DBAs, Developers, and Everyone
The biggest challenge in any organizations is the DBAs and Developers talk totally different language when it is about SQL Server Performance Tuning. They have very different ways and methodology for addressing the same problem. Whenever I go to any consulting engagement, I often see that individuals in an organization struggle when they do not have good data point to back up the claim.
I have carefully crafted this pre-con for DBAs and Developers. Even though if you are an IT-Manager, you want to attend this pre-con as during this training day you will learn quite lots of details which you may not learn in your daily job.
Why 21 Scripts?
I have been working with SQL Server for over 16 years. In my 16 years of career, I have learned that most of the time DBAs and Developers think that they know their stuff as they have read it somewhere but the reality is very different.
What we know is quite often very incorrect and the actual reality is very difficult. From my 16 years of experience, I have built a knowledge base which exclusively shares during my consulting engagements. I have finally decided to make it public and let everyone learn along with me.
Tip of the Iceberg
The 21 scripts shared during the training serves as a Proof of Concepts, Quick Diagnosis Script as well as a ready cheat sheet to accomplish a complicated task which you have been dreaming to achieve. The scripts sound very simple but each of the scripts is carefully crafted to tell a unique story which you have not experienced before.
The video is not available if you want you can sign up for my First Online Open for All Class: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019.
Secrets of SQL Server-Database Worst Practices
“Oh! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session, we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Watch the Video Here for Secrets of SQL Server-Database Worst Practices
Kick Start! SQL Server 2017/2019 Performance Tips and Trick
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 / 2019 has introduced many new features. In this 60 minute session, we will be learning quite a few of the new features of SQL Server 2017 / 2019. Here is the glimpse of the features we will cover in this session.
- Adaptive Query Plans
- Batch Mode Adaptive Join
- New cardinality estimate for optimal performance
- Adaptive Query Processing
- Indexing Improvements
- Introduction to Automatic Tuning / Intelligent query processing
This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2017 / 2019 and its new features.
Watch the Video Here for Kick Start! SQL Server 2017/2019 Performance Tips and Trick
Well, once again, Thank you SQLBits for giving me oppertunity to do my own best.
Reference: Pinal Dave (https://blog.sqlauthority.com)
