Re: SQL Server Standards Documentation

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 14:23:11 -0600

yep. page 3 on up is missing. 

-- 
Keith
"MANCPOLYMAN" <MANCPOLYMAN@discussions.microsoft.com> wrote in message
news:656B8A96-25E4-4BA5-99F3-CEAD4F1F8111@microsoft.com...
> 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

  • SQL Server Standards Documentation
    ... 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: SQL Server Parameters
    ... I understand what SQL Server is doing and it is doing as ... > have a missing param or misspelled it, ... >> a SQL error back that Procedure XYZ is expecting Parameter '@myParameter' ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to enable Windows Authentication
    ... either your missing something or I am missing something and I ... Windows Local User accounts. ... I remove the comments from the connection string in the web.config I can ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Limit of 150 rows in a combobox?
    ... I can't find an answer to this in the newgroup postings, ... datasource is a SQL Server stored procedure. ... 200 rows when executed on SQL Server. ... Any advice on finding these missing rows would be most ...
    (microsoft.public.access.forms)
  • Re: Error 22272: Cannot load the DLL xpstar.dll...
    ... I would look for MSVCR71.DLL in SYSTEM32. ... I believe that if an entire DLL was missing, ... Reinstall the SQL Server tools? ...
    (comp.databases.ms-sqlserver)