Nigel Rivett Quick Tip: Performing an FTP rename in a SSIS script task Nigel Rivett provides a technique for moving files from one FTP directory to another, and for performing this processing from... 17 January 2007 5 min read
Phil Factor The Ultimate Excuse Database Is your IT project in trouble? Do you need to create a smokescreen so that no-one can pin the blame... 15 January 2007 11 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
Richard Mitchell A Database Development Model Using SQL Compare Richard Mitchell and Steven Davidson describe how they used Red Gate's database schema-comparison tool, SQL Compare, to develop the latest... 19 December 2006 9 min read
Robyn Page Robyn Page’s SQL Server Data Validation Workbench Robyn Page provides essential techniques for ensuring the validity of the data being entered into your SQL Server tables.… 11 December 2006 15 min read
Greg Larsen Building my First SQL Server 2005 CLR Greg Larsen provides a step-by-step tour of the hurdles he had to jump in building and deploying his first serious... 06 December 2006 9 min read
William Brewer Towards the Self-Documenting SQL Server Database William Brewer investigates an unsung hero in SQL Server, extended properties, and shows how to use them to create self-documenting... 01 December 2006 16 min read
Eric Brown Encryption without the Confusion Eric Brown demonstrates some practical encryption techniques in SQL Server 2005, to protect both your objects and your data.… 29 November 2006 14 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
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
Kirk Haselden SQL Server 2005 SSIS: Tuning the Dataflow Task Learn how to get maximum performance out of the dataflow task with an extract from Kirk Haselden's popular book on... 23 October 2006 18 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
Robyn Page Robyn Page’s SQL Server String Manipulation Workbench String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's... 19 September 2006 23 min read
Pop Rivett Pop Rivett’s SQL Server FAQ Pop Rivett dispenses pearls of SQL Server wisdom, this time tackling the setting of variables from dynamic SQL. Bah, humbug.… 18 September 2006 3 min read
Nigel Rivett Executing SSIS Packages Nigel Rivett demonstrates how to execute all SSIS packages in a given folder using either an SSIS control package, a... 30 August 2006 8 min read
Tony Davis SQL Server, PostgresSQL and Fish Curry An interview with Adam Machanic, discussing hot new features of SQL 2005, stored procedures, fish curry and mor… 16 August 2006 18 min read
