SQL Server Tutorials

Get in for nothing, get access to everything: we've got free SQL Server Tutorials in videos here at SQLServerPedia to explain how to peform common SQL Server tasks.

• SQL Server Management Studio Express Tutorial - learn how to manage your SQL Servers with this free tool from Microsoft.
• Backup & Recovery Tutorial Video - we explain the differences between full backups, differential backups, log backups, database mirroring, and SAN snapshot replication.
• SQL Server Perfmon Monitoring Tutorial Video - Perfmon helps you find your SQL Server bottlenecks like CPU, memory, disk and network.
• Index Maintenance Tutorial with SQL Server Management Studio 2008 - Brent shows how to use the new Central Management Studio feature in SSMS 2008 to find out which databases are suffering from index fragmentation.
• 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.

SQL Server Performance Tuning Tutorial Videos

• 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.

BI Training 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.
• Business Intelligence Training Videos - Solid Quality Mentors has put together a series of video tutorials on SQL Server Analysis Services, SQL Server Integration Services and SQL Server Reporting Services.

Our Podcasts: Free Notes or Tutorials To Go!

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

Free Notes or Tutorials for Advanced DBAs

• SQL Server Consolidation Tutorial - 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 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.
• Configuration Management Database Tutorial - we explain start to finish how to build a CMDB.

__