Tag: SQL Server

• How to Re-Create a Login with only a Hashed Password

  

  2014-04-13 - General, Security

  To re-create a login on a different SQL Server instance while preserving the password you can use the CREATE LOGIN statement with the hashed password. Read on for a detailed explanation.

  [more…]

• How to Fix Orphaned Users in SQL Server

  

  2014-04-11 - General, Security

  To access a database in SQL Server, a login needs to have an associated user in that database. Read on to see how that association is implemented and what you need to do to repair it if it breaks.

  [more…]

• The GAM Interval and GAM Extents

  

  2014-04-09 - General, Series, SQL Server Internals, Storage Wednesday

  What is a GAM extent in SQL Server? What is a GAM Interval and how big is it really? Read on now to get the answers to these questions and see why a GAM interval is not 64000 extents.

  [more…]

• LOGINPROPERTY – Getting to know your SQL Logins even more

  

  2014-04-07 - DMVs & CVs, General, Security, Security

  LOGINPROPERTY is a SQL Server catalog function that can be used to query a total of twelve properties for SQL Logins not even revealed by the sys.sql_logins catalog view. Read on to find out how to use LOGINPROPERTY and which properties it can return.

  [more…]

• sys.sql_logins – Getting to know your SQL Logins

  

  2014-04-06 - DMVs & CVs, General, Security, Security

  The sys.sql_logins catalog view can be used to retrieve additional information on SQL Logins that is not included in the sys.server_principals catalog view. Read on to find out what additional information is revealed by this catalog view.

  [more…]