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

Pop Rivett Pop Rivett
Pop 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 since the old days of v4.2 to v2005. 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.
Pop Rivett and the FTP directory
by Pop Rivett | 19 September 2007 |  5 comments |
Dr Pop Rivett diagnoses URL-Aphasia in an anxious and exhausted patient and divulges a technique of synchronising a local directory with a remote FTP directory, all in TSQL! Read more...
Pop Rivett and the Expanding Log
by Pop Rivett | 22 June 2007 |  4 comments |
Pop Rivett comes to the rescue when an expanding log file threatens the very existence of a young man's website... Read more...
Pop Rivett and the Case of the Rogue SPIDs
by Pop Rivett | 22 March 2007 |  5 comments |
A process in a complex database occasionally, and apparently randomly, manages to put table locks on vital tables. Several applications are brought to a complete halt. Armed with a T-SQL stored procedure, a violin and a keen investigative spirit, Pop Rivett tracks... Read more...
Pop Rivett and the Uncontrolled Release
by Pop Rivett | 15 February 2007 |  4 comments |
Pop Rivett offers a hard lesson in the dangers of an uncontrolled software release. Read more...
Pop Rivett and the Suspect Database
by Pop Rivett | 08 January 2007 |  14 comments |
When a 'torn page' error corrupts a SQL Server database, threatening the survival of some vital data and a mainly harmless colleague, our curmudgeonly hero jumps into action… Read more...
Pop Rivett's SQL Server FAQ No.5: Pop on the Audit Trail
by Pop Rivett | 03 November 2006 |  30 comments |
Pop provides a cunning, trigger-based technique for auditing the activity on SQL Server tables Read more...
Pop Rivett's SQL Server FAQ No.4: Pop does Log Shipping
by Pop Rivett | 30 October 2006 |  16 comments |
Pop Rivett demostrates the fine art of log shipping in SQL Server. Read more...
Pop Rivett's SQL Server FAQ No.3: Pop restores
by Pop Rivett | 28 September 2006 |  7 comments |
Pop describes a stored procedure for restoring the most recent full backup of a SQL Server database and then applying all transaction logs. Handy to have around in case of emergency... Read more...
Pop Rivett's SQL Server FAQ No2: Pop Backs Up
by Pop Rivett | 22 September 2006 |  4 comments |
Pop leaps into action to safeguard a young girls's data... Read more...
Pop Rivett's SQL Server FAQ
by Pop Rivett | 18 September 2006 |  10 comments |
Pop Rivett dispenses pearls of SQL Server wisdom, this time tackling the setting of variables from dynamic SQL. Bah, humbug. 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-2009 Red Gate Software
Site map | Become an author | Contact us