Basic SQL Server 2005 Book Recs Please

Hi all,

I'm relatively new to the SQL Server 2005 world and am looking for a good "overview" book to purchase. I'm in charge of everything from installation & maintenance to creating T-SQL and scheduling jobs.

I attended an administrative course, but need some guidance on some pretty basic topics like how to scheduling DTS packages, using SSIS, etc. Some seemingly simple tasks are missing for me without having a good reference guide. I'm a big fan of "show & tell" type reference manuals (like the missing manual).

Any suggestions will be appreciated!

 

[markros]

I haven't read this book myself, I just know one of its authors

http://www.microsoft-press.de/product.asp?cat0=15&idx0=2&gr=bücher&cnt=product&id=mp-2580&lng=1

 

[NuJoizey]

I found the Wrox Beginning Server 2005 Programming book to be pretty useful. It is geared more towards someone who is more of a programmer, but does cover some of the vital admin features. I think wrox also puts out a similar sister-like books geared towards the admin and reporting services side.

They are pretty quick reads with illustrative examples, that also serve as decent desk references. I seem to be going back to mine fairly often.

 

[LFCfan]

Back when I was starting out with Sql Server 2K, I was pleased with the SAMS Unleashed book. It was basic enough, but went into a decent amount of detail too, it might be worth you having a browse of the equivalent SQL2K5 book

As for SSIS, unless you're only planning on doing simple data imports/exports, you're probably better off getting a separate book for it, it's quite a big beast!

~LFCfan

 

[simian101]

I highly recommend "Murach's SQL Server 2005 for Developers".

Simi

 

[jrbarnett]

hblabonte,

Do you understand the fundamentals of relational databases (normalisation, DB design and general ANSI compliant SQL etc)? I'd say understanding that was far more important than understanding SQL server specifics, although both are very relevant to you.

For a start, DTS doesn't exist in SQL Server 2005. Its been replaced with SSIS.
You should at the very least download the latest edition of Books online from Microsoft and install that.

John

 

[NuJoizey]

also, you can sort messages in this forum by book recommendations. Try this link:

http://www.tek-tips.com/threadminder.cfm?tmac=ordtype&val=4&pid=183

it seems to have several.

 

[hblabonte]

Do you understand the fundamentals of relational databases (normalisation, DB design and general ANSI compliant SQL etc)? I'd say understanding that was far more important than understanding SQL server specifics, although both are very relevant to you.

For a start, DTS doesn't exist in SQL Server 2005. Its been replaced with SSIS. You should at the very least download the latest edition of Books online from Microsoft and install that.

John"

Yes, I've done database design work for years. I'm just transitioning from SQL Server 2000 to 2005. I know DTS doesn't exist in 2005 and has been replaced. Yes, I have books online installed. I'm simply asking for reference tools from fellow SQL 2005 users.

Thanks for the helpful reply.

 

[LFCfan]

I've just remembered - this FAQ might be useful to you:
faq183-3324

~LFCfan

 

[LFCfan]

Actually, scrap that - it's probably way out of date by now!

~LFCfan