Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
     
Email
Password
Register
"Scott Whigham is a first-rate trainer and SQL Server guru." - Brad McGehee, Sql-Server-Performance.com

View testimonials
LearnSqlServer2005.com Subscriber Videos
Watch our FREE SQL Server 2005 Video Tutorials

These free videos are just randomly chosen videos from our huge online library of SQL Server 2005 video tutorials and these are exactly the same videos you will get if you become a subscriber.
Want to get an email whenever we add new free videos?

Subscribe to our newsletter by creating a new account
FREE VIDEO #1: Building a Custom MMC for Use with SQL
Watch Free Video

Author: Scott Whigham

Skill level: 100 (Beginner)
Length (MM:SS): 08:00
File size: 9.0MB
Link to Subscriber-Only Version: here
Chapter: SQL Server 2005 Administration: Tools, Utilities and Common Tasks
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!

You can watch this video two ways:

Watch Free Video (watch a Flash-based version)

Download this Video (note: requires the TSCC codec)
 
FREE VIDEO #2: Pt. 1 - How to Synchronize Logins Between Two Servers
Watch Free Video

Author: Scott Whigham

Skill level: 400 (Intermediate - Advanced)
Length (MM:SS): 8:45
File size: 7.00MB
Link to Subscriber-Only Version: here
Chapter: Security in SQL Server 2005
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 series 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

You can watch this video two ways:

Watch Free Video (watch a Flash-based version)

Download this Video (note: requires the TSCC codec)
 


View a list of videos available to Subscribers >> Subscribe here
AddThis Social Bookmark Button
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners.
This site is not affiliated in any way with the Microsoft Corporation.
7/3/2008 10:09:15 PM