Upgrading MY preformance

[Vincent Jones]

Hello all! I'm a newly appointed database administrator and have been
struggling with my consious about what would make me an excellent
database administrator. I've worked in Access for years and know that
if your comfortable with:
1. writing expressions
2. writing some VBA
3. the basics with Tables, Forms, Queries and Reports.

and you'd be sitting pretty. SQL Server is a little more robust than
Access and i'm not sure where I should start.

I'm comfortable with writing T-SQL statments, backing up, and creating
users. but other than that, i'm a little lost on what else i should
know.

thanks.

[John Bell]

Re: Upgrading MY preformance

Hi

You should take time to read books online:

mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m
insql.chm::/ad_mon_perf_00m r.htm

If you wish to persue this further then you may want to buy some books, of
which there are many including among others:

SQL Server 2000 Performance Turning Technical Reference ISBN 0-7356-1270-6
Inside Microsoft SQL Server 2000 by Kalen Delaney ISBN 0-7356-0998-5

Magazines (among others) such as:

http://www.sqlmag.com/

http://www.pinpub.com/html/main.isx?sub=35

Sites (among others):

http://www.microsoft.com/sql/default.asp

http://msdn.microsoft.com/

http://www.sql-server-performance.com/

http://www.sommarskog.se/

John

"Vincent Jones" <vncntj@hotmail .com> wrote in message
news:ba2a2d30.0 312311059.78225 f83@posting.goo gle.com...[color=blue]
> Hello all! I'm a newly appointed database administrator and have been
> struggling with my consious about what would make me an excellent
> database administrator. I've worked in Access for years and know that
> if your comfortable with:
> 1. writing expressions
> 2. writing some VBA
> 3. the basics with Tables, Forms, Queries and Reports.
>
> and you'd be sitting pretty. SQL Server is a little more robust than
> Access and i'm not sure where I should start.
>
> I'm comfortable with writing T-SQL statments, backing up, and creating
> users. but other than that, i'm a little lost on what else i should
> know.
>
> thanks.[/color]