471,090 Members | 1,311 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

Upgrading MY preformance

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.
Jul 20 '05 #1
1 1212
Hi

You should take time to read books online:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\adm
insql.chm::/ad_mon_perf_00mr.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" <vn****@hotmail.com> wrote in message
news:ba**************************@posting.google.c om...
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.

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by S. Crespel | last post: by
1 post views Thread by bartolomesintes | last post: by
6 posts views Thread by Michael Foord | last post: by
2 posts views Thread by wellington fan | last post: by
5 posts views Thread by Mike Owen | last post: by
11 posts views Thread by Aidan Tobin | last post: by
1 post views Thread by progTiger | last post: by
reply views Thread by nondos | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.