Re: SQL Server Standards Documentation

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

Date: Tue, 16 Nov 2004 13:33:03 -0800

Keith,
Thanks for the wonderful insight. However I think you'll find that

> Purpose 2
>
> Table of Contents 2

covers Page 2 and Page 1 being the Title page.

Hope this clarifies the situation for you.

MPM

"Keith Kratochvil" wrote:

> 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

  • Re: Connet to SQL Server?
    ... illustrate or show examples of bad practices. ... William (Bill) Vaughn ... > "William Vaughn" wrote: ... >>>I am a newbie to both .Net and Sql Server and I am trying to access the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Keeping a DataView in Memory
    ... ADO and ADO.NET Examples and Best Practices is written for developers transitioning to ADO.NET and has a wealth of fundamental material for those getting started. ... The 7th Edition takes up where the ADO.NET E&BP book leaves off and talks about the ADO.NET that ships with VS 2005 and far more on SQL Server, the tools and how to design successful applications. ... Set your DataView properties to filter or sort as needed. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: To saga
    ... Use ADO when accessing a client/server (c/s) DB, like SQL Server. ... To make the app flexible, use catalogs for attributes that can vary. ... One thing is to have best practices for ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL SERVER DBA QUESTIONS.
    ... I also probe for the potential DBA's communication skills. ... DBAs talk to ... business people more often than most other IT professionals. ... I support the Professional Association for SQL Server, ...
    (microsoft.public.sqlserver.clients)
  • RE: MS SQL Data Warehousing and Oracle
    ... It is filled with best practices and things to ... think about when pulling data from Oracle databases for use in SQL Server. ... If you ever decide to migrate from Oracle to SQL Server you should check out ...
    (microsoft.public.sqlserver.datawarehouse)