LearnItFirst's Blog on Tumblr
LearnItFirst creates training videos 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).
Free Video: Pt. 1 - How to Synchronize Logins Between Two Servers 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
