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
Blogs Louis Davidson in Blogs 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
T-SQL Programming Joe Celko in T-SQL Programming Data in Motion and Data at Rest Microsoft (StreamInsight), and Azure Stream Analytics represent a very different model for processing data. They are concerned with processing complex... 28 July 2017 11 min read
Opinion Pieces William Brewer in Opinion Pieces Personal Data, Privacy, and the GDPR Now that there have been well-publicised examples of the awful consequences of data breaches and data misuse, there is increasing... 10 May 2017 22 min read
Blogs Phil Factor in Blogs The Need for Database DevTest The first and overriding thought of the experienced developer given any new development task is, or should be, ‘How the... 09 May 2017 3 min read