Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

The Right Tool for the Right Job - Serving Data From SQL Server

PASS Data Community Summit via YouTube

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session compares stored procedures, ORMs, and other methods for accessing SQL Server data, with examples using Entity Framework, Dapper, and ADO.NET. It also introduces application data access performance tuning and database design strategies for query performance.

Syllabus

Introduction
PASS
Session Evaluation
About Dan
Session Overview
Hardcoded SQL
Stored Procedures
Tool Generated SQL
Use Cases
My Opinions
Query Performance
Tuning Queries
Optimize for Adhoc
Design Thoughts

Taught by

PASS Data Community Summit

Reviews

Start your review of The Right Tool for the Right Job - Serving Data From SQL Server

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.