Tag: SQL Server

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

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

• How to Create Temporary Symmetric Keys

  

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

  Temporary symmetric keys in SQL Server behave similar to temp tables. In particular, they are stored in tempdb and automatically go away at the end of the session. Make sure however that you do not get caught creating a non-recreatable temporary symmetric key…

  [more…]