Understanding SQL Server 2008 Security
Play Understanding SQL Server 2008 Security
Security is one of the critical features of a database engine, protecting the enterprise against myriad threats. Over the years, SQL Server has undergone major transformations when it comes to security, some fundamental and some really advance capabilities for data protection. In this session, we shall focus on advance security features like data encryption, keys & certificates management, auditing & Execution context. We shall also do a quick recap of major security framework improvements from SQL Server 2000 to SQL Server 2005 including user/schema separation to set the base for discussing advance security features in SQL Server 2008. We shall conclude the session by focusing on how some of the security features can be used in application design and development. At the end of the session, developers should have a solid understanding of the security framework in SQL Server. 2008 and how to leverage those features in your application.