Allen White

Allen is a Data Platform Consultant and owns his own consulting practice, DataPerf Professionals. He's been both a developer and an administrator so understands both perspectives towards database technology, and loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 45 years in IT and has been using SQL Server since 1992. Allen has been awarded Microsoft’s MVP Award for the last thirteen years, and was a PASS Director from 2016 through 2018.

13 February 2009
13 February 2009

Let PowerShell do an Inventory of your Servers

If you run a regular and comprehensive inventory of all the servers you manage, you can solve problems more quickly and answer most questions from management. If you then repeat these reports over a time period, it helps to to track trends such as disk space usage so you can spot trouble before it becomes a problem. Allen describes a PowerShell script to do the inventory.… Read more
05 April 2007
05 April 2007

Automate your Database Maintenance using SMO

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 all of your databases, using SQL Server Management Objects (SMO) and either native backup or Red Gate's SQL Backup tool.… Read more