Down and dirty database infrastructure

Does any have a link, or know of an MS book(s) that details the
underlying database structure, tables, processes? Something that
explains in detail how/why this stuff is configured and works, like
DDL, TDS, varchar, int, index, tables, normalization, DML, Primary
Key/Foreign key.Beeker (sqlserver2005dba@.gmail.com) writes:
> Does any have a link, or know of an MS book(s) that details the
> underlying database structure, tables, processes? Something that
> explains in detail how/why this stuff is configured and works, like
> DDL, TDS, varchar, int, index, tables, normalization, DML, Primary
> Key/Foreign key.

Sounds like you are looking for "Inside SQL Server 2000" by Kalen
Delaney.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks much.

The review, on Barnes and Nobel (
http://search.barnesandnoble.com/bo...isbn=0735609985
), on her treatment of internals and other vaulable info are very
critical.

Then the Amazon comments praise her.
(
http://www.amazon.com/gp/product/07...406348?n=283155
).

Comment?|||"Beeker" <sqlserver2005dba@.gmail.com> wrote in message
news:1143721430.783394.148200@.t31g2000cwb.googlegr oups.com...
> Thanks much.
> The review, on Barnes and Nobel (
http://search.barnesandnoble.com/bo...isbn=0735609985
> ), on her treatment of internals and other vaulable info are very
> critical.
> Then the Amazon comments praise her.
> (
http://www.amazon.com/gp/product/07...406348?n=283155
> ).
> Comment?

She knows her stuff. Extremely knowledgeable. Get the book.

You want a book on XML, there are definitely better ones.|||Thanks Strider.

Domain group server access?

Hi,
If a user needs access to a databases and I carry out the following steps:
1) Create a domain group
2) Put the users login details in this group
3) Give the domain group access to SQL Server via Enterprise Manager
4) Give the domain group database access via Enterprise Manager
Do I also need to give this domain group direct server access by adding it
to a group in:
Computer Management\Local Users and Groups\Groups ?
Ta
wendyalso, we are using active directory.
wendy
"Woo" wrote:

> Hi,
> If a user needs access to a databases and I carry out the following steps:
> 1) Create a domain group
> 2) Put the users login details in this group
> 3) Give the domain group access to SQL Server via Enterprise Manager
> 4) Give the domain group database access via Enterprise Manager
> Do I also need to give this domain group direct server access by adding it
> to a group in:
> Computer Management\Local Users and Groups\Groups ?
> Ta
> wendy|||No you don't need to give OS level permissions on the server
that is running SQL Server for the group to access SQL
Server. You only need to add the windows group to the SQL
Server logins (and whatever databases).
-Sue
On Fri, 3 Nov 2006 04:14:02 -0800, Woo
<Woo@.discussions.microsoft.com> wrote:

>Hi,
>If a user needs access to a databases and I carry out the following steps:
>1) Create a domain group
>2) Put the users login details in this group
>3) Give the domain group access to SQL Server via Enterprise Manager
>4) Give the domain group database access via Enterprise Manager
>Do I also need to give this domain group direct server access by adding it
>to a group in:
>Computer Management\Local Users and Groups\Groups ?
>Ta
>wendy|||And you will have to give the windows group permissions to access tables,
views, stored procedures, etc.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:bcjmk2h4eoundvep74genb5d43ldjveog2@.
4ax.com...
> No you don't need to give OS level permissions on the server
> that is running SQL Server for the group to access SQL
> Server. You only need to add the windows group to the SQL
> Server logins (and whatever databases).
> -Sue
> On Fri, 3 Nov 2006 04:14:02 -0800, Woo
> <Woo@.discussions.microsoft.com> wrote:
>
>