Tag: SQL Server

• OPEN SYMMETRIC KEY – Avoid the NULL Ciphertext Trap

  

  2014-07-11 - Cryptography, General, Security, Security Pitfalls, T-SQL Statements

  Don’t get caught in this nasty trap that will cause all your encrypted data to be wiped out. Discover how to use the OPEN SYMMETRIC KEY statement correctly to protect yourself (and your data) from this ugly surprise.

  [more…]

• The sys.dm_db_database_page_allocations DMF

  

  2014-07-09 - General, Series, SQL Server 2012, SQL Server Internals, Storage Wednesday

  Are you looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a particular table (or even all tables in a database).

  [more…]

• Security Blues [T-SQL Tuesday #56 – Assumptions]

  

  2014-07-08 - General, Security

  When it comes to security related investments, we often make excuses why we should not invest now. But think about the impact a random breach can have., not only on you but on your clients, the very people that trusted you.

  [more…]

• HASHBYTES: How to Calculate a Cryptographic Hash in T-SQL

  

  2014-07-07 - Cryptography, General, Security

  The HASHBYTES function provides a simple way to calculate cryptographic hash values in T-SQL. Read on to learn how to use this function and discover its two limitations.

  [more…]

• Intermediate Index Pages in SQL Server

  

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

  SQL Server stores indexes in B+ Tree format on disk. Each node is represented by a SQL Server page. The actual rows are stored in data pages while the index structure resides in intermediate index pages. Read on to find out more.

  [more…]