DBA Basics – Intro to Database Maintenance

 

About the Presentation

Performance tuning, index design, etc… these are great skills to have, but there are four basic tasks that every DBA should know how to do backwards and forwards without even thinking about it. They are, in this order: Restore, Backup, Index Maintenance, and Consistency Checking. After attending this session, you will be able to restore a database in a few different ways, take the right backups in order to restore that database, know how and when to maintain the indexes and statistics, and check for database corruption.

DBA Basics - Intro to Database Maintenance

Presentations (Upcoming & Past)

About the Author

Data Platform Consultant

David Maxwell

David Maxwell is a Principal Consultant at UpSearch.

David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.

Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions.  David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.

Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.

In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.

Learn more about David Maxwell at https://upsearch.com/david-maxwell/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *