Class 5– Optimising the SQL Platform for dot.net Solutions
This course is level 200 - 300 and is perfect for those from an application development background, who want to knowledge of interaction with SQL Server, or for SQL professionals who want to delve deeper into how dot.net design and coding practices can cause performance or scalability Issues.
We aim to offer guidance on how to design your Data Access Strategy to make the right choices for performance, and the how to monitor and tune a SQL workload by making common change in dot.net to improve performance and scalability. A focus is on the dot.net platform but many concepts are equally applicable to Java and other platforms.
First we will demonstrate design choices dot.net offers to interface with SQL Server when using ADO.Net and benchmark the impact on performance, then we will take a sample application running in a load test harness and show common performance worst practices, how to correct them and the impact on performance.
- Module 1 - Dot.Net Data Access Fundamentals.
- Module 2 - SQL/dot.net Performance Tuning Methodology and Tools.
Dates: Thursday 28th February 2013
Veune: Microsoft Auditorium, EPDC2, South County Business Park
Registration: 13.00 – 13.30
Class: 13.30 – 17.30
€100 if booked individually or €350 for entire series