Amirthalingam Prasanna Entity Framework: The Cribsheet Prasanna Amirthalingam provides an overview of Entity Framework and how it can be used. He shows that it can provide... 26 May 2008 18 min read
Alex Kuznetsov Close these Loopholes – Reproduce Database Errors This is the final part of Alex's ground-breaking series on unit-testing Transact-SQL code. Here, he shows how you can test... 23 May 2008 8 min read
Alex Kuznetsov The Case of the Skewed Totals Even when your code tests out perfectly in the standard test cell, you can experience errors in the real production... 15 April 2008 7 min read
Hugh Bin-Haad The Concept of Cardinal Reciprocity- A Primer Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a... 01 April 2008 12 min read
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
