Data Privacy and Protection William Brewer in Data Privacy and Protection Fifty Different Ways to Enact Data Privacy Laws? Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is... 19 September 2018 13 min read
Data Privacy and Protection David Poole in Data Privacy and Protection Exhuming the GDPR Bodies Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that... 12 September 2018 20 min read
Editorials Kendra Little in Editorials Security, Compliance, Data Ethics, and Breaking the “Not My Job” Mindset Security, compliance, and data ethics are related concepts that everyone who works with software should know about, from the help... 30 August 2018 3 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to HIPAA and SOX Despite the attention to data privacy and protection caused this year because of the GDPR, regulations governing how data is... 15 August 2018 12 min read
Other Phil Factor in Other Generating Fake Credit Card Numbers in SQL Server with the Luhn Algorithm (for Test Data) Generate fake credit card numbers in SQL Server that pass Luhn checksum validation - useful for populating development and test... 08 August 2018 9 min read
Data Privacy and Protection William Brewer in Data Privacy and Protection Information Security in Practice Along with the GDPR, regulations require that confidential data is protected and used properly. In this article, William Brewer discusses... 24 July 2018 13 min read
Other Phil Factor in Other Spoofing Data Convincingly: Masking Continuous Variables. In any real numeric data from a database , you are only rarely going to see any sort of normal... 18 July 2018 8 min read
Other Phil Factor in Other SQL Server Data Masking Techniques: Spoofing Existing Table Data for Test and Development Mask SQL Server production data for test and development environments - name substitution from lookup tables, locality-preserving address transformations, and... 17 July 2018 10 min read
Other Phil Factor in Other Spoofing Data Convincingly for Database Development. An Introduction Many times I’ve been told, by developers who are using live data to develop a database, that it is impossible... 12 July 2018 14 min read
Data Privacy and Protection William Brewer in Data Privacy and Protection How to be Accountable for Handling Personal Data The GDPR is in full effect but meeting the requirements may still be confusing for many companies. In this article,... 05 July 2018 16 min read
Data Privacy and Protection K. Brian Kelley in Data Privacy and Protection Principles of Data Protection Protecting data in SQL Server is not as simple as setting a few properties. While there are great security features... 26 June 2018 18 min read
Data Privacy and Protection K. Brian Kelley in Data Privacy and Protection Detecting Data Breaches Data breaches make the news on an almost daily basis. There is no turning back, however, as we are firmly... 12 June 2018 17 min read
Editorials Kathi Kellenberger in Editorials Do We Really Care About Privacy? You may have noticed a recent flurry of activity in your email inbox as many companies sent out new privacy... 01 June 2018 3 min read
Data Privacy and Protection William Brewer in Data Privacy and Protection Data Governance, DevOps, and Delivery Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure... 31 May 2018 14 min read
Other Annette Allen in Other GDPR – What do we need to know? On 25th May GDPR comes into force. I’ve been learning everything I can about GDPR to ensure my systems adhere... 11 May 2018 1 min read
Editorials Kathi Kellenberger in Editorials The Facebook Fiasco About ten years ago, my friends and family were abandoning their Myspace accounts and heading to Facebook. I fought it... 08 April 2018 3 min read
Other Louis Davidson in Other Securing access to data for admin and dbo In this blog, I want to explore what you can do to block the owner of a database from doing... 19 March 2018 11 min read
Database Administration Dennes Torres in Database Administration Checking SQL Server with Policy-Based Management Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL... 09 November 2017 15 min read
Tools Grant Fritchey in Tools Automated Database Provisioning for Development and Testing If your development team needs to work on anonymised copies of the current production database, and if changes are being... 02 August 2017 10 min read
Phil Factor Pseudonymization and the Inference Attack It is surprising that so much can be identified by deduction from data. You may assume that you can safely... 01 August 2017 10 min read
