Free SQL Server 2005 Database Administration Training Videos
To get an idea of the quality of the videos in our
SQL Server 2005 Database Administration training course, please view these free sample videos. One thing to note: these
videos have been formatted for web viewing (Flash) and the quality of the Flash video is not quite the
same as what you receive if you purchase the course. When you view the online video, click the "Download
this video" button - that video is the same quality as what you receive if you purchase the course.
FREE VIDEO #1: Building a Custom MMC for Use with SQL
 Skill level:
100 (Beginner)- Run Time:
08:00
- Instructor:
Scott Whigham
Description:
In this video tutorial, Scott will demonstrate to you how to build a custom Microsoft Mangement Console and customize it to fit your needs! Highlights from this video: - Launching your own custom MMC
- Adding and removing snap-ins to your console
- About the avaliable snap-ins
and more!
|
FREE VIDEO #2: Pt. 1 - How to Synchronize Logins Between Two Servers
- Skill level:
400 (Intermediate - Advanced)
- Run Time:
8:45
- Instructor:
Scott Whigham
Description:
One of the more confusing topics for people coming into SQL Server - even if you have a lot of experience with other database management systems like Oracle, DB2, MySQL, etc - is how to move a database from Server A to Server B (or Instance A to Instance B) and how to keep the logins in sync. This video, part 1 in our section on how to sync logins between servers in SQL Server, covers the scenario, the reason we need to know this, and gets into a little bit of SQL Server security architecture. Highlights from this video: - How to view the orphaned logins (those Without Login)
- How SIDs work as well as what sys.server_principals and sys.syslogins are
and much more
|
