Questions About SQL Server Security and Access Control You Were Too Shy to Ask

For many developers, database security and Access control is just something that gets in the way of development work. However,...

04 November 2016 23 min read

Blogs

William Brewer in Blogs

Skilling and De-skilling

Not long ago, I was having to do a fairly simple DBA task onsite. It involved database provisioning by copying...

20 October 2016 3 min read

Database Administration

William Brewer in Database Administration

Database Cloud Backup Cribsheet

Several database backup providers are now offering ‘Database Backup to the Cloud’, or ‘Backup As A Service’ (BaaS). There is...

12 September 2016 14 min read

William Brewer

Planning for a Successful Database Lifecycle

Although it is well-known that the best efforts of a development team can be derailed by mistakes in the architecture,...

09 June 2016 35 min read

William Brewer

The Cross Platform

With the new range of cross-platform runtime-systems, based on WebKit and Node.js, we developers are once again offered the lure...

24 February 2016 3 min read

William Brewer

Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask

There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the...

03 November 2015 17 min read

William Brewer

IT Compliance and Software Development

What is IT Compliance and is it really necessary for contemporary Agile applications to be constrained by the requirements of...

06 February 2015 14 min read

William Brewer

Database Configuration Management for SQL Server

It is not just the rapid and painless testing, deployment and update of databases that requires care in the retention...

05 November 2014 16 min read

William Brewer

Disaster Recovery Planning for Data: The Cribsheet

Planning for disaster recovery and business continuity aren't amongst the most exciting IT activities. They are, however, essential and relevant...

07 December 2012 13 min read

William Brewer

Database Deployment Cribsheet

As part of our long-running Cribsheet series, we asked William to write a guide to deployment that described in general...

29 October 2012 14 min read

William Brewer

Database Source Control – The Cribsheet

As part of our long-running Cribsheet series, we asked William to come up with a brief summary of what was...

08 November 2011 25 min read

William Brewer

Advice on CSS you’ll wish your mother told you

William Brewer turns a jaundiced eye to the task of laying out web pages using CSS, and gives some nuggets...

21 May 2010 16 min read

William Brewer

Calling Stored Procedures from .NET Applications

Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored...

11 September 2009 18 min read

William Brewer

JSON and other data serialization languages

The easiest way to speed up an Ajax application is to take out the 'X' and use JSON rather than...

18 July 2008 9 min read

William Brewer

SQL Code Layout and Beautification

William Brewer takes a look at the whole topic of SQL Code layout and beautification, an important aspect to SQL...

11 May 2008 16 min read

William Brewer

Audit Crosschecks

In this short article, the second of a 2-part series, William suggests a solution, using SQL Data Compare 6.1, for...

24 January 2008 7 min read

William Brewer

Top HAT

If there is one thing that developers and users always seem to disagree on, it is the relative importance of...

13 November 2007 19 min read

William Brewer

Quantifying Text differences in TSQL

In TSQL there is a limit to the way you can compare text strings. They're either equal or not. Sooner...

20 September 2007 14 min read

William Brewer

SQL Server Endpoints: Soup to Nuts

SQL Server Endpoints are database objects that define the ways and means that SQL Server 2005 communicates on the network....

06 July 2007 12 min read

William Brewer

Database High-Availability: Soup to Nuts

William Brewer argues that, although there are technologies around that will minimise downtime in most circumstances, they are only part...

31 May 2007 14 min read

Register for Simple Talk

William Brewer

William Brewer's content

Questions About SQL Server Security and Access Control You Were Too Shy to Ask

Skilling and De-skilling

Database Cloud Backup Cribsheet

Planning for a Successful Database Lifecycle

The Cross Platform

Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask

IT Compliance and Software Development

Database Configuration Management for SQL Server

Disaster Recovery Planning for Data: The Cribsheet

Database Deployment Cribsheet

Database Source Control – The Cribsheet

Advice on CSS you’ll wish your mother told you

Calling Stored Procedures from .NET Applications

JSON and other data serialization languages

SQL Code Layout and Beautification

Audit Crosschecks

Top HAT

Quantifying Text differences in TSQL

SQL Server Endpoints: Soup to Nuts

Database High-Availability: Soup to Nuts