Configuration

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.

Here is the link to the PowerPoint slides.

Here is the link to the DBA Standards Document.

Here is the link to the server specific install settings and configuration.

Here is the link to the backup script I use each night.

Here is the link to the server side security audit script.

Here is the link 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
• Fill Factor
• Linked Server
• Memory MIN MAX
• Security Disable SA
• Security Logins
• SQL Server Agent Operators
• SQL Server Agent Alerts
• Tempdb