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.

William Brewer 02 October 2007

The Science of Compliance

Database Administration

'William Brewer takes a look at what is involved with IT 'Compliance', and discusses what SOX compliance means for the DBA and IT Application developer.'… Read more

Database Administration

William Brewer 20 September 2007

Quantifying Text differences in TSQL

T-SQL Programming

In TSQL there is a limit to the way you can compare text strings. They're either equal or not. Sooner or later, usually when cleaning data, something more subtle is required!… Read more

T-SQL Programming

William Brewer 06 July 2007

SQL Server Endpoints: Soup to Nuts

147

Database Administration

SQL Server Endpoints are database objects that define the ways and means that SQL Server 2005 communicates on the network. Any DBA working with SQL Server 2005 will soon need to become familiar with them, particularly if using SOAP, Service Broker or Database Mirroring.… Read more

147

Database Administration

William Brewer 20 June 2007

Using SQL Backup

SQL Tools

William Brewer describes the role of SQL Backup in an enterprise SQL Server maintenance plan.… Read more

SQL Tools

William Brewer 31 May 2007

Database High-Availability: Soup to Nuts

Database Administration

William Brewer argues that, although there are technologies around that will minimise downtime in most circumstances, they are only part of the solution. At the heart of every robust system, there is planning, documentation, scripting, testing and drill. … Read more

Database Administration

William Brewer 18 January 2007

Falling off the Web Log

Opinion Pieces

Getting statistics out of website usage isn't a real problem. There are many ways to do it and plenty commercial packages that provide a 'turnkey' solution. The real problem is getting your hands on those elusive, meaningful statistics that will give you true insight into the effectiveness of your website and advertising campaigns.… Read more

Opinion Pieces

William Brewer 01 December 2006

Towards the Self-Documenting SQL Server Database

SQL Tools

William Brewer investigates an unsung hero in SQL Server, extended properties, and shows how to use them to create self-documenting SQL Server databases.… Read more

SQL Tools