Protecting SQL Server Data



Download free course Protecting SQL Server Data, pdf file on 232 pages by John Magnabosco.
In Protecting SQL Server Data, John Magnabosco demonstrates how sensitive data, stored in SQL Server, can be protected using an efficient and maintainable encryption-based data architecture.

He explains how to assess and categorize data elements according to sensitivity, regulate access to the various categories of data using database roles, views and stored procedures, and then how to implement a secure data architecture using features such as cell-level encryption, transparent data encryption, one-way encryption, obfuscation, and more.

The battle to secure personal and business data is a tough one, and the consequences of mishandling sensitive data can be severe. Even more damaging than the fines and lawsuits that can be result from non-compliance with regulations, is the loss of customer confidence that results when these breaches of security occur.

Database Administrators must use every weapon and strategy at their disposal in the "war" to protect their sensitive data from would-be hackers, phishers, rumor mongers and identity thieves. Encryption is one of the primary weapons with which this battle can be won.

Table of contents

  • Understanding Sensitive Data
  • Data Classification and Roles
  • Schema Architecture Strategies
  • Encryption Basics for SQL Server
  • Cell-Level Encryption
  • Transparent Data Encryption
  • One-Way Encryption
  • Obfuscation
  • Honeycombing a Database
  • Layering Solutions
  • Views and Functions Reference
  • The HomeLending database
Pages : 232
Size : 4.0 MB
File type : PDF
Downloads: 151
Created: 2022-02-03
License: For personal or educational use
Author(s): John Magnabosco
Protecting SQL Server Data

Others sql Tutorials

SQL queries Tutorial

SQL Server Internals: In-Memory OLTP

PostgreSQL for Beginners

Microsoft SQL Server Notes for Professionals

SQL Server Hardware

Others related eBooks about Protecting SQL Server Data

Oracle Database Notes for Professionals

Download free course Oracle Database Notes for Professionals, pdf file on 117 pages by Stack Overflow Community....

Graph Databases, 2nd Edition

Discover how graph databases can help you manage and query highly connected data. With thi..., download free Graph Databases tutorial in PDF (238 pages) created by ....

MySQL – Create Database free PDF

Download free course MySQL – Create Database free PDF, pdf file on 3 pages by tutorialkart.com....

Introduction to SQL

This tutorial is a brief overview about SQL language and free training document courses under 39 pages for beginners....

Tutorial Oracle Database 11g: SQL Fundamentals in PDF

Download tutorial in PDF about Oracle Database 11g: SQL Fundamentals, free training document for beginners....

SQL Server Backup and Restore

Download tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....

SQL Server Internals: In-Memory OLTP

Download free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney....

Learning MySQL

Download free course intituled Learning MySQL, a PDF document created by StackOverflow Documentation, a 300-page tutorial on the basics of this language to learn and manipulate databases created with MySQL....

SQL Server Metadata Succinctly

Download free course SQL Server Metadata Succinctly, pdf file on 85 pages by Joseph D. Booth....

Oracle database tutorial

Download free Oracle tutorial course in PDF, training file in 33 chapters and 104 pages. Free unaffiliated ebook created from Stack OverFlow contributor....