Chapter 5. Security in SQL Server 2008

Rob Walters and Leonard Lobel

With the growing concern about personal data protection and the proliferation of computer viruses, developing a methodology for secure computing continues to be a vital task for Microsoft. Back in 2003, Microsoft created the Trustworthy Computing initiative, which described the advances that needed to be made for people to feel more comfortable using devices powered by computers and software. (The initiative can be found at http://www.microsoft.com/mscorp/twc/twc_whitepaper.mspx.) From this initiative, Microsoft SQL Server 2008 leverages what is known as the Security Framework, shown in Figure 5-1.

Figure 5-1. Security Framework in SQL Server 2008

Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.