What Every Developer Should Know About SQL Server Performance

511.47 MB | 00:08:43 | mp4 | 1024X768 | 4:3
Genre:eLearning |Language:English

Files Included :
001 - Getting Started - Course Introduction.mp4 (5.3 MB)
002 - Getting Started - Why Application Developers Should Understand SQL Performance.mp4 (2.76 MB)
003 - Getting Started - What You Will Learn.mp4 (2.58 MB)
004 - Getting Started - What Tools You Need.mp4 (4.91 MB)
005 - Getting Started - Installing the Sample Database.mp4 (6.48 MB)
006 - Getting Started - Table Concepts.mp4 (7.67 MB)
007 - Getting Started - Index Concepts.mp4 (5.74 MB)
008 - Getting Started - Summary.mp4 (1.59 MB)
009 - Analyzing SQL Statements for Performance - Introduction.mp4 (2.62 MB)
010 - Analyzing SQL Statements for Performance - Understanding How SQL Server Will Execute a SQL Statement.mp4 (10.1 MB)
011 - Analyzing SQL Statements for Performance - Reading and Interpreting an Execution Plan for a SQL Statement.mp4 (31.17 MB)
012 - Analyzing SQL Statements for Performance - Getting Execution Statistics for a SQL Statement.mp4 (12.11 MB)
013 - Analyzing SQL Statements for Performance - Improving Statement Performance by Adding an Index.mp4 (14.76 MB)
014 - Analyzing SQL Statements for Performance - Before and After Performance Comparison.mp4 (2.76 MB)
015 - Analyzing SQL Statements for Performance - Rewriting SQL Statements for Improved Performance.mp4 (13.93 MB)
016 - Analyzing SQL Statements for Performance - Common Execution Plan Operations.mp4 (13.52 MB)
017 - Analyzing SQL Statements for Performance - Summary.mp4 (8 MB)
018 - Building Effective Indexes - Introduction.mp4 (2.04 MB)
019 - Building Effective Indexes - Index Terminology Refresher.mp4 (5.04 MB)
020 - Building Effective Indexes - What Should I Index in My Database.mp4 (4.9 MB)
021 - Building Effective Indexes - Why Index Column Order Matters.mp4 (12.02 MB)
022 - Building Effective Indexes - Applying Index Column Order Rules.mp4 (4.06 MB)
023 - Building Effective Indexes - Index Selectivity Explained.mp4 (3.91 MB)
024 - Building Effective Indexes - Index Selectivity Examples.mp4 (22.95 MB)
025 - Building Effective Indexes - LIKE Clauses and Index Selectivity.mp4 (9.51 MB)
026 - Building Effective Indexes - How Functions in the WHERE Clause Affect Indexes.mp4 (13.57 MB)
027 - Building Effective Indexes - Include Columns and Covering Indexes.mp4 (9 MB)
028 - Building Effective Indexes - Over-indexing.mp4 (6.39 MB)
029 - Building Effective Indexes - Interpreting SQL Server Index Recommendations.mp4 (5.42 MB)
030 - Building Effective Indexes - Module Review.mp4 (9.03 MB)
031 - Finding Performance Bottlenecks in SQL Server - Introduction.mp4 (5.61 MB)
032 - Finding Performance Bottlenecks in SQL Server - Required Permissions for Querying Dynamic Management Views.mp4 (3.73 MB)
033 - Finding Performance Bottlenecks in SQL Server - Getting Information About SQL Server Sessions and Resource Usage.mp4 (10.29 MB)
034 - Finding Performance Bottlenecks in SQL Server - Finding What SQL Statements are Currently Executing.mp4 (16.08 MB)
035 - Finding Performance Bottlenecks in SQL Server - Finding the Slowest, Most Expensive SQL Statements.mp4 (15.05 MB)
036 - Finding Performance Bottlenecks in SQL Server - Getting SQL Server's Recommendations on Missing Indexes.mp4 (16.48 MB)
037 - Finding Performance Bottlenecks in SQL Server - Finding Indexes That are Not Being Used.mp4 (13.69 MB)
038 - Finding Performance Bottlenecks in SQL Server - Summary.mp4 (1.7 MB)
039 - Capturing What Your Application is Doing Inside SQL Server - What is SQL Tracing and Why Developers Should Know About it.mp4 (6.44 MB)
040 - Capturing What Your Application is Doing Inside SQL Server - Setting up a SQL Profiler Trace.mp4 (14.01 MB)
041 - Capturing What Your Application is Doing Inside SQL Server - Running a SQL Profiler Trace.mp4 (15.29 MB)
042 - Capturing What Your Application is Doing Inside SQL Server - Running a Trace as a Server Side Trace.mp4 (20.7 MB)
043 - Capturing What Your Application is Doing Inside SQL Server - Introduction to Using Extended Events for SQL Tracing.mp4 (3.9 MB)
044 - Capturing What Your Application is Doing Inside SQL Server - Setting up an Extended Events Trace Session.mp4 (23.55 MB)
045 - Capturing What Your Application is Doing Inside SQL Server - Running an Extended Events Trace Session.mp4 (3.74 MB)
046 - Capturing What Your Application is Doing Inside SQL Server - Configuring the Display Settings for Extended Events Data.mp4 (6.63 MB)
047 - Capturing What Your Application is Doing Inside SQL Server - Analyzing Extended Events Trace Data.mp4 (16.57 MB)
048 - Capturing What Your Application is Doing Inside SQL Server - Using Extended Events in SQL Azure.mp4 (11.25 MB)
049 - Capturing What Your Application is Doing Inside SQL Server - Summary.mp4 (9.17 MB)
050 - Applying Common Performance Practices - Introduction.mp4 (1.71 MB)
051 - Applying Common Performance Practices - Use Parameterized SQL.mp4 (9.5 MB)
052 - Applying Common Performance Practices - Are Stored Procedures Faster Than SQL in Application Code.mp4 (4.42 MB)
053 - Applying Common Performance Practices - Commit Behavior and Performance.mp4 (7.58 MB)
054 - Applying Common Performance Practices - Object Relational Mappers Just Generate SQL.mp4 (3.94 MB)
055 - Applying Common Performance Practices - Solving the N+1 Selects Problem.mp4 (13.73 MB)
056 - Applying Common Performance Practices - Summary.mp4 (3.17 MB)
sql-server-performance-every-developer-should-know.zip (6.13 MB)]
Screenshot