 |
 | Snapshot Isolation Overview of isolation levels, controlling isolation levels, statement-level read consistency, transaction-level read consistency, overhead and monitoring. Monday, Dec 27 |
 | Security EXECUTE AS and SQL Injection Overview of EXECUTE AS, ownership chains, cross database impersonation, SQL inejction, common patterns, character filtering and privileges. Monday, Dec 27 |
 |
 |
 | Partial Database Availability & Online Piecemeal Restore Overview of partial database availability and online piecemeal restore functionality. Monday, Dec 27 |
 | Optimizing Procedural Code Overview of procedure code optimization, including plan reuse and recompilation concepts and behaviors. Monday, Dec 27 |
 | Multi-Server Management Demo Demonstration video for the "Multi-Server Management" lecture. Monday, Dec 27 |
 | Indexing Strategies Demonstration Demonstration video for the "Indexing Strategies" lecture. Monday, Dec 27 |
 | Indexing Strategies Overview of indexing for performance, strategies for design, pitfalls and optimizing aggregates. Monday, Dec 27 |
 | Index Analysis Overview of index analysis techniques, validating if your indexes are using the right combination of keys, if your indexes are being used and how, if there are missing indexes and if your indexes are stil healthy and most optimal. Monday, Dec 27 |
 | Designing an Availablity Strategy Overview of what high availability concepts and planning an availability strategy and technology evaluation. Monday, Dec 27 |
 |
 | Clustering Setup & Troubleshooting Overview of cluster setup, administration and troubleshooting. Monday, Dec 27 |
 |
 | Storage Guidelines General storage guidelines, RAID levels, shared vs. dedicated and miscellaneous guidelines. Sunday, Dec 12 |
 |
 | Storage Testing and Monitoring Overview of the challenges of SAN monitoring, recommendations for getting started, Perfmon storage counters, testing before installation and ongoing health monitoring. Sunday, Dec 12 |
 |
 | Index Internals Overview of physical index levels, clustered and nonclustered index structures (leaf-level, B-tree). Friday, Dec 10 |
| | The Clustered Index Debate Overview of table structures, clustered index structures, nonclustered indexes and "bookmark lookups", understanding the efficiency of the "lookup" value, cumulative effect of inefficient clustering keys, key constraint create indexes and choices for a good clustering key. Friday, Dec 10 |
| | Statistics Overview of querying specific index usage, what do statistics look like, what do statistics tell us, how do we use statistics, how\when statistics get created and how\when statistics get updated. Friday, Dec 10 |
| |
 | Locking Overview of locking basics, locking and blocking, granularity, escalation, duration and troubleshooting locking behavior. Friday, Dec 10 |
 |
| | Restore Internals Overview of the phases of restore, recovery completion states, point-in-time recovery, restoring sequence and locations. Friday, Dec 10 |
 |
 |
 |
 |
 |
 | Database Mirroring Overview of mirroring configuration, failure types and speed, failure scenarios, client redirection, and 2008 enhancements. Friday, Dec 10 |
 | Multi-Server Management Overview of Multi-Server Management concepts, features and functionality. Friday, Dec 10 |
 | Policy-Based Management Demo Demonstration video for the "Policy-Based Management" lecture. Friday, Dec 10 |
 |
 |
 |
 | Virtualization Overview of how virtualization changes CPU, Memory, Storage and Monitoring. Tuesday, Nov 9 |
 | Security Auditing and Compliance Overview of auditing and compliance, auditing options before SQL Server 2008 and then SQL Server 2008 auditing features. Tuesday, Nov 9 |
 | Security Keys and Encryption Overview of encryption and types of keys, the key hierarchy, key management, encrypting data, encrypting a database (TDE) and Extensible Key Management (EKM). Tuesday, Nov 9 |
 | Security Authentication and Authorization Overview of authentication - including instance level, credentials and database level. This lecture also covers authorization, including securables and permissions, users and schemas, ownership chains, assigning permissions to code. Tuesday, Nov 9 |
 | Security Introduction and Server Setup Overview of securing the machine, the OS, services, the network and security configuration with policies. Tuesday, Nov 9 |
 | Baselining and Benchmarking Overview of reactive versus proactive monitoring, Performance Monitor, Profiler and benchmarking "whys" and "hows". Tuesday, Nov 9 |
 |
 |
 |
 | Index Fragmentation Overview of data access methods, fragmentation, page splits, FILLFACTOR and detecting/removing fragmentation. Monday, Nov 8 |
 |
 | Backup Internals Overview of backup types (full, transaction log, differential), strategy concerns, backup integrity and backup compression. Monday, Nov 8 |
 |
 | Database Snapshots Overview of database snapshot internals and database snapshot uses and limitations. Monday, Nov 8 |
 |
 | Sparse Columns Overview of hererogeneous data, problems with non sparse implementations, flexible schema choices and understanding sparse columns. Monday, Nov 8 |
