Protecting SQL Server Data
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 : | |
| Downloads: | 162 |
| Created: | 2022-02-03 |
| License: | For personal or educational use |
| Author(s): | John Magnabosco |
Others sql Tutorials
Others related eBooks about Protecting SQL Server Data
PostgreSQL Notes for ProfessionalsDownload free course PostgreSQL Notes for Professionals, pdf file on 73 pages by Stack Overflow Community....
Database DesignDownload free course Database Design, pdf file on 153 pages by Adrienne Watt....
Guide Microsoft Access 2010This document is a quick tutorial guide about Microsoft Access 2010 to learn how to store informations in an easily retrievable form....
MongoDB Tutorial free PDFDownload free course MongoDB Tutorial free PDF, pdf file on 5 pages by tutorialkart.com....
SQL Server Internals: In-Memory OLTPDownload free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney....
Learning access-vba PDF courseDownload free Access vba tutorial course in PDF, training file in 5 chapters and 207 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
The Little MongoDB BookKarl Seguin is a developer with experience across various fields and technologies. He's an..., download free MongoDB tutorial in PDF (66 pages) created by ....
SQL Server Backup and RestoreDownload tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....
Guide to NoSQL with Azure Cosmos DBDownload free course Guide to NoSQL with Azure Cosmos DB, pdf file on 205 pages by Gaston C. Hillar , Daron Yöndem....
SQL in 21 daysThis tutorial is for people who want to learn the fundamentals of Structured Query Language (SQL) , a complete training courses under 412 pages for download ....