Class 5– Optimising the SQL Platform for 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 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 to improve performance and scalability. A focus is on the platform but many concepts are equally applicable to Java and other platforms.

First we will demonstrate design choices 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/ 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

For further information contact: or call 01 2933883

Register Now


  • Bob Duffy

    Bob Duffy

    Bob is a Microsoft Certified Master, Microsoft Certified Architect, SSAS Maestro & local SQL Server MVP. He is lead consultant at Prodata SQL Centre of Excellence and blogs at


  • Prodata SQL Centre of Excellence
  • Microsoft

Other Information