Saturday 19th March, 2016
4:30pm to 5:45pm
Session Level: 200
You carefully search for errors in the logs daily and fix them as they come. Recently, you noticed some errors are reoccurring and wonder when they started and what you could do differently. However the logs have already recycled and the information is gone, so you are left with the inquiry and go on with the next task. In this session, you will learn how to automatically parse the errors from multiple SQL error logs using PowerShell, store the data in a central database, and create reports to visualize the information using SQL Server Reporting Services. Analyzing error trends will allow you to see solutions that will lead to greater process efficiency.
Senior DBA at Micron Technology bio from LinkedIn
Paul is a Senior Database Administrator at Micron Technology Inc. where he started working with databases since 2000.
He is a Microsoft Certified Master in SQL Server 2008 and specializes in performance troubleshooting, automating DBA tasks, and managing large data centers.
Sign in to add slides, notes or videos to this session