William Brewer

William Brewer is a SQL Server developer who has worked as a Database consultant and Business Analyst for several Financial Services organisations in the City of London. True to his name, he is also an expert on real ale.

Follow William Brewer via
19 September 2018
19 September 2018

Fifty Different Ways to Enact Data Privacy Laws?

0
6
Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.… Read more
0
6
24 January 2018
24 January 2018

Questions about Data Governance that You Were Too Shy to Ask

0
14
A company’s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities, and a data governance processes must be put into place to avoid misuse and to meet regulations. In this article, William Brewer answers questions you may have about data governance but were too shy to ask.… Read more
0
14
30 November 2017
30 November 2017

Questions about Data Masking That You Were Too Shy to Ask

0
10
The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organization comply with this and other regulations. William Brewer answers those questions about data masking that you were too shy to ask.… Read more
0
10
14 November 2017
14 November 2017

Questions About the GDPR That You Were Too Shy to Ask

0
38
The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask. … Read more
0
38
18 July 2017
18 July 2017

The Fast Route from Raw Data to Analysis and Display

0
6
There are very few real breakthroughs in IT. Most progress in the industry comes from pure effort and attention to detail. When breakthroughs happen, they are like those famous moments in the construction of Alpine tunnels where two teams, start in separate foreign lands working determinedly for years in opposite directions, apparently digging a bigger … Read more
0
6
05 July 2017
05 July 2017

Morphing the Monolith

0
7
Microservices can certainly be made to work well for particular types of applications, but is it relevant to the mainstream? Can it replace the traditional architectures of database-driven applications? Microservice architecture is a type of service-oriented architecture that was developed from the concept of Domain-Driven design (DDD) and consists of loosely-coupled services that are network-based. … Read more
0
7
20 June 2017
20 June 2017

Database Code Analysis

0
12
Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.… Read more
0
12
10 May 2017
10 May 2017

Personal Data, Privacy, and the GDPR

0
16
Now that there have been well-publicised examples of the awful consequences of data breaches and data misuse, there is increasing public pressure for legislation on privacy and personal data that has enough clout to prosecute serious offenders. In the vanguard has been the EU data protection regulation, soon to be succeeded by the GDPR. It defines IT practices for data that are likely to extend worldwide. William Brewer gives a rundown of what he sees as the implication for IT practice.… Read more
0
16
21 April 2017
21 April 2017

Generating HTML from SQL Server Queries

0
96
You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.… Read more
0
96
10 February 2017
10 February 2017

The Harsh Reality Behind Big Data Misuse

0
9
Big Data has its origin in science, but it is now being used commercially to increase the information that organizations have about people. This information can uniquely identify individuals and reveal their likes, habits, propensities and wealth. The power of this information is so great that legislation on its use is having to become more … Read more
0
9
12 December 2016
12 December 2016

Questions About the Use of PowerShell That you were Too Shy to Ask

0
18
Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long to arrive? These and many other basic questions are answered in William Brewer's latest addition to the series that answers those seemingly simple questions that you were too shy to ask in public.… Read more
0
18
18 November 2016
18 November 2016

DevOps and Database Lifecycle Management

0
14
Database Lifecycle Management (DLM) aims to provide a roadmap of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How does the DevOps movement, as it applies to databases, fit into this? William Brewer explains how DevOps provides the organisational change between delivery and operations to make important parts of the process easier to introduce.… Read more
0
14