Tag: SQL Server

• The Shared Global Allocation Map (SGAM)

  

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

  Discover how SQL Server tracks mixed extents containing free pages using a Shared Global Allocation Map made up of one SGAM page per GAM Interval.

  [more…]

• The SQL Server Encryption Hierarchy

  

  2014-04-20 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how in SQL Server the different encryption keys can build a complex encryption hierarchy in which one key protects the next.

  [more…]

• Auto Fix Orphaned Users

  

  2014-04-18 - General, Security

  To auto fix orphaned users safely is a surprisingly complex task. But, as demonstrated in this article, it is possible if you follow a handful of rules.

  [more…]

• The Global Allocation Map (GAM)

  

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

  SQL Server uses the Global Allocation Map (GAM) to catalog if an extent is allocated or not. In a 7988-byte bitmap each extent is associated with a single bit to convey that information. Read on to get all the details.

  [more…]

• Scripting All Logins on a SQL Server Instance

  

  2014-04-14 - General, Queries, Security

  Scripting all logins on a SQL Server instance can be helpful e.g. when setting up a test or development environment. Read on to see an example query for just this purpose.

  [more…]