SQL Server provides a rich set of security features that allow customers to satisfy their security goals. Everything from encrypting sensitive data to recording all activity within a particular database is easily attainable with the features introduced in 2008. However, one topic that many struggle with is in the area of Separation of Duties, sometimes called Role Separation. The subject frequently comes up when facing regulatory compliance, usually in the form of “How do I prevent my administrators from seeing my data?” While SQL Server does not provide a packaged solution to facilitate Separation of Duties, it does provide functionality that allows Separation of Duties to be achieved. Come to this session to understand how to leverage the functionality available in SQL Server implemented through free community tools and achieve all of your compliance goals.
Lara Rubbelke brings her passion for architecting, implementing and improving SQL Server solutions to the community as a Data Platform Technology Specialist for Microsoft. This is a role that is a pre-sales role for SQL Server. Her expertise involves both OLTP and OLAP systems, data management, performance tuning, encryption, ETL, and the Business Intelligence lifecycle. Compliance and configuration management are near and dear to her heart. She is an active board member and advocate of the Minnesota chapter of PASS (Professional Association for SQL Server) and regularly delivers technical presentations at local, regional and national conferences, user groups and webcasts. Notably, Lara has presented at Tech Ed, the PASS Summit, the Minneapolis SQL Server Launch, and delivered numerous webcasts on MSDN and TechNet. Lara authored a number of the Microsoft whitepapers and was a contributing author of “Expert SQL Server 2005 Development” (lead author Adam Machanic).
[amazon_link asins=’1118024303,1522021140,0198719795,1119240239,B01AS2T0ZA’ template=’ProductCarousel’ store=’digieboodown-21′ marketplace=’UK’ link_id=’5d5c766c-849a-11e7-bdc2-1b7420a1b569′]