András Belokosztolszki Foreign Keys and their States András Belokosztolszki, Red Gate developer, shows how foreign key constraints can be disabled and re-enabled in order to simplify operations... 22 June 2007 7 min read
Pop Rivett Pop Rivett and the Expanding Log Pop Rivett comes to the rescue when an expanding log file threatens the very existence of a young man's website...… 22 June 2007 8 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
Phil Factor Robyn Page SQL Server Replication Crib Sheet Robyn Page and Phil Factor delve into all the things you need to know, rather than want to know, about... 14 May 2007 16 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
Dan Sullivan PowerSMO at Work Part 2 In part 3 of Dan Sullivan's in-depth exploration of PowerSMO, the versatile command line utility for managing SQL Server databases,... 12 March 2007 19 min read
Louis Davidson Ten Common Database Design Mistakes If database design is done right, then the development, deployment and subsequent performance in production will give little trouble. A... 26 February 2007 32 min read
Arthur Fuller Database Design: A Point in Time Architecture In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However,... 22 February 2007 19 min read
Robyn Page SQL Server Security Cribsheet If you've ever had brain meltdown trying to understand SQL Server users, roles, permissions, logins etc. then Robyn Page's security... 20 February 2007 21 min read
Dan Sullivan PowerSMO At Work Part I: DBA Scripts and Functions Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy,... 19 February 2007 22 min read
Pop Rivett Pop Rivett and the Uncontrolled Release Pop Rivett offers a hard lesson in the dangers of an uncontrolled software release.… 15 February 2007 20 min read
Dan Sullivan Managing SQL Server using PowerSMO Most DBAs don't have time to perform routine processes manually. Everything has to be scripted, automated and scheduled. Here, Dan... 31 January 2007 22 min read
Phil Factor The Data Dialog Most companies have long since jettisoned the role of the grizzled old data architect, whose job it was to ensure... 30 January 2007 7 min read
Scott W. Ambler and Pramod J. Sadalage Refactoring Databases: The Process Database refactoring can greatly improve the efficiency of your database code. However, even a seemingly simple database refactoring such as... 09 January 2007 16 min read
Pop Rivett Pop Rivett and the Suspect Database When a 'torn page' error corrupts a SQL Server database, threatening the survival of some vital data and a mainly... 08 January 2007 6 min read
Phil Factor Automating Common SQL Server Tasks using DMO Phil Factor's DMO automation procedures provide a valuable additon to any DBAs toolkit.… 27 November 2006 12 min read
Nigel Rivett Creating CSV Files Using BCP and Stored Procedures Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing on a stored procedure approach... 20 November 2006 13 min read
Pop Rivett Pop Rivett’s SQL Server FAQ No.5: Pop on the Audit Trail Pop provides a cunning, trigger-based technique for auditing the activity on SQL Server tables… 03 November 2006 7 min read
