Need book recommendation :)

Hi dudes,
I am very new to mssql. Can anyone recommend me a mssql book to start with? And any handy tool I can use to do the database programming? I mean something like SQL Navigator etc for mssql? Hope it is easy to work with mssql .

Many thanks.


dave

I started with the first edition of this book:
http://www.amazon.com/exec/obidos/t...=glance&s=books

Taught me database design basics.

Also check out MySQL Cookbook, also by the same Mr. Dubois

Websites - webmonkey.com, our dear devshed of course and google.

Have a great journey!!

Good point bambam, apart from the fact that he is looking for a book about MSSQL not MySQL.

I would suggest:
Google
Databasejournal
and of course BOL (that come with MSSQL)
any book for Ms certification on SQLServer

oi thats embarrassing ... smoke bomb ninja exit ... *fhachinggg ...

Thanks both of you

I get a question. When I was working on Oracle. I used SQL Navigator to browse around the programming codes and updated the code easily. I am wondering you guys any trick to view/work with the programing codes easily? All I can use so far is the Query Analyzer of the MS SQL. It is not handy at all...

And by the way, what is BOL?

Thanks again.


dave

BOL = Books OnLine (comes with MSSQL Server as stated in the thread).

BamBam mentioned MySQL Cookbook but what about Transact SQL Cookbook. I have it on order but I haven't seen it yet so I don't know how handy it can be.

I am also using Microsoft SQL Server 2000 Administrator's Companion which is very handy to have.

http://www.ems-hitech.com/msmanager/

EMS MS SQL Manager is nice if you're willing to pay for it.

Also there is a book by Dejan Sunderic called SQL Server 2000 Stored procedure & XML Programming is pretty nice if you're more interested in programming instead of administration.....

Thanks all of you. You guys are lovely

When you are doing programming, what can you do? How do you add/update your stored procedures or how do you create/change your tables? Where can you do the jobs?

"Enterprise manage" which is appart ot MsSQL allows you to edit everything, design tables, run SQL, edit/update store procedures, view tables etc. the only thing is while a store procedute is open other functionality is disabled. other than that it does just about everything, Sorry if this isnt what ur asking.

If you come from Oracle and are used to TOAD you can take a look at TOAD for Ms SQL

Thank you guys