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: 176
Created: 2022-02-03
License: For personal or educational use
Author(s): John Magnabosco
Protecting SQL Server Data

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others sql Tutorials

Quick Guide to SQL Server Management Studio

SQL Notes for Professionals

Tutorial PostgreSQL in pdf

SQL Server Backup and Restore

Introduction to SQL

Others related eBooks about Protecting SQL Server Data

Oracle database tutorials for professionals

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

Guide Microsoft Access 2010

This document is a quick tutorial guide about Microsoft Access 2010 to learn how to store informations in an easily retrievable form....

Learning Microsoft SQL Server

Download free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community....

Learning SQLite

Download SQLite tutorial in PDF format, document created by StackOverFlow intended to beginners....

Structured Query Language

Tutorial in PDF about Structured Query Language (SQL) ,free training document under 78 pages for download....

Microsoft SQL Server Notes for Professionals

Download free course Microsoft SQL Server Notes for Professionals, pdf file on 285 pages by Stack Overflow Community....

RavenDB in Action

The data you encounter in the real world is usually easier to think of as objects or docum..., download free RavenDB tutorial in PDF (221 pages) created by Itamar Syn-Hershko ....

How To Manage a Redis Database

This book aims to provide an approachable introduction to Redis concepts by outlining many..., download free Redis Database tutorial in PDF (95 pages) created by Mark Drake ....

A Primer on SQL, 3rd Edition

This book is an introduction to the basics of SQL. No prior experience with SQL is necessary, but some knowledge of working with computers in general is required. My purpose of writing this was to provide a gentle tutorial on the syntax of SQL, so that the reader is able to recognize the parts of qu...

PostgreSQL Administration

Learn how to administrate PostgreSQL,a free course training material in PDF By Bruce Momjian....