Microsoft SQL Server 2012 Security Cookbook: Over 70 Practical, Focused Recipes to Bullet-proff You SQL Server Database and Protect It from Hackers and Security Threats - Softcover

Bruchez, Rudi

Softcover

ISBN 10: 1849685886 ISBN 13: 9781849685887

Publisher: Packt Pub Ltd, 2012

Synopsis

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.

About this title

About the Author

Rudi Bruchez is an Independent Consultant and Trainer based in Paris, France. He has 15 years of experience with SQL Server. He has worked as a DBA for CNET Channel, a subsidiary of CNET, at the Mediterranean Shipping Company (MSC) headquarters in Geneva and at Promovacances, an online travel company in Paris. Since 2006, he has been providing consulting and audits as well as SQL Server training. As SQL Server is evolving into a more complex solution, he tries to make sure that developers and administrators keep mastering the fundamentals of the relational database and the SQL language. 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. He can be contacted at www.babaluga.com.

Edition details

• Publisher: Packt Pub Ltd
• Publication date: 2012
• ISBN 10: 1849685886
• ISBN 13: 9781849685887
• Binding: Paperback
• Language: English
• Number of pages: 307