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: | 157 |
| 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
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...
MySQL – Create Database free PDFDownload free course MySQL – Create Database free PDF, pdf file on 3 pages by tutorialkart.com....
Essential MySQLThis book written to provide clear and concise explanation of topics for programmers both starting to learn the MySQL programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....
Microsoft SQL Server 2012This PDF tutorial will teachs you how to use SQL Server Data Tools to develop and deploy an Analysis Services project with examples,it's a free training course under 169 pages by Microsoft....
Oracle database tutorials for professionalsDownload free Oracle tutorial course in PDF, training file in 45 chapters and 118 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
PostgreSQL tutorial for professionalsDownload free PostgreSQL tutorial course in PDF, training file in 29 chapters and 74 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
Download Oracle training documentThis pdf tutorial provides a complet lessons about Oracle in order to become familiar with Oracle architecture and able to managinig database....
Database DesignDownload free course Database Design, pdf file on 153 pages by Adrienne Watt....
Introduction to SQLThis tutorial is a brief overview about SQL language and free training document courses under 39 pages for beginners....
Microsoft Access TutorialDownloaf Microsoft Access Tutorial in PDF , it'a a free training document intended for beginner's to learn the basics of Microsoft Access database....