Fun with execution context switching

Having multiple users each owning various objects is commonplace in the database world. When one user wants to give access of their object to another user — that’s when administration of databases gets rather interesting.   Consider the following SQL Server 2000 experience:  User Barney has a table of Rock and Roll hits User Fred… Read more

Encryption 101

With the release of SQL Server 2005 comes a plethora of new security related features.  Over time we will cover these in detail.  To start, let’s look at the world of encryption. When it comes to protecting data we can take a mile high view of this problem and determine that we need to protect… Read more