We speak at SQL Server user groups and events, and we record my presentations for you to watch later. Pop some popcorn and turn down the lights….
Buck Woody and Brent Ozar (channeling his inner Richard Simmons)
SQL Server Performance Tuning Tutorials
- How to Prove it’s a SAN Problem – Brent Ozar shows you how to get down with disk testing tools.
- How to Use Denali Windowing Functions – Speed up your aggregates and reports Jeremiah Peschka.
- Five Ways to Fight Blocking – Kendra Little gives you big picture ways to get ahead of those blocking chains.
- Completely Legal Performance Enhancements - Jeremiah Peschka discusses persisted computed fields, indexed views, 64-bit OS’s, and more.
- Index Tuning for SQL Server – learn how to add, remove, or monitor indexes.
- Performance Monitor 101 – explains how to use Perfmon and Profiler.
- SQL Server Storage at the Terabyte Level – files, filegroups, solid state drives, and more.
- Lose Waits Fast with Wait Stats – in which Brent dresses up as Richard Simmons to explain how to use wait stats and free tools like sp_WhoIsActive, SQLdiag, and SQLnexus.
- T-SQL Tuning for Formula 1 Race Car Drivers – they have more in common than you might think.
- Playing Doctor with the DMVs- how to find hyperactive files & filegroups, catch potential partitioning pitfalls, sniff out heaps, and use a Central Management Server to triage your servers.
Jeremiah gives you moar code!
Microsoft Certified Master of SQL Server Training Videos
Want to be come a Microsoft Certified Master of SQL Server? Get started with your training for free courtesy of videos Brent recorded for Microsoft. On each page, you can also download the WMV/iPod/etc files for playing later, too:
- Virtualization – how VMware and Hyper-V change CPU, memory, and monitoring.
- Storage: Core Concepts – covering the types of drives (magnetic vs SSD), how they’re attached to our servers, and how this influences where we store SQL Server data and logs.
- Storage: Guidelines – about RAID levels, shared vs dedicated storage, and general best practices for SQL Server storage.
- Storage: DAS vs SAN Architecture – we explain what storage pathing is and why it’s so important.
- Storage: Testing and Monitoring – how to get started monitoring your existing SQL Servers and how to test before you even install SQL.
- Clustering: Introduction – the concepts behind active/passive (single-instance) and active/active (multi-instance) clustering.
- SQLOS – learn how NUMA and hyperthreaded CPUs affect the way SQL Server schedules work.
- Multi-Server Management – covering the Central Management Server, Management Data Warehouse, Utility Control Point, and Data-Tier Applications.
- Policy-Based Management – the features and limitations of PBM and how to expand it.
- Policy-Based Management Demos – my GUI, let me show you it.
- Baselining and Benchmarking – how to use Perfmon and Profiler, which counters to monitor, and how to slice and dice Profiler results.
SQL Server DBA Tutorial Videos
- Virtualization and SAN Basics for DBAs – these two technologies can really impact your SQL Server performance.
- BLITZ! SQL Server Takeovers – you’re sitting in your cubicle, minding your own business, when someone hands you a SQL Server. Learn how to take it over quickly to assess risks within a matter of minutes.
- SP_Who Replacements – learn better ways to find out what’s going on inside your SQL Server with sp_WhoIsActive, DMVs, and more.
- SQL Server Consolidation – before you pile lots of instances or databases onto a single physical server, learn the top five things you should know before undertaking a consolidation project.
- SQL Server Disaster Recovery Basics – learn the pros and cons of log shipping, database mirroring, etc.
- The Mystery of Query Timeouts – Kendra Little shows you how to triage query timeouts like a pro.
