Microsoft SQL Server 2012 Security Cookbook

Over 70 practical, focused recipes to bullet-proof your SQL Server database and protect it from hackers and security threats with this book and ebook.

Microsoft SQL Server 2012 Security Cookbook

Rudi Bruchez

Over 70 practical, focused recipes to bullet-proof your SQL Server database and protect it from hackers and security threats with this book and ebook.
Packt Subscription
$5.00
$9.99/m after first month
eBook
$5.00
RRP $29.99
Save 83%
Print + eBook
$49.99
RRP $49.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$5.00
$5.00
$49.99
$9.99/m after first month
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Subscribe Now

Frequently bought together


Microsoft SQL Server 2012 Security Cookbook Book Cover
Microsoft SQL Server 2012 Security Cookbook
$ 29.99
$ 5.00
Developing Windows Store Apps with HTML5 and JavaScript Book Cover
Developing Windows Store Apps with HTML5 and JavaScript
$ 14.99
$ 5.00
Buy 2 for $10.00
Save $34.98
Add to Cart

Book Details

ISBN 139781849685887
Paperback322 pages

Book Description

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.

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.

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).

Table of Contents

What You Will Learn

  • Start securing your database right from the first step when you install it
  • Protect your database against brute force attacks, denial-of-service attacks, and SQL Injection
  • Secure SQL Server Analysis Services (SSAS) and Reporting Services (SSRS)
  • Use a SQL or Web Application Firewall
  • Perform user authentication and authorization
  • Manage object ownership and protect data through views and stored procedures
  • Create and use certificates, and symmetric and asymmetric encryption keys
  • Authenticate stored procedures by signatures
  • Monitor SQL Server logs and use DML and DDL trigger for auditing
  • Configure SQL Server database audit and manage audit resilience after a crash

Authors

Table of Contents

Book Details

ISBN 139781849685887
Paperback322 pages
Read More

Read More Reviews

Recommended for You

Developing Windows Store Apps with HTML5 and JavaScript Book Cover
Developing Windows Store Apps with HTML5 and JavaScript
$ 14.99
$ 5.00
Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 29.99
$ 5.00
SQL Server 2012 with PowerShell V3 Cookbook Book Cover
SQL Server 2012 with PowerShell V3 Cookbook
$ 35.99
$ 5.00
Getting Started with SQL Server 2012 Cube Development Book Cover
Getting Started with SQL Server 2012 Cube Development
$ 29.99
$ 5.00
Mastering SQL Server 2014 Data Mining Book Cover
Mastering SQL Server 2014 Data Mining
$ 29.99
$ 5.00
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide Book Cover
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
$ 29.99
$ 5.00