Allen White

Home SQL .NET Exchange Opinion Blogs Forums About

Authors > Allen White

Allen White
Allen White is a Database Administrator for Advanstar Communications, a publisher of B2B trade magazines and promoter of trade shows. He has worked as a Database Administrator, Architect and Developer for over 15 years, supporting both the Sybase and Microsoft SQL Server platforms over that period. He worked with Microsoft as a Subject Matter Expert (SME) on the certification exams and courseware for SQL Server 2005, and holds certifications Microsoft Certified Technology Specialist: SQL Server 2005, Microsoft Certified IT Professional:Database Developer, Microsoft Certified IT Professional:Database Administrator and Microsoft Certified Trainer (MCT). His blog site is reached at http://sqljunkies.com/Weblog/MarathonSQLGuy/default.aspx.

Automate your Database Integrity checks using SMO

by Allen White | 15 September 2007 |

4 comments |

Allen White shows how to use Visual Basic to create simple routines that use SMO for inserting and deleting jobs from SQL Server Agent and for creating or deleting stored procedures in SQL Server. Read more...

Alert-based Transaction Log Backups - Automate your database Maintenance Part 2

by Allen White | 20 April 2007 |

3 comments |

Part 2 of Allen White's "SQL Server Automation" series demonstrates how to use 'performance condition' alerts for more effective database log backups during periods of high database activity. Read more...

Automate your Database Maintenance using SMO

by Allen White | 05 April 2007 |

6 comments |

The most important thing you can do as a database administrator is perform regular database maintenance. This includes regular backups, database integrity checks and optimizations. In Part 1 of a three article series, Allen White shows how to automate the backup of... Read more...

Site map | Become an author | Contact us