How to Cheat at Securing SQL Server 2005


  • Mark Horninger, A+, Net+, Security+, MCSE+I, MCSD, MCAD, MCDBA, MCTS, MCITP, MCPD, President of Haverford Consultants, Adjunct Professor, Kaplan University, Havertown, PA, USA

The perfect book for multi-tasked IT managers responsible for securing the latest version of SQL Server 2005. SQL Server is the perfect product for the How to Cheat series. It is an ambitious product that, for the average SysAdmin, will present a difficult migration path from earlier versions and a vexing number of new features. How to Cheat promises help in order to get SQL Server secured as quickly and safely as possible.
View full description


System administrators running SQL Server or Windows environments and looking for an updated concise guide to the product.


Book information

  • Published: September 2007
  • Imprint: SYNGRESS
  • ISBN: 978-1-59749-196-9

Table of Contents

1: Introduction: Security Why Worry about It?2: Surface Area Reduction3: Roles4: Authentication5: Granular Access6: Schemas7: Password Policies8: SQL Agent Roles9: Administrative Roles10: Auditing Triggers11: Data Encryption12: Securing Reporting/Analysis Services