Click here to monitor SSC

John Magnabosco John Magnabosco
John Magnabosco is a writer and a SQL Server Database Consultant. He is also the current President and Co-Founder of the Indianapolis Professional Association for SQL Server (IndyPASS) as well as the Speaker Coordinator and Co-Founder of IndyTechFest. As a database developer and administrator John has had the opportunity to work on databases as small as single user systems and as large as a terabyte enterprise databases in the banking and government arenas.
Transparent Data Encryption
by John Magnabosco | 16 March 2010 |  4 comments |
Transparent Data Encryption is designed to protect data by encrypting the physical files of the database, rather than the data itself. Its main purpose is to prevent unauthorized access to the data by restoring the files to another server. With Transparent Data... Read more...
Obfuscating your SQL Server Data
by John Magnabosco | 21 October 2009 |  1 comment |
If you are required to use real production data to test applications, any sensitive data should be "disguised" before loading it into the development environment. Although there are tools to generate convincing test data, it occasionally happens that the variances... Read more...
Honeycombing a Database
by John Magnabosco | 16 September 2009 |  5 comments |
In this article, taken from Chapter 9 of his new book, Protecting SQL Server Data, John describes how to set a "honey trap" for would-be data thieves, allowing the DBA to identify the precursors of an attack and respond quickly and also to better understand the... Read more...
Protecting SQL Server Data
by John Magnabosco | 20 August 2009 |  2 comments |
John Magnabosco's excllent new book, "Protecting SQL Server Data", holds the key to encryption without fear. In it, John Magnabosco sweeps away some of the misconceptions surrounding SQL Server's encryption technologies, and demonstrates that, when properly planned... Read more...
Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk