SQL Server Standards Documentation

From: MANCPOLYMAN (MANCPOLYMAN_at_discussions.microsoft.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 12:21:02 -0800

A colleague has created a document and has asked me to review it. It all
looks good to me but I am just wondering are we missing anything obvious.

Thanks In Advance.

Brian

BTW - any links to articles / examples would be welcome as well.

Here's the contents page.

===========================================================

Purpose

The purpose of this document is to outline SQL Server standards and best
practices for our IT dept. These standards and best practices will be used to
assist in stabilizing our IT dept's production SQL Server environment and
therefore reducing the number of potential harmful issues. In addition, it
will allow the DBAs to respond more quickly and proactively. This should be
considered a "living document," developed by the contributions of many DBAs
in our IT dept organization. The intended audience is relevant our IT dept
personnel and audit personal for the audit or described systems. While all of
the guidelines should be followed, there may be instances where a particular
recommendation does not apply.

 

Table of Contents

Purpose 2

Table of Contents 2

Hardware / Operating System Configurations 3

Server Specs 3

OS Specs 3

Security / Firewalls / Ports 3

Auditing and Logging 3

Storage Configurations 5

SQL Server Installations & Configurations 6

General 6

Patches 6

Services 6

Protocols 6

Ports 6

Accounts 6

Files / Directories / Shares 7

Registry 7

SQL Server Security 7

Databases 8

Tables 8

Indexes 9

Full Text Indexing 9

Stored Procedures 9

DTS Packages 9

SQL Server Jobs 10

Linked Servers 10

SQL Mail 10

Backups & Restores 10

Implementing Builds / OCCs 11

Monitoring / Alerts 11

Replication 11

Installations 11

Enterprise Edition Installation Screenshots 12

Standard Edition Installation Screenshots 22

Developer Edition Installation Screenshots 32

Relevant Pages

  • Re: SQL Server Standards Documentation
    ... > looks good to me but I am just wondering are we missing anything obvious. ... > The purpose of this document is to outline SQL Server standards and best ... > Hardware / Operating System Configurations 3 ... > Enterprise Edition Installation Screenshots 12 ...
    (microsoft.public.sqlserver.server)
  • Re: Why will we never see anything even remotely resembling decent standards compliance in SQL Serve
    ... > it is a considerable undertaking to cram in all the features that would ... *Anyone* who writes any code for SQL Server should demand standars compliance ... SQL Server already uses such mechanisms to govern code-breaking standards ...
    (microsoft.public.sqlserver.server)
  • Re: Persisting ADO as XML - almost convinced im crazy!
    ... bah, stupid non standards ... lol .. ... all hail .NET ... > Columnist, SQL Server Professional ...
    (microsoft.public.vb.database.ado)
  • Re: Sql2k, Performance and Junction Points
    ... Better performing? ... > d:\ SQL Server Executables ... > e:\ Database Files, tempdb. ... > the SQL Server configurations are the same. ...
    (microsoft.public.sqlserver.setup)
  • Re: datetime month question
    ... Learn to write code to Standards; it will save you and the ... poor bastards that have to maintain code a lot of problems. ... totally different way than SQL Server, ... MySQL has a dialect convention that zeros in the month or ...
    (microsoft.public.sqlserver.programming)