Abstract: This chapter is a good place to start since it answers the questions everyone has about how to license SQL Server, what the new features are, and it also includes a really nice 'history lesson' that shows the timeline of SQL Server since the 1980s.
Number of Videos: 11
Total Run Time: 2 hours and 17 minutes
|
Abstract: This chapter features a detailed breakdown of the installation and the concerns/changes for those who are upgrading from SQL Server 2000 and SQL Server 2005.
Number of Videos: 16
Total Run Time: 2 hours and 39 minutes
|
Abstract: Now that you have SQL Server installed, what tools are available? When should you use each? Also covered is in-depth coverage of how to configure your SQL Server for things like memory optimizations, CPU, and much more.
Number of Videos: 14
Total Run Time: 2 hours and 17 minutes
|
Abstract: This is a HUGE chapter - just huge - both in terms of the amount of training and in terms of the importance of the information. This covers how SQL Server databases work, each of the system databases, the types of databases, working with databases with multiple data and/or log files, configuring database options, index maintenance, partitions and partitioning, shrinking databases and it finally ends with a video on what you should do after you've upgraded a database
Number of Videos: 31
Total Run Time: 5 hours and 12 minutes
|
Abstract: This chapter covers login security and user security as well as principals, roles (server roles, database roles, application roles), and even deep subjects like impersonation, cross database ownership chaining and how security works with nested objects.
Number of Videos: 37
Total Run Time: 6 hours and 30 minutes
|
Abstract: This chapter covers topics that every DBA needs to be well-versed in. In this chapter we'll cover the types of SQL Server backups and recovery models, how to develop an efficient backup strategy, and taking backups via SSMS and TSQL. We'll also discuss the fundamentals of restoring and work through restoring a database, collection of databases and an entire server.
Number of Videos: 44
Total Run Time: 7 hours and 43 minutes
|
Abstract: In this chapter we will help to make your life as a DBA easier by lecturing and demonstrating the topic of automation for SQL Server. In this chapter we will cover the configuration of the SQL Server Agent and database mail as well as teach you how to create jobs, alerts and maintenance plans. We'll also run through several scenarios in which we create task-specific jobs you'll want to know how to do.
Number of Videos: 21
Total Run Time: 4 hours and 11 minutes
|
Abstract: This video chapter contains several topics that don''t belong to any specific chapter. In this chapter you''ll find videos that train on PowerShell, the Resource Governor and orphaned users. Also in this chapter your author will go over several methods for moving and copying databases, how to write effective policies and conditions as well as cover SQL CLR and FILESTREAM.
Number of Videos: 30
Total Run Time: 5 hours and 38 minutes
|
Abstract: What are some of the tools for monitoring available in SQL Server 2008? How can I customize these tools to best fit my needs? This chapter covers monitoring tools such as SQL Server Profiler, Performance Monitor, PAL, Data Collector, as well as DMVs and DMFs.
Number of Videos: 27
Total Run Time: 5 hours and 8 minutes
|
Abstract: Welcome to the final chapter in our SQL Server 2008 Database Administration course. This chapter is basically an overview with emphasis on availability and disaster recovery. This chapter will show you how to use the built in techniques that will help you achieve high availability. Topics covered in this chapter include Log Shipping, Database Mirroring, Clustering, and Replication. This chapter will teach you effective ways to recover from a failure.
Number of Videos: 21
Total Run Time: 4 hours and 5 minutes
|
Abstract: This chapter marks the beginning of the "updated" section of the course - it focuses on SQL Server 2008 R2, and was added (along with Chapter 12) to the course a while after the course had already existed as a SQL Server 2008 course. The main goal here is to point out the differences between 2008 and 2008 R2, and who these differences affect. Expect to learn about what has and hasn''t changed, changes to non-DBA areas, new licensing and editions, SQL Azure, StreamInsight, and much more.
Number of Videos: 3
Total Run Time: 23 minutes
|
Abstract: This is a short chapter, and will take you through the installation and upgrade processes for SQL Server 2008 R2. Scott covers new concepts like creating a slipstreamed installation disk, using SysPrep, and more. This chapter, unlike others, has a pre-requisite: you need to be familiar with the contents of Chapter 2 in this course before viewing this chapter!
Number of Videos: 1
Total Run Time: 3 minutes
|