I love talking about performance tuning and I love teaching about performance tuning. If you are in the USA, this is your opportunity to join me to discuss about SQL Server Performance. I’ll be speaking at Live! 360, November 12 – 17 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. More info:
As a speaker, I can extend $500 savings on the 5-day package. Register here: and use code LSPK21.
I’ll be presenting the following sessions:
Turbo Boost – SQL Tricks Everybody MUST Know
Abstract:
Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
You will learn:
- SQL Server 2014 has introduced quite a few new things with related to SQL configurations. We will cover its impact with examples (memory, SSMS settings, filegrowth)
- About the concepts of auto-update as well auto-create statistics with a clear example
- The common tricks of SQL deployments which can immediately improve performance like tempdb , memory and CPU configurations etc.
Workshop: The Secret Toolbox for Performance Tuning and Optimizing Queries
This demo-oriented day-long workshop will answer the questions which DBAs and Developers often wonder about Performance Tuning and Query Optimization. There are some problems which have straight forward answers, but there are some problems which are often invisible or need attention without even a problem statement. This full-day workshop will be divided in these three major components:
1. Identifying common patterns and anti-patters for database performance tuning
- slow running queries
- IO Intensive operations
- CPU bottlenecks
- memory optimizations
- tempdb contention
- and much more
2. Resolving optimization hindrances and issues proactively
- indexing strategies
- file growths
- server deployment best practices
- statistics
- wait stats and queues
- and much more
3. Avoid query performance surprises when upgraded to the latest version of SQL Server 2014 and 2016
- new cardinality engine
- column store indexes best practices
- live plans
- azure enhancements
- in-memory OLTP optimizations
- and much more
You will learn:
- About identifying common patterns and anti-patters for database performance tuning
- About resolving optimization hindrances and issues proactively
- How to avoid query performance surprises when upgraded to the latest version of SQL Server 2014/2016
SPECIAL OFFER:
As a speaker, I can extend $500 savings on the 5-day package. Register here: and use code LSPK21.
Get better at what’s available, and get ready for what’s coming. We delve deep into the topics that matter most in your world today, covering practical knowledge, fundamentals, new technologies, and futures. Register now: http://bit.ly/LSPK21_home
Reference: Pinal Dave (https://blog.sqlauthority.com)
