21 Essential Scripts: Performance Tuning for EVERYONE - with Pinal Dave

We are global providers of technicalconsulting,mentoringandtrainingservices for Microsoft Data Management platforms. We focusonDataPlatformModernization,Business IntelligenceandMachineLearning.We founded SolidQ in 2002, with the sole purpose of creating a company where the very best and mostrecognized professionalsin the industry could collaborate, feel a true sense of belonging, and lever their expertise for the betterment of our clients.What we can do for you?We want to be part of your business project by building and implementing aData Driven Strategy. We can share your digitalization path while providinginnovative solutionsbased on our proven frameworks and expertise.At SolidQ, we believe there is a faster and better way to turn technology into knowledge for your business. A more valuable, less invasive way where results show in weeks. We have developed our own tools and frameworks, so we can focus on higher-value tasks instead of repetitive processes.Contact us:https://www.solidq.com/contact

SolidQ

In this session I will provide accurate, ready to get started scripts which will solve DBA`s day to day problems.

SolidQ Denmark

For DBAs, Developers, and EveryoneThe 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 share 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 are carefully crafted to tell a unique story which you have not experienced before.- Script 00: How to clear the Cache?- Script 01: Why unused indexes are bad? (Insert/Delete)- Script 02: Why unused indexes are bad? (Select)- Script 03: How to identify UNUSED indexes in SQL Server?- Script 04: How to identify MISSING indexes in SQL Server?- Script 05: How to identify DUPLICATE indexes in SQL Server?- Script 06: How important is the file growth setting is for Database?- Script 07: Do COLUMNSTORE indexes help query performance?- Script 08: How to get started with OLTP In-Memory Tables- Script 09: What about OLTP In-Memory Ttables with COLUMNSTORE indexes?- Script 10: How do STATISTICS play a role in performance tuning?- Script 11: How does COMPATIBILITY Level play a role in performance tuning?- Script 12: What is the impact of functions on query performance? (Where clause)- Script 13: What is the impact of functions on query performance? (Select clause)- Script 14: How to identify frequently running functions?- Script 15: How to identify frequently running queries?- Script 16: How to identify resource bottlenecks for server with Wait Statistics?- Script 17: How to overcome CPU bottlenecks - under utilization / over utlization?- Script 18: How to overcome MEMORY bottlenecks?- Script 19: How to overcome IO bottlenecks?- Script 20: How to overcome Blocking in SQL Server?- Script 21: How IMPLICIT conversion can kill database performance?Bonus Round: Interactive Game - WhichIndex and 3 RulesPinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 23 Pluralsight courses and has written over 4700 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

21 Essential Scripts: Performance Tuning for EVERYONE - with Pinal Dave

More events from SolidQ

Follow organisers to get events picked for you

21 Essential Scripts: Performance Tuning for EVERYONE - with Pinal Dave

More events from SolidQ

Follow organisers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.