Explore all the products and find the right solution for your business
Proactively manage server performance on-prem or in the cloud with timely alerts and analytics
Fast configuration of regulatory and audit compliance settings with proactive monitoring, alerts, and reporting
Automated database security, monitoring and management for MS SQL, Azure and Amazon RDS for SQL Server
Backup and instant recovery for SQL Server, Azure Blob Storage and Amazon S3
Discover, track and manage database inventory across the entire environment
24 Essential tools to simplify daily server administration
Get the right solution to keep your database running at peak performance.
All of the support you need at your convenience.
Database administration can be deceptively simple and amazingly simple, so many of us worry that we've forgotten to do some bit of standard maintenance or worse, that we've forgotten to enable the TURBO switch.
This fast paced presentation is going to run through a number of common things that you should be doing to keep your server in top shape. We'll review the standard maintenance steps like backups and index maintenance, best practices for granting and managing access, basic disaster recovery planning, and we'll talk about some easy to miss stuff like trimming the SQL agent job history and the SMTP email log. We'll finish up with a discussion of some free resources that can every DBA should know about.
Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.
Topics: Database Diagnostics Products: