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: | 188 |
| 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 Shell Commands free PDF
Guide to NoSQL with Azure Cosmos DB: Create Scalable and Globally Distributed Web Applications
Others related eBooks about Protecting SQL Server Data
Performance Tuning with SQL Server Dynamic Management ViewsDownload free course Performance Tuning with SQL Server Dynamic Management Views, pdf file on 326 pages by Louis Davidson, Tim Ford....
MongoDB Tutorial free PDFDownload free course MongoDB Tutorial free PDF, pdf file on 5 pages by tutorialkart.com....
Database DesignDownload free course Database Design, pdf file on 153 pages by Adrienne Watt....
MySQL Notes for ProfessionalsMySQL'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...
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....
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....
Oracle Advanced PL/SQL Developer Professional GuidePL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta ....
SQL Notes for ProfessionalsDownload free course SQL Notes for Professionals, pdf file on 165 pages by Stack Overflow Community....
Structured Query LanguageTutorial in PDF about Structured Query Language (SQL) ,free training document under 78 pages for download....
PostgreSQL AdministrationLearn how to administrate PostgreSQL,a free course training material in PDF By Bruce Momjian....