We've filmed a wide variety of SQL Server tutorials and videos to help you get started with database administrator tasks. Here's a sample one about using Performance Monitor: http://tutorials.sqlserverpedia.com.s3.amazonaws.com/SQLServerPedia-20090112-Perfmon.mp4

Here's a list of just some of the video tutorials scattered throughout the wiki:

Notes or Tutorials on Performance Tuning

• SQL Server Performance Baseline Tutorial - this video training shows why you should use Perfmon to establish a clear performance baseline on your servers.
• SAN Performance Tuning with SQLIO - learn how to use this free download from Microsoft to test your storage throughput.
• SQL Server Profiler Tutorial - we show how to get started with Profiler and trace your slow-running queries.
• Deciphering SQL Server Profiler Traces - we show four examples of how to interpret the results you get in Perfmon and Profiler to track down the performance bottlenecks.
• SQL Server Index Maintenance Video - we show how to use T-SQL scripts in SQL Server Management Studio to quickly identify an easy-to-fix performance bottleneck: fragmented indexes.
• Videos on How to Write a SQL Server Performance Report - after mastering Perfmon and Profiler, pick up some advanced tips and tricks in these videos. Learn how to write a report for managers explaining where an application's bottlenecks are and how to fix them.
• SQL Server Perfmon Monitoring Tutorial - Perfmon helps you find your SQL Server bottlenecks like CPU, memory, disk and network.

Free SQL Server Tutorial Videos

• Data Mining Tutorial Video - Brent Ozar uses the StackOverflow database to show you how to get started with data mining in Excel 2007 and SQL Server Analysis Services.
• Backup & Recovery Tutorial - in this hands-on video, we explain the differences between full backups, differential backups, log backups, database mirroring, and SAN snapshot replication.
• Filegroup Backup Tutorial Video - want your restore to finish earlier to get your boss off your back? We explain how to restore your databases one part at a time to get some tables online faster.
• SQL Server Consolidation Training Video - consolidating your SQL Servers saves money and can make management easier. We talk about the risks, payoffs and pitfalls.
• SQL Server Management with a Central Management Server - SQL Server Management Studio 2008 introduces the concept of a Central Management Server, which allows all DBAs to have the same server list, to run queries against groups of servers, and to apply Policy-Based Management across those servers.

Free Notes or Tutorials on Getting Started with SQL Server

• SQL Server Management Studio Express Tutorial - learn how to manage your SQL Servers with this free tool from Microsoft.
• Maintenance Plans or T-SQL Scripts for Backups? - most database administrators get started backing up their databases using SQL Server Maintenance Plans. In this video, Brent Ozar explains why advanced DBAs prefer writing their own T-SQL scripts for maintenance.

Free SQL Server Tutorials in Podcast Form

If you have an iPod, Zune or other audio/video player, you can get our latest tutorial videos sent to you for free automatically, as soon as they come out. We offer podcast feeds in the following formats:

• MP4 (Apple) Video Feed for SQL Server Podcasts
• WMV (Microsoft) Video Feed for SQL Server Podcasts
• MP3 Audio-Only Feed for SQL Server Podcasts
• Zune Video One-Click Subscribe
• Zune Audio One-Click Subscribe

SQL Server Tutorials by Kevin Kline

SQL Server 2005 Memory Troubleshooting

Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2008 memory pressure? Kevin lays out your options.

• http://sqlserverpedia.com/blog/sql-server-2005/kevin-kline-on-sql-server-memory-troubleshooting/