Packt is pleased to announce the publication of Microsoft SQL Server 2012 Security Cookbook, a new book that helps to secure SQL Server Analysis Services (SSAS) and Reporting Services (SSRS). Readers will learn to master techniques for data and code encryption, user authentication and authorization, denial-of-service attacks and SQL Injection.
About the Author
Rudi Bruchez: Rudi Bruchez is an Independent Consultant and Trainer based in Paris, France. He has 15 years of experience with SQL Server. Since 2006, he has been providing consulting and audits as well as SQL Server training. He has co-authored one of the best-selling books about the SQL language in French, which was published in 2008 and is the only French book about SQL Server optimization.
The book starts with installing and securing the SQL Server with recipes such as managing service SIDs, configuring a firewall for SQL Server access and encrypting the session by SSL. Using cipher algorithms, SQL developers will learn about symmetric keys, asymmetric keys and certificates, which can be used to encrypt data or sign data and modules.
The Microsoft SQL Server 2012 Security Cookbook addresses internal security such as creating logins to connect to SQL Server and grant privileges to secure objects on the server or inside the database. Developers will learn to monitor SQL Server logs and use DML and DDL trigger for auditing. They will be able to use a SQL or Web Application Firewall, and manage object ownership and protect data through views and stored procedures.
Essential chapters covered in this book are:
- Chapter 1: Securing Server and Network
- Chapter 2: Authentication and User Privilege
- Chapter 3: Protecting the data
- Chapter 4: Data and code encryption, and securing code
- Chapter 5: Fighting Attacks and Injection
- Chapter 6: Securing tools and high availability
- Chapter 7: Auditing and Compliance
- Chapter 8: Securing Business Intelligence
Packt has also published other Microsoft SQL server related titles:
- Microsoft SQL Server 2012 Performance Tuning Cookbook (July 2012).
- Microsoft SQL Server 2012 Integration Services: An Expert Cookbook (May 2012).
- Microsoft SQL Server 2008 R2 Master Data Services (July 2011).
About Packt Enterprise
All Microsoft books are Published by Packt Enterprise. Packt Enterprise is a publishing division of Packt Publishing designed to serve the information needs of IT Professionals in the Enterprise space. Packt Enterprise publishes books on Microsoft, IBM, Oracle, Citrix, Java, Amazon, and SAP among other technologies.
Over 70 practical, focused recipes to bullet-proof your SQL Server database and protect it from hackers and security threats Practical, focused recipes for securing your SQL Server database Master the latest techniques for data and code encryption, user authentication and authorization, protection against brute force attacks, denial of service attacks, and SQL Injection, and more A learn by example recipe based approach that focuses on key concepts to provide the foundation to solve real world problems In Detail In 2011, a big corporation suffered a 23-day network outage after a breach of security that allowed the theft of millions of registered accounts on its gaming network. A month later, hackers claimed in a press release to have stolen personal information of 1 million users by a single SQL injection attack. In these days of high-profile hacking, SQL Server 2012 database security has become of prime importance “Microsoft SQL Server 2012 Security Cookbook” will show you how to secure your database using cutting-edge methods and protect it from hackers and other security threats. You will learn the latest techniques for data and code encryption, user authentication and authorization, protection against brute force attacks, denial-of-service attacks, and SQL Injection, securing business intelligence, and more. We will start with securing SQL Server right from the point where you install it. You will learn to secure your server and network with recipes such as managing service SIDs, configuring a firewall for SQL Server access, and encrypting the session by SSL. We will then address internal security: creating logins to connect to SQL Server, and users to gain access to a database. We will also see how to grant privileges to securable objects on the server or inside the database.