Pluralsight - What Every Developer Should Know About SQL Server Performance

1. 001 - Getting Started - Course Introduction.mp45.3MB
2. 002 - Getting Started - Why Application Developers Should Understand SQL Performance.mp42.76MB
3. 003 - Getting Started - What You Will Learn.mp42.58MB
4. 004 - Getting Started - What Tools You Need.mp44.91MB
5. 005 - Getting Started - Installing the Sample Database.mp46.48MB
6. 006 - Getting Started - Table Concepts.mp47.67MB
7. 007 - Getting Started - Index Concepts.mp45.74MB
8. 008 - Getting Started - Summary.mp41.59MB
9. 009 - Analyzing SQL Statements for Performance - Introduction.mp42.62MB
10. 010 - Analyzing SQL Statements for Performance - Understanding How SQL Server Will Execute a SQL Statement.mp410.1MB
11. 011 - Analyzing SQL Statements for Performance - Reading and Interpreting an Execution Plan for a SQL Statement.mp431.17MB
12. 012 - Analyzing SQL Statements for Performance - Getting Execution Statistics for a SQL Statement.mp412.11MB
13. 013 - Analyzing SQL Statements for Performance - Improving Statement Performance by Adding an Index.mp414.76MB
14. 014 - Analyzing SQL Statements for Performance - Before and After Performance Comparison.mp42.76MB
15. 015 - Analyzing SQL Statements for Performance - Rewriting SQL Statements for Improved Performance.mp413.93MB
16. 016 - Analyzing SQL Statements for Performance - Common Execution Plan Operations.mp413.52MB
17. 017 - Analyzing SQL Statements for Performance - Summary.mp48MB
18. 018 - Building Effective Indexes - Introduction.mp42.04MB
19. 019 - Building Effective Indexes - Index Terminology Refresher.mp45.04MB
20. 020 - Building Effective Indexes - What Should I Index in My Database_.mp44.9MB
21. 021 - Building Effective Indexes - Why Index Column Order Matters.mp412.02MB
22. 022 - Building Effective Indexes - Applying Index Column Order Rules.mp44.06MB
23. 023 - Building Effective Indexes - Index Selectivity Explained.mp43.91MB
24. 024 - Building Effective Indexes - Index Selectivity Examples.mp422.95MB
25. 025 - Building Effective Indexes - LIKE Clauses and Index Selectivity.mp49.51MB
26. 026 - Building Effective Indexes - How Functions in the WHERE Clause Affect Indexes.mp413.57MB
27. 027 - Building Effective Indexes - Include Columns and Covering Indexes.mp49MB
28. 028 - Building Effective Indexes - Over-indexing.mp46.39MB
29. 029 - Building Effective Indexes - Interpreting SQL Server Index Recommendations.mp45.42MB
30. 030 - Building Effective Indexes - Module Review.mp49.03MB
31. 031 - Finding Performance Bottlenecks in SQL Server - Introduction.mp45.61MB
32. 032 - Finding Performance Bottlenecks in SQL Server - Required Permissions for Querying Dynamic Management Views.mp43.73MB
33. 033 - Finding Performance Bottlenecks in SQL Server - Getting Information About SQL Server Sessions and Resource Usage.mp410.29MB
34. 034 - Finding Performance Bottlenecks in SQL Server - Finding What SQL Statements are Currently Executing.mp416.08MB
35. 035 - Finding Performance Bottlenecks in SQL Server - Finding the Slowest, Most Expensive SQL Statements.mp415.05MB
36. 036 - Finding Performance Bottlenecks in SQL Server - Getting SQL Server's Recommendations on Missing Indexes.mp416.48MB
37. 037 - Finding Performance Bottlenecks in SQL Server - Finding Indexes That are Not Being Used.mp413.69MB
38. 038 - Finding Performance Bottlenecks in SQL Server - Summary.mp41.7MB
39. 039 - Capturing What Your Application is Doing Inside SQL Server - What is SQL Tracing and Why Developers Should Know About it.mp46.44MB
40. 040 - Capturing What Your Application is Doing Inside SQL Server - Setting up a SQL Profiler Trace.mp414.01MB
41. 041 - Capturing What Your Application is Doing Inside SQL Server - Running a SQL Profiler Trace.mp415.29MB
42. 042 - Capturing What Your Application is Doing Inside SQL Server - Running a Trace as a Server Side Trace.mp420.7MB
43. 043 - Capturing What Your Application is Doing Inside SQL Server - Introduction to Using Extended Events for SQL Tracing.mp43.9MB
44. 044 - Capturing What Your Application is Doing Inside SQL Server - Setting up an Extended Events Trace Session.mp423.55MB
45. 045 - Capturing What Your Application is Doing Inside SQL Server - Running an Extended Events Trace Session.mp43.74MB
46. 046 - Capturing What Your Application is Doing Inside SQL Server - Configuring the Display Settings for Extended Events Data.mp46.63MB
47. 047 - Capturing What Your Application is Doing Inside SQL Server - Analyzing Extended Events Trace Data.mp416.57MB
48. 048 - Capturing What Your Application is Doing Inside SQL Server - Using Extended Events in SQL Azure.mp411.25MB
49. 049 - Capturing What Your Application is Doing Inside SQL Server - Summary.mp49.17MB
50. 050 - Applying Common Performance Practices - Introduction.mp41.71MB
51. 051 - Applying Common Performance Practices - Use Parameterized SQL.mp49.5MB
52. 052 - Applying Common Performance Practices - Are Stored Procedures Faster Than SQL in Application Code_.mp44.42MB
53. 053 - Applying Common Performance Practices - Commit Behavior and Performance.mp47.58MB
54. 054 - Applying Common Performance Practices - Object Relational Mappers Just Generate SQL.mp43.94MB
55. 055 - Applying Common Performance Practices - Solving the N+1 Selects Problem.mp413.73MB
56. 056 - Applying Common Performance Practices - Summary.mp43.17MB