Tag: SQL Server

• Page Type 3 – LOB Data Pages explained

  

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

  LOB data values in SQL Server are stored in separate allocation units in pages of type TEXT_MIX_PAGE. Read on and discover when these pages are used and how you can find out if your tables contain any pages of that type.

  [more…]

• How to Create Two Identical Symmetric Keys

  

  2014-07-21 - Cryptography, General, Security

  SQL Server provides only one way to re-create a symmetric key multiple times. Read on to find out about the necessary extension to the CREATE SYMMETRIC KEY statement.

  [more…]

• Debunking Symmetric Key Recreate-Ability

  

  2014-07-18 - Cryptography, General, Security, Security Misconceptions

  Do you think you can recreate a symmetric key that is protected by a certificate, by just using that same certificate? You might be in for a big surprise…

  [more…]

• Partition Boundaries – Left or Right: That is the Question

  

  2014-07-16 - Fundamentals, General, Series, SQL Server Internals, Storage Wednesday

  Do you know the difference between a RANGE LEFT and a RANGE RIGHT partition function? Read on and discover a unique query to determine the actual partition a row is stored in. With this query you can quickly confirm your RANGE-assumption or find out where you got it wrong.

  [more…]

• How to Crack the Symmetric Keys in the Database Wide Open

  

  2014-07-14 - Cryptography, DMVs & CVs, General, Security, Security, SQL Server Internals

  Did you always want to get to the root of symmetric key encryption in SQL Server and actually decrypt a protected symmetric key? In some circumstances this can actually be done. Find out how to do this now.

  [more…]