The Right Tool for the Right Job - Serving Data From SQL Server
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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
Web Development with ASP.NET C# and Entity Framework Code-FirstCanvas Network Developing Data Client Applications and Services
Microsoft via edX Build Web APIs using ASP.NET
Microsoft via edX Database Design with SQL Server Management Studio (SSMS)
Coursera Project Network via Coursera Building Chatbot with Google DialogFlow
Coursera Project Network via Coursera