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

YouTube

50 Things All SQL Server Developers Need to Know

PASS Data Community Summit via YouTube

Overview

Discover 50 essential SQL Server development tips in this comprehensive conference talk from PASS Data Community Summit. Learn crucial aspects of database design, T-SQL best practices, and query tuning techniques from expert Aaron Bertrand. Explore topics such as choosing appropriate data types, avoiding redundant data, optimizing column usage, understanding heaps, leveraging variable length types, and mastering cursor options. Gain insights into schema prefixing, identifying query performance red flags, and comprehending the query optimizer's behavior. Delve into advanced concepts like coercing the optimizer and managing parameter sniffing to enhance your SQL Server development skills and boost database performance.

Syllabus

Intro
Technical Assistance
PASS SUMMIT 2015
Development Environment
Database Design: Sensible Data Types
Database Design: Redundant Data
Database Design: Column Stuffing
Database Design: Heaps
T-SQL: Variable Length Types
T-SQL: Cursor Options
T-SQL: Schema Prefix
Query Tuning: Red Flags
Query Tuning : Understanding the Optimizer
Query Tuning : Coercing the Optimizer
Query Tuning: Parameter Sniffing
Like What You've Heard?

Taught by

PASS Data Community Summit

Reviews

Start your review of 50 Things All SQL Server Developers Need to Know

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.