Protecting SQL Server Data



Bookstore > Books > Protecting SQL Server Data

Protecting SQL Server Data

Free Download
eBookFree
Rating
AuthorJohn Magnabosco
PublisherSelf-publishing
Published2009
Pages232
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101906434263
ISBN-139781906434267
EBook Hardcover Paperback

In Protecting SQL Server Data, John Magnabosco demonstrates how sensitive data, stored in SQL Server, can be protected using an efficient and maintainable encryption-based data architecture.

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.




Similar Books


SQL Server Execution Plans, 3rd Edition

SQL Server Execution Plans, 3rd Edition

by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the informati...

Free ebook  |  Publisher:  Self-publishing  |  Release:  2018

SQL Server 2019 Administration Inside Out

SQL Server 2019 Administration Inside Out

by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni

Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...

Price:  $48.15  |  Publisher:  Microsoft Press  |  Release:  2020

Programming Microsoft SQL Server 2012

Programming Microsoft SQL Server 2012

by Leonard Lobel, Andrew Brust

Take your database programming skills to a new level - and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you're an experienced SQL Server develop...

Price:  $21.95  |  Publisher:  Microsoft Press  |  Release:  2012

Expert SQL Server Transactions and Locking

Expert SQL Server Transactions and Locking

by Dmitri Korotkevitch

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you devel...

Price:  $24.23  |  Publisher:  Apress  |  Release:  2018

Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition

Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition

by Marco Russo, Alberto Ferrari

Create a semantic model and analyze data using the tabular model in SQL Server 2016 Analysis Services to create corporate-level business intelligence (BI) solutions. Led by two BI experts, you will learn how to build, deploy, and query a tabular model by following detailed examples and best practices. This hands-on book shows you how to u...

Price:  $45.42  |  Publisher:  Microsoft Press  |  Release:  2017

SQL Server 2017 Administration Inside Out

SQL Server 2017 Administration Inside Out

by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt

Dive into SQL Server 2017 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Serve...

Price:  $34.23  |  Publisher:  Microsoft Press  |  Release:  2018

Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

by Satya Shyam K Jayanty

Provides Advanced Administration techniques for SQL Server 2008 R2 as a book. Covers the essential Manageability, Programmability, and Security features. Emphasizes important High Availability features and implementation. Explains how to maintain and manage the SQL Server data platform effectively....

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2011

Migrating SQL Server Databases to Azure

Migrating SQL Server Databases to Azure

by Carl Rabeler

SQL Server is Microsoft's relational database management system (RDBMS). SQL Server can now be hosted entirely in Microsoft Azure, either in a hosted virtual machine (VM) or as a hosted service. Hosting a virtual machine in Azure is known as infrastructure as a service (IaaS), and hosting a service in Azure is known as platform as a ...

Free ebook  |  Publisher:  Microsoft Press  |  Release:  2016