Analyze and tune SQL Server like a BOSS by Uwe Ricken
Date and time
Refund policy
Description
SQL Server is a mission critical database platforrm but is sensitive to misconfigurations, bad practices, sub-optimal indexing strategies and poor coding mistakes. Even the fastest hardware can end up performing like a ZX-81 if you get things wrong.
If you are a Database Administrator or Consultant who is responsible for expert performance analysis, problem detection and tuning of the SQL engine then it is important you are able to analyze and tune SQL Server like a BOSS.
In this full training day I will explain how to identify and resolve serious real world performance problems using concrete examples, demonstrations, possible effects and answers. This workshop will provide over 40 scripts which can be used directly in the workshop on your own machines during the day and we shall simulate performance problems and look to resolve them using a top-down approach.
A selection of things you can look forward to learning and experiencing during the day are:
- Waits and Queues methology
- Instance and database level configuration
- TempDB importance and optimization
- Index Analysis and tuning
- Humour (yes Germans can be funny too!)
Session Details
There are no prerequisites required. The analysis of the SQL Server Enigne will follow a top to down direction with lots of scripts and detailed explanation during the session.
Additional InformationThe session will consist of lectures and demonstrations. A laptop is recommended to take advantage to analyze YOUR SQL Server environment within the session with direct help for a solution.
About Uwe
Uwe Ricken is working with IT-systems since early 1990's. He started with development of database applications in 1998 with a professional CRM-System based on Microsoft products (Microsoft Office and SQL Server). In May 2013 he achieved the "Microsoft Certified Master: SQL Server 2008. Since 2013 he has been awarded continuously with the MVP Award for his activities and engagement for the SQL community and was the first MCM + MVP for SQL Server in Germany.
Other SQLSaturday Cambridge pre-conference sessions
Data Mining Algorithms in SSAS, Excel, R, and Azure ML by Dejan Sarka
Exploring the Modern Data Warehouse using HDInsight by Josh Fennessy
Friday 9th September 2016
Start to Finish with Azure Data Factory by Buck Woody
Analyze and tune SQL Server like a BOSS by Uwe Ricken
Terms and Conditions of Sale
Paid tickets are transferrable to another candidate only upon request (and where possible). The "Buy one and receive a 50% discount on another" offer is strictly limited to purchaser (and availability) and is non-transferrable (except where the primary ticket has also been transferred). This offer may not be used in conjunction with any other discount codes and is strictly once per person. Tickets are non-refundable except in the event of cirmcumstances beyond our control which result in the cancellation of the event/ session/ speaker. In the event of precon cancellation, we will not be held liable for any third-party costs or fees (such as accomodation and travel), but we would endeveour to try and offer an alternative and comparable substitute speaker in a timely manner and provide as much notice as possible in order for alternative arrangements to be made. The event reserves all rights to amend terms and conditions where necessary in order to deliver a successful and profitable conference but will only do so under exceptional circumstances.