SQL Server Administration Presentation
A "PowerPoint-less" presentation on SQL Server Administration for new DBAs and non-DBAs.
This session walks through a SQL Server installation, the post setup configuration, a basic security review, configuring a maintenance plan and basic performance monitoring. All with no PowerPoint slides. Instead we'll walk through our SQL Server setup and configuration checklist and demonstrate everything we talk about. This session is great for new database administrators or part-time DBAs or anyone looking for a refresher. Experienced DBA's will learn something too! You'll get a copy of the checklist during the session and you'll get a link to download a copy for later. Some of the interesting things you'll learn during the session are:
- Why the Shrink Database maintenance plan task doesn't really shrink the database. And why you shouldn't shrink a production database anyway.
- Which database always needs its recovery model changed after installation?
- What free utility you can use for maintenance on the free Express Edition of SQL Server
- What is the most common mistake people make when configuring SQL Server Agent to send job notification failures
You can download the SQL Server Configuration checklist and related presentation.