Heraflux is proud to announce our next installment of live online training with Bob Pusateri (@SQLBob). The focus of this training session is called “Improving the Performance of Third-Party Vendor SQL Server Databases“, and focuses on how to help you get the most out of your vended databases without voiding the warranty.
In order to accommodate most DBA schedules, the session will be held in two four-hour blocks on the following dates and times.
Microsoft Certified Master Bob Pusateri leads this course on improving SQL Server performance for third-party vendor applications. It’s not uncommon for applications to demonstrate lousy performance due to suboptimal schema design or poorly-performing database queries, and you know how to make it better. However, many vendors make it either impossible or outright forbidden to change that code. This all-day course will focus on the many options that Microsoft SQL Server offers to improve the performance of an application without altering its queries. Attendees will be exposed to numerous performance tuning practices at both the SQL Server and infrastructure levels, and will learn how to review key points of their stack to ensure optimal SQL Server performance for almost any vendor application.
The event runs in two four-hour windows, 1-5pm on Tuesday, July 18th and Wednesday, July 19th, so that data professionals can attend without having to take an entire day away from their ongoing responsibilities.
The following topics will be addressed during the course:
- Wait Statistics
- Execution Plans
- Query Store
- Plan Guides
- Blocking and Locking
- Primary and Foreign Keys
- Server Configuration
- Indexing & Statistics
- Routine Maintenance
- Hardware & Infrastructure
- Tools & Scripts
More details about this exciting training class are available at Heraflux.com. We look forward to having you learn from our own certified Master!