David Connell Towards a Better Beta David Connell describes how the team that developed Red-Gate's SQL Data Generator tool came to realise that database developers and... 31 March 2008 11 min read
Richard Morris The Dark Arts of Journalism Although the IT industry is usually blamed for security breaches in confidential databases, it is likely that it is usually... 16 March 2008 9 min read
Phil Factor Robyn Page SQL Server Alerts: Soup to Nuts In which Robyn Page and Phil Factor try to get to grips with the difficult subject of SQL Server Alerting,... 19 February 2008 24 min read
Arthur Fuller The Database From Hell In which Arthur Fuller comes to the aid of a friend who is doing his best to administer The Database... 19 February 2008 10 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
Andrew Clarke The Waffle Generator Sometimes, silly programs have a less obvious useful purpose. Andrew Clarke takes his classic 'Waffle Generator', and provides it in... 16 January 2008 10 min read
Phil Factor The Computer that Swore Database Developers occasionally get crazy ideas into their heads. Phil Factor should know; He confesses that he's had a few... 13 November 2007 10 min read
Phil Factor The Joy of NAD Phil Factor convenes a short meeting to discuss the data architecture for storing a client's contact details...how painful could it... 30 October 2007 7 min read
Jonas Stawski Take Row-Level Control of Your GridView The ASP.NET GridView is great for very simple tables, but the real world is not always as straightforward as we... 27 September 2007 10 min read
Phil Factor Captain Codd and the Simple Proposition A Pantomime for Database Professionals.… 26 September 2007 4 min read
Allen White Automate your Database Integrity checks using SMO Allen White shows how to use Visual Basic to create simple routines that use SMO for inserting and deleting jobs... 15 September 2007 22 min read
Alex Kuznetsov and Alex Styler Close These Loopholes – Testing Database Modifications In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give... 02 September 2007 13 min read
Alex Kuznetsov and Alex Styler Close those Loopholes – Testing Stored Procedures Alex and Alex continue their series of articles on 'Unit Testing' database development work with some examples of unit testing... 20 August 2007 9 min read
András Belokosztolszki Discovering Security Uses for SQL Compare Much of the security of SQL Server is implemented as part of the database schema. This provides some bonus uses... 06 August 2007 10 min read
Alex Kuznetsov Close These Loopholes in Your Database Testing Alex starts of a series of articles on 'Unit Testing' your database development work. He starts off by describing five... 31 July 2007 7 min read
Remi Gregoire RBAR: ‘Row By Agonizing Row’ Remi Gregoire describes the vice of RBAR Database Programming, 'Row By Agonising Row', and illustrates how the effect of RBAR... 26 July 2007 15 min read
Greg Larsen Custom reports in Management Studio, using the Performance Dashboard If you are using SSMS and SQL Server 2005 sp2 You've probably tried out the database reports that are available... 18 July 2007 11 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
András Belokosztolszki Source Control and Databases András's article on Source Control shows a lot of the thinking amongst the developers at Red Gate at that time... 29 May 2007 18 min read
