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: | 178 |
| Created: | 2022-02-03 |
| License: | For personal or educational use |
| Author(s): | John Magnabosco |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233
Others sql Tutorials
SQL Server Metadata Succinctly
Others related eBooks about Protecting SQL Server Data
Introduction to SQLThis tutorial is a brief overview about SQL language and free training document courses under 39 pages for beginners....
How to Install SQL Server 2008With this tutorial you will learn step by step how to install SQL Server 2008 and how to check the correct configuration of the server. Download free pdf training course in 32 page intended to beginners....
Structured Query LanguageTutorial in PDF about Structured Query Language (SQL) ,free training document under 78 pages for download....
SQL Server Backup and RestoreDownload free course SQL Server Backup and Restore, pdf file on 381 pages by Shawn McGehee....
SQL Server Internals: In-Memory OLTPDownload free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney....
Guide to NoSQL with Azure Cosmos DB: Create Scalable and Globally Distributed Web ApplicationsCosmos DB is a NoSQL database service included in Azure that is continuously adding new features and has quickly become one of the most innovative services found in Azure, targeting mission-critical applications at a global scale. ...
A Primer on SQL, 3rd EditionThis 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...
Access 2013 Lab manualDownload free Microsoft Office Access 2013 file under 115 pages,pdf manual , course tutorial training on pdf by David Murray (University at Buffalo)....
SQL Interview Questions free PDFDownload free course SQL Interview Questions free PDF, pdf file on 17 pages by tutorialkart.com....
The Definitive Guide to Graph DatabasesDownload free course The Definitive Guide to Graph Databases, pdf file on 30 pages by Michael Hungers, Ryan Boyd, William Lyon....