YOUR CHANNEL IS LOADING
  • 1

    Provisioning

  • 2

    Trusting Systems

  • 3

    Understanding HA

  • 4

    How do you solve T-SQL problems?

  • 5

    Morphing Microsoft

The Voice of the DBA The Default DBA

MEVIOtoday

Dec 03, 2012 The Default DBA

When we setup SQL Server, there are a few choices we need to make, some of which require a few items be prepared in advance. Service accounts are one of those preparation tasks that DBAs usually perform in advance of installing an instance. There are a few things, however, that aren't configured when SQL Server is installed, like alerts and operators. I find that often these items can be missed by inexperienced DBAs, who forget to configure standard alerts. They might also not have a mail account ready, which is required for the instance to send mail.

Perhaps there's a better way for SQL Server to request this information when it is installed. If one part of the setup program asked for default mail information, it would be easy to pre-configure the instance to setup alerts and enable them for communication with a DBA. Personally I'd prefer that setup get a mail profile and a default DBA group email address that receives information about the operation of the instance that the DBA should be aware of.

 

Read the rest of "The Default DBA" at SQLServerCentral.

Â