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: | 174 |
| 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
PostgreSQL tutorial for professionals
SQL Interview Questions free PDF
Others related eBooks about Protecting SQL Server Data
Oracle Database Notes for ProfessionalsDownload free course Oracle Database Notes for Professionals, pdf file on 117 pages by Stack Overflow Community....
MySQL Notes for ProfessionalsDownload free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community....
Introduction to SQL Server 2008This pdf course is designed to teach you Microsoft SQL Server. This is a practical training to learn the basics of the Microsoft Database Management System, in its 2008 version....
Migrating SQL Server Databases to AzureDownload free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....
Introduction to OracleThis PDF tutorial about Oracle/SQL provides a detailed introduction to SQL (Structured query language),free training document under 64 pages for all level users....
Graph Databases For BeginnersDownload free course Graph Databases For Beginners, pdf file on 46 pages by Bryce Merkl Sasaki, Joy Chao, Rachel Howard....
SQL Server HardwareDownload free course SQL Server Hardware, pdf file on 318 pages by Glen Berry....
MongoDB Tutorial free PDFDownload free course MongoDB Tutorial free PDF, pdf file on 5 pages by tutorialkart.com....
Microsoft Access courseThis 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....
Microsoft Access 2013 courseDownload free Microsoft Office Access 2013 file under 448 pages,step by step to learn Access and build your skills , course tutorial training on pdf by Joyce Cox and Joan Lambert....