Managing Your SQL Server When You Don't Have A DBA
Not everyone has a full time Database Administrator on staff, and in many cases the responsibility of managing the SQL Server falls on you, the developers. But as long as the backups are running successfully you're good, right? Not exactly. Your databases could be heading for trouble! Without proper tuning and maintenance, your database performance can grind to a halt. Tailored to the "Non-DBA", this session will show you how to configure your Microsoft SQL Server like a DBA would. Discussing server settings, database configurations, and recommended maintenance, you will leave this session with the knowledge and scripts you need to help tune SQL Server to fit your workload, fix some performance problems you may not even realize you're having, and help ensure that your databases are running smoothly.
About Eric Cobb
Eric Cobb is a seasoned IT professional with extensive experience in advanced application and database development. After a 14 year programming career as a web and software developer Eric moved into the world of databases, earning his Microsoft Certified Solutions Expert (MCSE): Data Platform certification, and now works as a Sr. level Database Administrator in Nashville, TN. Eric regularly presents and blogs about SQL Sever, with a focus on teaching database administration and design concepts to the developer community.
Follow Eric Cobb on Twitter