Mike EastlandMike has been a SQL Server DBA since 1999. His main areas of interest are monitoring and the automation of administrative tasks. Title Category Date SQL Server Performance Tuning Tip – Index Foreign Key Columns Indexing2016-05-26 Enable SQL Server Instant File Initialization for Time Savings DBA Best Practices2016-05-24 Monitor Remote SQL Server Instance Availability Monitoring2015-05-19 Monitor SQL Server Transaction Log File Free Space Monitoring2015-05-12 SQL Server DBCC CHECKDB, CHECKCATALOG and CHECKALLOC for VLDBs Database Console Commands DBCCs2015-01-28 Fix SQL Server Log Shipping After a New Database File has been Added Log Shipping2014-01-22 Search multiple SQL Server Error Logs at the same time Monitoring2014-01-10 SQL Server Database RESTORE WITH MOVE or not WITH MOVE Restore2013-11-22 Monitoring SQL Server Disk Space Monitoring2013-04-19