I’m presenting at the Kansas City SQL Server User’s Group on Thursday, August 13th at Johnson County Community College. Check the monitors when you arrive for the room. We start at 6PM with 30 minutes of announcements and such. I’ll be starting at 6:30PM. I’ll probably go for 60-90 minutes.
I have seven PowerPoint slides to open and close the session. All the rest is going to be an ongoing demonstration of installing SQL Server and doing the post-installation configuration. I’ll have my SQL Server installation and configuration checklist as a handout for you to follow along and take notes.
This is the abstract I sent in to describe the session:
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 my SQL Server setup and configuration checklist and I’ll demonstrate everything I’m talking 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
I’ve delivered this session before and received good feedback. The “PowerPoint-less” format went over very well. There’s lots of information for people that are part-time or new SQL Server DBAs. I also cover enough depth to provide value to more experienced database administrators.