A service from Red Gate
Home SQL .NET Exchange Opinion Blogs Forums About
Sign in  | Join  | Help
Authors  >  Nigel Rivett

Nigel Rivett Nigel Rivett
Nigel spent his formative years working in assembler on IBM Series/1 but retrained in VB when that went out of fashion. He soon realised how little relational database expertise existed in most companies and so started to spend most of his time working on that. He now sticks to architecture, release control / IT processes, SQL Server, DTS, SSIS, and access methods in VB/ASP/.NET/Crystal Reports/reporting services. He has been involved with SQL Server for about 10 years from v4.2 to v2005, and was awarded Microsoft MVP status in 2003. He tries to stay away from anything presentation oriented (see www.mindsdoor.net). Theoretically he is semi-retired but seems to keep being offered potentially interesting work.
Identity Columns
by Nigel Rivett | 12 May 2008 |  65 comments |
When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises. Read more...
Partitioned Tables in SQL Server 2005
by Nigel Rivett | 16 April 2007 |  35 comments |
Nigel Rivett provides an in-depth, practical examination of how to create and manipulate partitioned tables and indexes in SQL 2005. Read more...
Quick Tip: Performing an FTP rename in a SSIS script task
by Nigel Rivett | 17 January 2007 |  18 comments |
Nigel Rivett provides a technique for moving files from one FTP directory to another, and for performing this processing from SQL Server Integration Services. Read more...
Creating CSV Files Using BCP and Stored Procedures
by Nigel Rivett | 20 November 2006 |  50 comments |
Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing on a stored procedure approach that gives complete control of the format of the extracted data. Read more...
Executing SSIS Packages
by Nigel Rivett | 30 August 2006 |  54 comments |
Nigel Rivett demonstrates how to execute all SSIS packages in a given folder using either an SSIS control package, a stored procedure or a DOS batch file. Read more...
SQL Server 2005 Common Table Expressions
by Nigel Rivett | 02 August 2006 |  43 comments |
Common Table Expressions (CTEs) are one of the most exciting features to be introduced with SQL Server 2005. Nigel Rivett explains what they are and how they can be used. Read more...
Over 150,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk


Privacy policy | Terms and conditions | ©2005-2008 Red Gate Software
Site map | Become an author | Contact us