Richard Vantrease

Richard is lead SQL Server DBA for a large organization in Vancouver Washington. He has worked with SQL Server for 15 years both as a developer and as a DBA. He has a wide range of experience in IT ranging from desktop support, server administration, network administration, development and database administration. Currently he is specializing in SQL Server Administration, Data Architecture and Automation.

Database Administration

Incrementally shrinking a large SQL Server data file using PowerShell (last update: 3/6/2014)

DBA Best Practices

SQL Server Hardware Configuration Best Practices (last update: 5/20/2014)

PowerShell

Check SQL Server Database Consistency and Backups Without Impacting Performance (last update: 1/21/2014)
Monitor SQL Server Disk Space Using PowerShell (last update: 1/13/2014)