Tag: SQL Server

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

• Cryptographic Hash Functions

  

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

  Hash functions calculate a fixed length binary digest of a document. Read on to see what additional requirements turn an ordinary hash function into a cryptographic hash function and what use cases require the use of cryptographic hash functions.

  [more…]

• Certificates and the Chain of Trust

  

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

  Certificates are containers for asymmetric encryption keys that can be used to establish a chain of trust between communicating parties. Read on to see how this works in practice.

  [more…]

• The Allocation Unit

  

  2014-03-26 - DMVs & CVs, General, Series, SQL Server Internals, Storage Wednesday

  SQL Server groups all pages that belong to a single partition of a single index or heap into logical units. These units are called allocation units. Read on to learn about the different types of allocation units and discover how to identify the allocation units belonging to a table.

  [more…]