.jpg) | SQL Azure Database Overview of the SQL Azure archiecture, Transact-SQL DDL and DML differences, and considerations for moving data to and from SQL Server. Wednesday, Oct 20 |
 | Service Broker Overview of Service Broker, database objects, database properties, activation programs, inter-database and inter-server considerations, and a deep dive on an end-to-end Service Broker application. Wednesday, Oct 20 |
.jpg) | SQL Server Spatial Overview of SQL Server Spatial functionality including the Geometry and Geography, CLR-based architecture, spatial indexes and performance, and importing spatial data. Wednesday, Oct 20 |
 | Change Data Capture, Change Tracking and Integrated Fulltext Search Overview of change tracking features, Change Data Capture, Change Tracking, and IFTS. Wednesday, Oct 20 |
.jpg) | SQLCLR Overview of SQLCLR objects, internals, security, reliability, troubleshooting, coding considerations and best practices. Wednesday, Oct 20 |
.jpg) | SQL Server Clients Overview of SQL Client, Client APIs, Object-Relational APIs, troubleshooting and tracing. Monday, Oct 18 |
.jpg) | XML Overview of SQL XML functionality, the XML data type, using XML and relational types, XML Schema support, XQuery, and performance considerations. Monday, Oct 18 |
 | Consistency Checking (Part 2) Overview of how to interpret CHECKDB output, understanding how repair works and recovering from various types of corruption. Monday, Oct 18 |
 | Consistency Checking (Part 1) Overview of consistency checking, including IO errors and what they mean, page protection options, and an overview of what DBCC CHECKDB does and best pratices associated with it. Monday, Oct 18 |
 | Log File Internals and Maintenance - Demo Video Demonstration video for the "Log File Internals and Maintenance" module. Monday, Oct 18 |
 | Log File Internals and Maintenance Overview of log file internals and maintenance, including an anatomy of a data modification, checkpoints and recovery, transaction log internals, recovery models, and log file maintenance. Monday, Oct 18 |
 | Data File Internals and Maintenance - Demo Video Demonstration video for the "Data File Internals and Maintenance" module. Monday, Oct 18 |
.jpg) | Data File Internals and Maintenance Overview of data file internals and maintenance, including coverage of physical layout, auto-grow, instant file initialization, shrink considerations and Tempdb. Monday, Oct 18 |
.jpg) | New Database Structures in SQL Server 2008 - Demo Video Demonstration video for the "New Database Structures in SQL Server 2008" module. Monday, Oct 18 |
.jpg) | New Database Structures in SQL Server 2008 Overview of new database structures in SQL Server 2008 including data compression, sparse columns and FILESTREAM. Monday, Oct 18 |
.jpg) | Database Structures - Demo Video Demonstration video for the "Database Structures" module. Monday, Oct 18 |
.jpg) | Database Structures Overview of database structure internals, including records, pages, extents, allocation bitmaps, IAM chains and allocation units. Monday, Oct 18 |
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
