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.

 

Here is your download link for SQL Doctor!

Please choose the file that meets your system requirements:

You’ll also receive a confirmation email with a download link for your product. To ensure email delivery, please whitelist [email protected]. If you do not receive your email, please be sure to check both your inbox and filters for a message from [email protected].

Topics :

Products :

Andy Warren

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.

Try SQL Diagnostic Manager for SQL Server FREE for 14 days


SQL Diagnostic Manager Repository dashboard

24X7 SQL performance monitoring, alerting and diagnostics

  • Monitor performance for physical, virtual, and cloud environments.
  • Monitor queries and query plans to see the causes of blocks and deadlocks.
  • Monitor application transactions with SQL Workload Analysis add-on.
  • View expert recommendations from SQL Doctor to optimize performance.
  • Alert predictively with settings to avoid false alerts.
  • View summary of top issues and alerts with the web console add-on.

Start for Free