I've been asked to identify the architecture differences between Microsoft SQL Server 2005 and 2012. I've been pointed out to http://technet.microsoft.com/en-us/library/bb545450.aspx but I haven't seen anything talking about the architecture.

So what are the differences? I'm specially interested on security-related differences.


There are a number of them, a lot of articles on the topic if you have google at it.

Some of them:

  • Default Schema for Windows Groups

    • User Defined Server Roles
    • Enhancments to Auditing
    • User Contained Databases, authentication without logins.
    • TDE - Transparent Data Encryption
    • Hashing Functions - improved.

Not the answer you're looking for? Browse other questions tagged or ask your own question.