SQL Server 2012 Label Security Toolkit and Free eBook Second DRAFT Preview Now Available!

The SQL Server 2012 investments brings additional flexibility, usability for auditing and security manageability across SQL Server environments making it even easier for organizations to meet compliance policies.Key CapabilitiesEasily manage permissions around data access with User-Defined Server Roles.Increase manageability and decrease complexity of database schema through Default Schema for Groups.Control database access to deployed applications […]

The SQL Server 2012 investments brings additional flexibility, usability for auditing and security manageability across SQL Server environments making it even easier for organizations to meet compliance policies.

Key Capabilities

  • Easily manage permissions around data access with User-Defined Server Roles.
  • Increase manageability and decrease complexity of database schema through Default Schema for Groups.
  • Control database access to deployed applications while improving manageability through Contained Database Authentication.
  • Help ensure compliance and increase manageability related to auditing with audit resilience, filtering and user-defined audit.

Microsoft has published a documents the Label Security Toolkit that provides tools and techniques for using Microsoft SQL Server (versions 2005 through 2012) to implement row-level security (RLS) and cell-level security (CLS) based on security labels.

The major components of the Toolkit are:

  • The Label Policy Designer application
  • Documentation
  • Examples showing the implementation of row- and cell-level security in different scenarios

The toolkit complements the whitepaper available for download here. And, SQL Server 2012 Security Datasheet (PDF) here, and SQL Server 2012 Security Overview (PPTX) can be downloaded here.

Bonus: A free e-Book for Microsoft SQL Server 2012 entitled "Introducing Microsoft SQL Server 2012," (second DRAFT preview) is now available.

Part I Database Admistration (Ross's part)

  1. Denali Editions and Enhancements
  2. High Availability and Disaster Recovery Enhancements
  3. Scalability and Performance
  4. Security Enhancements
  5. Beyond Relational

Part II Business Intelligence Development (Stacia's part)

  1. Integration Services
  2. Data Quality Services
  3. Master Data Services
  4. Analysis Services and PowerPivot
  5. Reporting Services

The first draft of the eBook is available here for download, and second draft is here.