SQL Server Performance Tuning by Denny Cherry
This one-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases. Course will take place on April 3rd 2020 at Microsoft Zagreb Office, Horvatova 82, Zagreb.
In this session you will learn about SQL Server 2008 R2 through SQL Server 2017 performance tuning and optimization. Industry Expert Denny Cherry will guide you through tools and best practices for tuning queries and improving performance within Microsoft SQL Server. This session will guide you through real life performance problems which have been gathered and tuned using industry standard best practices and real-world skills.
This session starts off with reviewing the various native tools which are available to you from Microsoft with your SQL Server License and how all of these tools can be used to help you performance tune your SQL Server installation. These tools include SQL Profiler, Extended Events, Database Tuning Advisor and more. We will use these tools to identify problem areas within the SQL Server database engine and how to solve for these problems.
We will look at the new ColumnStore index and how it can be used to improve performance within your data warehouse platforms, including how to use it in a data warehouse which needs to be written to throughout the day bypassing the problem of the columnstore index being read only.
We will discuss some scale out options which are available with Microsoft SQL Server both within the database by using table partitioning to spread the workload to multiple disks, as well as AlwaysOn Availability Groups and how they can be used to scale a database out across multiple servers.
The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of database administration and maintenance
- Working knowledge of Transact-SQL.
About the speaker
Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2008 including the Microsoft Certified Master as well as being a Microsoft MVP for several years. Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.
|One-day seminar price
|Early bird price (before 01.02.2020.)
|*All prices are in Euro (€), VAT excluded
Registrations for the seminar are opened until 01.03.2020. The number of attendees is limited to 20 seats. The minimum attendees required for the seminar to be hold is 10. Because of limited seats and great interest please register on time if you like to attend this event.
If you are interested in attending the SQL Saturday Croatia 2020 preconference seminar “SQL Server Performance Tuning by Denny Cherry” please reserve your seat and register here.
*Registration is just a seat reservation; you will get payment details for the event when minimum number of attendees is meet.