Category: General

• 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…]

• How to Change a SQL Login’s Password

  

  2014-04-04 - Fundamentals, General, Security

  ALTER LOGIN can be used to change the password of a SQL Login. Read on to see the required permissions and what you need to do to change your own password.

  [more…]

• The Index Allocation Map (IAM)

  

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

  SQL Server tracks the pages that belong to an allocation unit through special index allocation map pages, also called IAM pages. Each IAM page covers a single GAM-interval of the database file. All IAM pages of a single allocation unit together build an IAM-chain. Read on to find out more.

  [more…]

• Salt – Preventing Rainbow Attacks against Password Stores

  

  2014-03-31 - Cryptographic Terminology, Cryptography, General, Security, Series

  What is a Salt Value and how does it help to protect the stored passwords of your application’s users from attacks involving Rainbow Tables? Read on to find out now.

  [more…]