SqClient Data Access Fundamentals

This session covers a walk through of the dot.net SqlClient and the impact of various choices you can make when developing an application.

We will be covering topics such as connection pooling, data retrieval, parameterization, plan re-usage, prepared statements, optimization of RPC calls, the SqlClient classes and bulk methods. Included for download to play with afterwards is a sample application to demonstrate and benchmark key features.

The target audience is professionals from an application development background, who work with
SQL Server, or for SQL professionals who also work in the dot.net world.

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is both MCA and MCM certified. Bob has spent many years helping customers in Ireland with performance tuning and load testing.
Presented by Bob Duffy at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Bob_Duffy.jpg
    Bob Duffy is a SQL Server MVP, currently working as a Database and Solution Architect in Dublin, Ireland. He has over 19 years experience in the database sector, with MCA, MCM and Maestro certification.
    http://blogs.prodata.ie/author/Bob.aspx http://blogs.prodata.ie/syndication.axd
  • Video
    The video is not available to view online.