Reference for SQL SERVER 2000

Hello there everyone!!

I've just joined this community and already feel alot better in doing so!!

My question is aimed at SQL Server 2000. Part ofmy job role has swicthed to SQL Developer to Database Administrator.

To learn SQL Server 2000 (latest version available to me) I wanted to find out about courses (based in London, UK) which help teach along the lines of the following topics:

Fundamental concepts

SQL Server installation and upgrade

Database management

Backup and recovery

Alerts and jobs

Security

Replication

Monitoring SQL Server

Converting and migrating data

This is what I understand to be prior importance for the role.

My main question to you guys: Can anyone recommend a reference book which is a good desktop companion which covers all of these topics to detailed depth?

I'm running SQL Server 2000 on Windows 2003 Server. I'm aware some books may be old, but the later they are the better?

I've studied SQL at uni, covering RDMS, OLAP, Data manipulation, Data Definition. But now its to be applied to SQL SERVER 2000

Any suggestions please?

Thank you for your support

5SP

Hello!!!

Seems to me the masterminds must be asleep!!!

I just wanted some reference book names which people have used and would refer as good books to have?

Please? Anyone on here?

|||

Due to time zone differences, short waits for responses are normal...

Reference:

Inside SQL Server, Kalen Delany

All three of Ken Henderson's 'Guru...' books

Desktop Companion:

Administrator's Companion (MS Press),

Whalen, et. al., SQL 2000 Performance Tuning (MS Press)

|||

Hello!!

Ok I will need to be a bit more parient in future!!

Thank you for your advice, I will look into these books

|||

Hello again!

I've had a chance to look at those books and they seem pretty good. The first book you described seems to be more of a reasoning book rather than helping me get traned or gain knowledge in this field.

In the previous message, were I listed the topics I wanted to learn and apply at work, I think its probably best to look towards a 'how-to' and 'reference' book rather than a reasoning book...

Would there be another one you think? The Sams Teach yourself SQL server 2000 in 21 days seems to be good, have you any experience of that book?

On another note, I'm aware that Transact-SQL is Microsoft's version of SQL to be considered for SQL Server.

How different is it from othe SQL standards? My knowledge of SQL querying/programming so far is data transaction/manipulation?

Many thanks,

5SP

|||

For me, what you refer to as a 'reasoning' book (Kalen's Inside SQL Server), is one of my primary 'reference' materials. (I thought you asked for a 'reference' book, but it now seems like you want 'learning' materials.

You might find Wrox Press' SQL Professional 2000 for to be a useful 'learning' resource. If the '21 Days' or 'Dummy's' books work for you, there is nothing wrong with them.

All vendors have extended the basic ANSI SQL language for their products. Just about any 'SQL' other than the basic SELECT/INSERT/UPDATE/DELETE is an 'extension' particular to that specific vendor. There are those that espouse writing ONLY ANSI SQL code so that the server is interchangable. My opinion is that if is like eating only raw fruits and vegetables when traveling. Yes, you will survive, your nutrition needs will be ok -BUT you loose the unique 'flavor' of the area visited. If you are supporting SQL Servers, learn and get comfortable with T-SQL. And when you have to deal with Oracle servers, learn and get comfortable with PSQL.