Book Image

Microsoft SQL Server 2012 Security Cookbook

By : Rudi Bruchez
Book Image

Microsoft SQL Server 2012 Security Cookbook

By: Rudi Bruchez

Overview of this book

<p>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. <br /><br />"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.<br /><br />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.<br /><br />After having managed authentication through logins and users, we will assign privileges inside a database using permissions. We will then learn about symmetric keys, asymmetric keys and certificates, which can be used to encrypt data or sign data and modules with a choice of cipher algorithms, as well as creating hash representations of data.<br /><br />Then we will cover methods to protect your database against brute force attacks, denial-of-service attacks, and SQL Injection. Finally we will learn about auditing and compliance and securing SQL Server Analysis Services (SSAS) and Reporting Services (SSRS).</p>
Table of Contents (14 chapters)
Microsoft SQL Server 2012 Security Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

About the Reviewers

Raunak T Jhawar is a Computer Engineer by vocation and works as a Business Intelligence and Data Warehousing professional. He is proficient with Microsoft Technologies such as SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.

In his spare time, he blogs and also enjoys driving his car.

Nauzad Kapadia is an independent professional and founder of Quartz Systems, and provides training and consulting services for the entire Microsoft .NET and SQL Server stack. Nauzad has over 17 years of industry experience and has been a regular speaker at events such as TechED, DevCon, DevDays, and user group events. Nauzad has been a Microsoft Most Valuable Professional (MVP) for six years on technologies ranging from C# and ASP.NET, to SQL Server.

Whenever he is not working on his computer, he enjoys rock music, photography, and reading.

Allan Mitchell is the joint owner of Copper Blue Consulting Ltd. in the U.K. He has written books on SSIS in both SQL Server 2005 and SQL Server 2008. He has been a Technical Editor on other books about Replication in SQL Server as well as Master Data Services and DBA duties.