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 BCP to CSV: Export SQL Server Data to CSV Files Export SQL Server data to CSV files using BCP and stored procedures. Covers delimiters, column headers, xp_cmdshell integration, and custom... 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
Pop Rivett Pop Rivett’s SQL Server FAQ No.4: Pop does Log Shipping Pop Rivett demostrates the fine art of log shipping in SQL Server.… 30 October 2006 8 min read
Phil Factor More Database Administration and Development Automation using DMO Phil Factor provides a handy DMO automation toolkit to take care of some core SQL Server administrative tasks.… 04 October 2006 2 min read
Pop Rivett Pop Rivett’s SQL Server FAQ No2: Pop Backs Up Pop leaps into action to safeguard a young girls's data...… 22 September 2006 5 min read
Hilary Cotter The identity crisis in replication This article discusses three common problems DBAs are likely to encounter when columns have an identity property that will auto-increment... 05 July 2005 16 min read
Brian Moran Tracking tempdb growth Runaway tempdb growth can be a problem, so how do you track its growth and correlate the growth to specific... 11 April 2005 4 min read
