William Brewer

19 September 2018 13 min read

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...

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

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

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

19 March 2018 16 min read

William Brewer in Opinion Pieces

Data Retention: An Inexact Art

A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the...

09 February 2018 16 min read

William Brewer in Opinion Pieces

Questions About Data Breaches that You Were Too Shy to Ask

News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not...

24 January 2018 16 min read

William Brewer in Opinion Pieces

Questions about Data Governance that You Were Too Shy to Ask

A company’s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities,...

30 November 2017 10 min read

William Brewer in Opinion Pieces

Questions about Data Masking That You Were Too Shy to Ask

The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that...

14 November 2017 15 min read

William Brewer in Opinion Pieces

Questions About the GDPR That You Were Too Shy to Ask

The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The...

William Brewer in Blogs

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL...

18 July 2017 7 min read

William Brewer in Blogs

The Fast Route from Raw Data to Analysis and Display

There are very few real breakthroughs in IT. Most progress in the industry comes from pure effort and attention to...

18 July 2017 3 min read

William Brewer in Blogs

Morphing the Monolith

Microservices can certainly be made to work well for particular types of applications, but is it relevant to the mainstream?...

05 July 2017 3 min read

Database DevOps

William Brewer in Database DevOps

Database Code Analysis

Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the...

20 June 2017 12 min read

William Brewer in Blogs

WannaCry Over Spilled Data

The WannaCry ransomware attack has highlighted a serious problem. If there is negligence in your IT strategy, you are increasingly...

24 May 2017 3 min read

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

21 April 2017 11 min read

William Brewer in Blogs

Generating HTML from SQL Server Queries

You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood...