SQLAuthority News – 3 Performance Tuning Presentations at SQLBits 2018 – London

I have so far attended many different technology conferences all over the world. SQLBits 2018 is my all time the favorite conference ever. This year, I was fortunate to present 1 Pre-Con and 2 Breakout Sessions on SQL Server subjects. I had received an amazing response to my sessions and pre-conferences.

SQLBits is extremely well-organized event based out of London. I was extremely impressed with the attention to the details during the event. I have heard a lot about the SQLBits attendees party and trust me, it was an amazing party. This year the theme of the party was magic and I had blast attending the party.

Every presentation room at SQLBits was named after the famous magician. I got a real kick out of the fact that my pre-conference room was named as Penn, who is my favorite magician.

Before this event, I had a great pleasure to spend quality time with Brent Ozar and Tara Kizer. I really had a great time discussing SQL Server, Technology and life in general with them while exploring London. Later on during the session, I had a kind company of Erik Darling. SQLBits is such a unique event which helps you rejuvenate your relationships with old friends and build a relationship with new friends.

Here are the three sessions I presented at SQLBits 2018.

36 Scripts: Performance Tricks Jedi Master Wants You to Know

This demo-oriented day-long session will answer the questions which DBA and Developers often wonder about Performance Tuning and Query Optimization.

There are some problems which have straightforward answers, but there are some problems which are often invisible or need attention without even a problem statement. This day-long session will be divided into these three major components:

• • 1) Identifying and resolve common performance tuning patterns and anti-patterns
    • a) Slow running queries,
    • b) Resource Intensive operations (IO, CPU, and Memory)
    • c) tempdb contention
    • d) optimizing the execution plan
  • 2) Proactively resolving optimization bottlenecks and issues
    • a) Indexing strategies,
    • b) wait stats and queues,
    • c) database file deployment best practices,
    • d) optimizing statistics
  • 3) Plan ahead for unexpected performance issue while upgraded to the latest version of SQL Server 2014 and 2016
    • a) New cardinality engine,
    • b) column store indexes best practices
    • c) live plans,
    • d) azure enhancements,
    • e) in-memory OLTP optimizations
    • f) query store
    • g) temporal table

We will discuss 36 different tips and tricks along with scripts in this session and every attendee will have those scripts handy upon completion of the session.

Efficiency Tips and Tricks for Multi-Platform Data Client DBAs

If you are a DBA who is dealing with multiple platforms like SQL Server, MySQL, MariaDB, PostgreSQL, RedShift etc, this session is for you. The number one issue multi-platform DBA often face is that they have to learn multiple Integrated Development Environment (IDE)s when they have to deal with different databases. The initial curiosity of learning something new often gets old very fast when dealing with multiple platforms for different databases. There are often scenarios when we want simple efficiency enhancement in our daily routine like powerful search, cloud storage and collaboration, which we often see often missing in our run of the mill clients.

This session is not your usual tips and tricks session. It is rather a very different take on the life of multi-platform DBAs’s life. We will share some real-world scenarios and life stories of DBA who have to deal with different database platform every day and their constant battle with efficiency. We will see some neat solutions, demos, and tools which can make our daily job pleasant. Remember that everybody who will attend the session will get free scripts which they can use to improve their SQL Server’s performance.

Kick Start! SQL Server 2016/2017 Performance Tips and Tricks

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 2016 / 2017 has introduced many new features. In this 75 minute session we will be learning quite a few of the new features of SQL Server 2016 / 2017. 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

This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2016 / 2017 and its new features.

Reference: Pinal Dave (https://blog.sqlauthority.com)