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
John Papa Gathering RSS Feeds using Visual Studio and RSS.NET If you would like to learn how to build and customize your very own Windows service to retrieve posts from... 04 May 2007 13 min read
Doug Burns What use is a Development DBA? "I can't help thinking that unless you have a good DBA on a development team and use him or her... 12 April 2007 12 min read
Allen White Automate your Database Maintenance using SMO The most important thing you can do as a database administrator is perform regular database maintenance. This includes regular backups,... 05 April 2007 33 min read
Keith Fletcher Creating Cross Tab Queries and Pivot Tables in SQL For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored... 27 March 2007 18 min read
Mario Broodbakker SQL Server Wait Events: Taking the Guesswork out of Performance Profiling Measuring what is actually happening is always the best course of action when investigating performance issues on databases, rather than... 22 March 2007 16 min read
Pop Rivett Pop Rivett and the Case of the Rogue SPIDs A process in a complex database occasionally, and apparently randomly, manages to put table locks on vital tables. Several applications... 22 March 2007 6 min read
Steven R. McCabe Exploring LINQ, SQLMetal and SqlTac If you're a .NET developer, working with or without a database on the back-end, your world is about to change.... 15 March 2007 23 min read
