Browse by Tags

• Logins

• Fixing Orphaned Users

  This is a problem that plagues DBAs everywhere. When you restore a database, you run the risk of orphaning the users in the database. All users are linked via a SID to a login and if you have SQL Server logins, who’s SIDs are managed by SQL Server, Read More... Posted Friday, October 17, 2008 11:32 AM by ejohnson2010 | 3 Comments Filed under: SQL Server 2008, Security, Logins

• Application Roles: You’ve seen them, but have you really ever used them?

  They have been around forever, but have you really ever implemented Application Roles in SQL Server? For that matter, do you really know what they are and how to use them? In this short tip, I hope to explain just that. First off, we need to talk briefly Read More... Posted Wednesday, October 08, 2008 8:48 AM by ejohnson2010 | 3 Comments Filed under: SQL Server 2008, Security

• Scripting SQL Server Logins

  You ever find yourself with the need to copy SQL Server logins from one server to another? Maybe you are setting up a failover site, building a replacement server, setting up a reporting instance, or maybe you just want to backup the logins just in case. Read More... Posted Tuesday, September 30, 2008 2:58 PM by ejohnson2010 | 5 Comments Filed under: SQL Server 2008, Security, Logins