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
Pages232
Size4.0 MB
File typePDF
Downloads308
Created2022-02-03
LicenseFor personal or educational use
Author(s) John Magnabosco
Cover of Protecting SQL Server Data

Download

  • Introduction to Access 2010

    Start to learn Microsoft Access 2010 with this free PDF tutorial and more about new useful features insides including designing databases and queries,training document for download under 24 ....

  • SQL Server Backup and Restore

    Download free course SQL Server Backup and Restore, pdf file on 381 pages by Shawn McGehee....

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

  • Microsoft Access course

    This PDF tutorial shows how to construct a complex application in Microsoft Access ,free training lesson under 154 pages by Soren Lauesen designated to the intermediate level-user....

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

  • SQL Server Hardware

    Download free course SQL Server Hardware, pdf file on 318 pages by Glen Berry....

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

  • MySQL Notes for Professionals

    MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this MySQL Notes for Professionals is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out exampl...

  • PostgreSQL tutorial

    Download free PostgreSQL tutorial course in PDF, training file in 29 chapters and 93 pages. Free unaffiliated ebook created from Stack OverFlow contributor....