Free Training Videos from LearnItFirst.com: Free SQL Server Training Video - Pt. 1 - How to Synchronize Login s Between Two Servers

Free Training Videos from LearnItFirst.com

Every time we post a new free training video, we'll post it here as well. Add this feed into your RSS newsreader so that you'll be notified for each free video. You'll find videos on SQL Server 2005, Windows 2003, Windows Vista, Exchange Server, .NET, Visual Studio, ASP.NET and much, much more

Tuesday, November 17, 2009

Free SQL Server Training Video - Pt. 1 - How to Synchronize Login s Between Two Servers

This Free SQL Server Video Tutorial comes from LearnItFirst.com's online training videos library

Free Tutorial Video: Pt. 1 - How to Synchronize Logins Between Two Servers

More info about this video:

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

Related Links:

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link

<< Home

About Me

Name: LearnItFirst.com

Location: Dallas, Texas, United States

LearnItFirst is a video training company focused on providing training for IT professionals. Since 2004, we have delivered more than 150,000 hours of classroom-quality training all delivered via our website (http://www.learnitfirst.com). LearnItFirst is the brainchild of Scott Whigham and today Scott's database and programming-related training videos are still some of our most popular courses. Together with fellow trainer Grant Moyle, Scott launched LearnItFirst.com in 2004 as a way to provide great training in a convenient format at an affordable price.