YoVDO

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

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Entity Framework Courses ADO.NET Courses Performance Tuning Courses Object-Relational Mapping (ORM) Courses Stored Procedures Courses Dapper Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore strategies for efficient data retrieval from SQL Server in this 55-minute conference talk from PASS Data Community Summit. Learn when to use stored procedures, ORMs, and other methods, comparing their pros and cons. Discover implementation techniques for Entity Framework, Dapper, and ADO.NET in .NET environments. Gain insights into performance tuning for application data access and database structuring for optimal query performance. Delve into topics such as hardcoded SQL, stored procedures, tool-generated SQL, and design considerations for improved database efficiency.

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

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube
Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube
Transform Your Data Estate
PASS Data Community Summit via YouTube
Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube
SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube