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: | 183 |
| 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 injection: attacks and defenses
MySQL – Create Database free PDF
Others related eBooks about Protecting SQL Server Data
How To Manage a Redis DatabaseDownload free course How To Manage a Redis Database, pdf file on 95 pages by Mark Drake....
Graph Databases For BeginnersWhether you're a business executive or a seasoned developer, something has led you on the ..., download free Graph Databases tutorial in PDF (46 pages) created by Bryce Merkl Sasaki ....
Getting started with Oracle 8This pdf tutorial is about fundamental of relational database with Oracle , a free training document for Beginners....
SQL Server Internals: In-Memory OLTPDownload free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney....
MySQL Notes for ProfessionalsDownload free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community....
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....
MongoDB tutorial for professionalsDownload free MongoDB tutorial course in PDF, training file in 23 chapters and 73 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
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...
PostgreSQL Notes for ProfessionalsDownload free course PostgreSQL Notes for Professionals, pdf file on 73 pages by Stack Overflow Community....