Published: November 2008 Writers: JC Cannon, Denny Lee
Contributors / Reviewers: Andy Roberts, Ayad Shammout, Dan Jones, Craig Gick, Jack Richins, Raul Garcia, Devendra Tiwari, Steven Gott, Al Comeau, Lara Rubbelke
Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling with compliance. The SQL Server 2008 Compliance Guidance white paper was written to help organizations and individuals understand how to use the features of the Microsoft® SQL Server® 2008 database software to address their compliance needs. This paper serves as an accompaniment to the SQL Server 2008 compliance software development kit (SDK), which provides sample code and guidance for understanding SQL Server 2008 compliance features and using them for developing solutions.
This paper is breaks down the main elements of:
-
Understanding Compliance
-
Implementing IT Controls with SQL Server 2008
-
Securing the Platform
-
Controlling Identity and Separation of Duties
-
Separation of Duties
-
Encrypting Database Data
-
Auditing Sensitive Operations
-
Using Policy-Based Management to Define, Deploy, and Validate Policy
As well, it contains a whole list of Helpful scripts and tips including:
-
Programming Interfaces to SQL Server
-
Ensuring Security Settings
-
Managing Separation of Duties
-
Managing Encryption Keys
-
Managing Auditing including a full end-to-end centralized Auditing project including reports
-
Managing Policy-Based Management Policies
For more information, please refer to the whitepaper Reaching Compliance.
You can also download the samples scripts, presentations, and tools for this guide.
About denny.lee
Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQL Customer Advisory Team (SQLCAT) - DW/BI Group. He has more than 13 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of "Professional Microsoft PowerPivot for Excel and SharePoint", “Professional Microsoft SQL Server Analysis Services 2008 with MDX”, “Professional Microsoft SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2009)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Blog (http://dennyglee.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
