Francis Hanlon On the Trail of the Expanding Databases It is sometimes difficult for other IT people to understand the constraints that DBAs have to work under. So often... 11 October 2008 12 min read
Joe Webb Using Covering Indexes to Improve Query Performance Designers of database systems will often assume that the use of a clustered index is always the best approach. However... 29 September 2008 12 min read
Phil Factor Robyn Page Database Design Workbench – Keys Robyn Page and Phil Factor explore the innocent subject of Keys for their latest workbench. Everybody knows about keys. Oh... 19 September 2008 18 min read
Jaap Wesselius Exchange Database Technologies One of the most misunderstood technologies in Exchange Server, regardless of its version, is the database technology. Most people, even... 22 August 2008 17 min read
Jaap Wesselius Exchange 2007 Mailbox Server Clustering The original, rather complex, Exchange clustering, 'Single Copy Cluster', protects you against a server failure but not a database failure.... 12 August 2008 19 min read
Amirthalingam Prasanna Creating Service-Orientated Data-Access Layers The ADO.Net Data Services framework enables you to provide data services to Web applications that are simple to integrate with... 30 July 2008 13 min read
Mario Broodbakker Investigating SQL Server 2008 Wait Events with XEVENTS Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy... 24 July 2008 9 min read
Randy Volters DML Trigger Status Alerts When databases suddenly stop working, it can be for a number of different reasons. Human error plays a large part,... 04 July 2008 9 min read
Richard Morris Dr Richard Hipp, Geek of the Week Simple-Talk's Geek of the Week is Dr Richard Hipp. His code is probably running on your PC, and running completely... 04 July 2008 13 min read
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
