SQL Server Tutorials

From SQLServerPedia

Jump to: navigation, search

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

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

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:

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.