The butterflies were flying! This was my first presentation for Triad SQL PASS user group, and any group for that matter. I started attended our local SQL PASS chapter back in the fall of 2011 while I was between jobs.
Kevin Goode was the one who got me thinking about doing a presentation, and after I had a few months under my current position as DBA, I came up with a topic: how to work smarter as a DBA. I found that starting a new DBA position requires working on understanding your environment quickly without disrupting the day-to-day business. This presentation gives you insight into tools that keep our servers running smooth and the training that keeps me up to date of the latest trends.
Note: the files below were shared from Dropbox’s Public folder, which Dropbox retired in 2017, so they are no longer available.
Here is the link (no longer available) to the PowerPoint slides.
Here is the link (no longer available) to the DBA Standards Document.
Here is the link (no longer available) to the server specific install settings and configuration.
Here is the link (no longer available) to the backup script I use each night.
Here is the link (no longer available) to the server side security audit script.
Here is the link (no longer available) to the database side security audit script.
Here are the links to the setup scripts that are used after the install of SQL Server 2008 R2. Just edit the files based on your environment:
- Database Mail Configuration (no longer available)
- Fill Factor (no longer available)
- Linked Server (no longer available)
- Memory MIN MAX (no longer available)
- Security Disable SA (no longer available)
- Security Logins (no longer available)
- SQL Server Agent Operators (no longer available)
- SQL Server Agent Alerts (no longer available)
- Tempdb (no longer available)