Category: General

• How to Overflow a BLOB Value

  

  2014-08-06 - General, Series, SQL Server Internals, Storage Wednesday

  It is advertised as 2 GB, but what is actually the largest number of bytes that can be stored in a SQL Server BLOB value? Read on to find out now.

  [more…]

• Temporary Symmetric Key Conflicts

  

  2014-08-04 - Cryptography, General, Security, Temporary Objects

  Temporary symmetric keys are a great idea. However, SQL Server’s current implementation falls apart based on a requirement that makes them all but usable.

  [more…]

• What, You Are Not Using Two-Factor Authentication?

  

  2014-08-02 - General, Passwords, Security

  If you are not using two-factor authentication, your data is at risk. Read on to find out exactly why you should enable two-factor authentication now.

  [more…]

• Page Type 4 – The Mysterious TEXT_TREE_PAGE

  

  2014-07-30 - General, Series, SQL Server Internals, Storage Wednesday

  What purpose have pages of type TEXT_TREE_PAGE? Discover how SQL Server uses these pages to build positional B+Tree indexes on large LOB values.

  [more…]

• The Unexpected Scope of Temporary Symmetric Keys

  

  2014-07-28 - Cryptography, General, Security, Temporary Objects

  If you think temporary symmetric keys and temporary tables have the same scope, you will be in for a surprise. Read on to discover the truth.

  [more…]