Best Books

[powen]

I am looking for the best book titles to find information on how to do the following:

Setup/Administer a Microsoft 2000 SQL Server
Setup/Administer a Microsoft 2000 IIS Server
How to perform SQL queries using XML

I am trying to interface a Linux machine directly with MS2000 SQL using XML. Since I have never setup any Microsoft servers, it would be best to learn how and build a test machine that works simular to the actual production servers.

After 2 weeks of indept searching, it appears there are no real easy way to interface Linux with MSSQL without installing a lot of software. Unfortuantely that is not an option on this end... The only option available is to use XML.

If anyone can suggest any books and/or URLs that would point me in the right direction, I would greatly appreciate it.

 

[osjohnm]

Hi powen

For SQL Server you can have a look at Books Online which you can install with SQL Server.

As for books written by other authors you could have a look at Sam's Teach Yourself SQL Server 2000 in 21 Days which will give you a good introduction and over all view of SQL Server 2000. It will also show you how to backup, restore etc in Enterprise Manager and through SQL scripting.

There is also a book called SQL 2000 Server The Complete Reference which I read about on the net which seems quite good.

The SQL Server 2000 Bible from the whole "Bible" series (Oracle, Visual Basic, Photoshop etc) is due to be released in November.

Do a serach on Amazon and read some of the reviews of each book. Here is a list of sql server websites where you can find articles about SQL Server:

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

http://www.sqlservercentral.com

http://www.swynk.com

http://www.databasejournal.com

The website articles target audiences range from beginners to advance.

About Linux, I don't work with Linux and have only a little bit of Unix exposure so unfortunately I am unable to assist you there. Look in the rest of the forums for Linux forum, maybe someone there could assist you.

Hope that helps
John

 

[SQLSister]

YOu might check out The Guru's Guide to SQL Server Stored PRocedures, XML, and HTML by Ken Henderson

You might also look at the Microsoft Press study guides for Exam 70-228 and Exam 229

 

[powen]

Thanks. I appreciate the help.