In this course, Essentials of SQL Server Performance For Every Developer, you'll see how to diagnose what's happening with a slow-running SQL statement and what strategies are available to make these statements run faster.

By the end of this course, you, as an application developer, will have the tools you need to troubleshoot performance issues you may encounter when using SQL Server.

Code, Links, Dynamic Views (DMVs), and Database Backups: https://github.com/iCodeMechanic/Essentials-of-Sql-Server-Performance-for-Every-Developer

️ Course by Rajan Arora. Check out his channel: https://www.youtube.com/c/ICodeMechanic

️ Course content ️
️ (0:00:00) Introduction

To work
️ (0:00:53) 1.1 Course introduction
️ (0:04:07) 1.2 Why developers need to understand SQL performance
️ (0:06:20) 1.3 Tools you need
️ (0:09:30) 1.4 Restore the sample database
️ (0:12:04) 1.5 Table concept
️ (0:17:12) 1.6 Index concept
️ (0:20:32) 1.7 Summary

Analyze SQL statements for performance
️ (0:22:12) 2.1 Introduction
️ (0:24:55) 2.2 Understanding how SQL Server will execute an SQL statement
️ (0:29:33) 2.3 Read and interpret an execution plan for an SQL statement
️ (0:39:44) 2.4 Obtain execution statistics for an SQL statement
️ (0:45:29) 2.5 Improve statement performance by adding an index
️ (0:52:11) 2.6 Rewrite SQL statements for better performance
️ (0:58:32) 2.7 Common Execution Plan Operations
️ (1:03:50) 2.8 Summary

Building indexes
️ (1:07:30) 3.1 Introduction
️ (1:09:09) 3.2 Refresher of index terminology
️ (1:12:11) 3.3 What should I index in my database?
️ (1:16:16) 3.4 Why the order of index columns is important
️ (1:23:39) 3.5 Index selectivity explained
️ (1:36:23) 3.6 LIKE clauses and index selectivity
️ (1:40:27) 3.7 How functions in the WHERE clause affect indexes
️ (1:46:10) 3.8 Add columns and coverage indexes
️ (1:50:40) 3.9 Overindexing
️ (1:54:40) 3.10 Interpreting SQL Server Index recommendations
️ (1:57:38) 3.11 Summary

Find bottlenecks in SQL Server performance
️ (2:03:19) 4.1 Introduction
️ (2:08:36) 4.2 Obtain information about SQL Server sessions and resource usage
️ (2:12:02) 4.3 Find which SQL statements are currently executing
️ (2:18:47) 4.4 Finding the slowest and most expensive SQL statements
️ (2:24:13) 4.5 SQL Server Recommendations on Getting Missing Indexes
️ (2:29:38) 4.6 Find indexes that are not used
️ (2:34:13) 4.7 Summary

Capture application trace logs from SQL Server
️ (2:35:55) 5.1 Introduction
️ (2:42:03) 5.2 Set up a SQL Profiler trace
️ (2:49:59) 5.3 Running a SQL Profiler trace
️ (2:55:22) 5.4 Running a trace as a server-side trace
️ (3:03:19) 5.5 Introduction to using extended events for SQL tracing
️ (3:06:58) 5.6 Set up an extended event tracking session
️ (3:16:50) 5.7 Run and configure the display settings for comprehensive event tracking
️ (3:20:38) 5.8 Analyze extended event trace data
️ (3:27:10) 5.9 Using Extended Events in SQL Azure
️ (3:31:36) 5.10 Summary

Apply common practices for better performance
️ (3:35:47) 6.1 Introduction
️ (3:37:17) 6.2 Use parameterized SQL
️ (3:42:59) 6.3 Are stored procedures faster than SQL in application code?
️ (3:43:04) 6.4 Commitment behavior and performance
️ (3:50:16) 6.5 Object-relational mappers simply generate SQL
️ (3:53:19) 6.6 Fixing the N1 Selects problem
️ (3:59:56) 6.7 Summary

Thanks to our champion and sponsor supporters:
Raymond Odero
Agustin Kussrow
aldo ferretti
Otis Morgan
DeezMaster

—

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles about programming: https://freecodecamp.org/news

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.