Are you performing all of the regular maintenance you should on your servers?
Do you not run CHECKDB because "it takes too long"? How about Index Maintenance - does that take too long?
Do you really have the appropriate backups in place?
Do you have benchmark numbers in place to compare when your server is "slow
Come discuss the answers to these and other questions - we will discuss the free Maintenance Solution scripted tools from Ola Hallengren and how they can help you fix these and other problems with a little easy coding you can do yourself. We will also discuss other tips and tricks to help you maintain and troubleshoot your SQL Server instances.
I'm a forty-something Microsoft SQL Server DBA of 12+ years, a devoted husband, and a father of two young boys (with another coming soon!). I have been a DBA at a university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States.
I just received confirmation I will be speaking at SQL Saturday 307 in Iowa City on June 7th!
I will be giving an updated version of my Ola Hallengren Maintenance Solution talk that I have given at a few previous SQL Saturdays, re-titled "Are You Maintaining Your SQL Servers?"
SQL Saturdays are awesome training and networking experiences - the full schedule hasn't yet been published but there were multiple Microsoft MVP's on the submissions list. For only a $10 lunch fee you can spend the day learning about SQL Server and networking with your peers.
Register now and I hope to see you there!