Tips on Managing Lots of SQL Servers


Download12
Stock
File Size1.24 MB
Create DateJune 12, 2017
Download

Summary
To gain tips to be able to easily manage a lot of SQL Servers.

Abstract
When managing a single server it is easy to keep track of the configuration of that server, but what about when you have more than ten servers to manage or a hundred? How do you know they are setup correctly? How do you maintain the databases on each server? How do you take care of patching? How do you know when your server is on fire?

In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.

  1. Goals
    Learn the pain points of having a lot of SQL Servers to manage.
    Learn what scripts can be utilized to make it easier to manage a lot of SQL Servers.
    Learn tools that make it easier to manage a lot of SQL Servers.
Tracy Boggiano
Follow me

Tracy Boggiano

Database Administrator at ChannelAdvisor
Tracy has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Platform. She has worked on SQL Server 6.5 and up including currently SQL 2017 CTP 2.0. She enjoys monitoring, performance tuning, and disaster recovery technologies.

She also tinkered with databases in middle school to keep her baseball card collection organized.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through http://www.casaforchildren.org.
Tracy Boggiano
Follow me