Webcast : SQL Server Database Administration Tips, Tricks, and Best Practices
About this webcast:
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.
See Also:
- Datasheet: SQL Admin Toolset
- Video: SQL Admin Toolset Overview
- Video: How To Manage Logins and Security with SQL Admin Toolset
- Video: How To Manage SQL Server Configuration and Resources with SQL Admin Toolset
- Case Study: South Wales Police Department Improves SQL Server Management with IDERA
- TechValidate: SQL Admin Toolset
- TechValidate: American Imaging Management Inc.
- TechValidate: Associated Regional and University Pathologists, Inc.
- TechValidate: Brigham Young University
- TechValidate: City of Nashua
- TechValidate: Fiserv, Inc.
- TechValidate: International Business Machines Corporation
- TechValidate: Local Government Federal Credit Union
- TechValidate: Magentar Capital
- TechValidate: Questar Assessment, Inc.
- TechValidate: Tri Tech Group reduced time spent on daily SQL Server administration.
- TechValidate: Vancouver Island Health Authority
Topics :
Products :
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.
Complete SQL performance tuning and recommendations
- Easily monitor and improve the performance of SQL Server, Azure and AWS instances.
- Instantly locate real-time performance issues with Quick Findings.
- Improve performance with updated recommendations for SQL Server 2016 and 2017, Azure SQL Database, and Amazon RDS.
- Generate executable scripts to optimize performance.
- View trends from history of analysis recommendations.