Jul 162014
 
Partition Boundaries - Left or Right: That is the Question

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.

Jul 142014
 
How to Crack the Symmetric Keys in the Database Wide Open

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.