Could someone pls suggest a good book for advance topics
on SQL Server. Just to give you an idea... a book that
might cover

1) Common SQL upgrade errors and fixtures
2) How to move tempdb from one physical location to another
3) Understanding registry settings for SQL Server
3) Other advance tips and tricks

Thanks in advance.
Adam

Report this post to a moderator

Try

Admin911 SQL Server 2000 by Brian Knight
ISBN:0072130970
Publishe: Osborne

"Adam" <akhan8444_us@hotmail.com> wrote in message
news:00a301c2ea53$de3f22e0$a30
1280a@phx.gbl...
> Could someone pls suggest a good book for advance topics
> on SQL Server. Just to give you an idea... a book that
> might cover
>
> 1) Common SQL upgrade errors and fixtures
> 2) How to move tempdb from one physical location to another
> 3) Understanding registry settings for SQL Server
> 3) Other advance tips and tricks
>
> Thanks in advance.
> Adam

Report this post to a moderator

Awesome! Checked out Amazon.com for this book. People have
put in good reviews for it. Thanks a bunch.

Adam

>-----Original Message-----
>Try
>
>Admin911 SQL Server 2000 by Brian Knight
>ISBN:0072130970
>Publishe: Osborne
>
>"Adam" <akhan8444_us@hotmail.com> wrote in message
> news:00a301c2ea53$de3f22e0$a30
1280a@phx.gbl...
>> Could someone pls suggest a good book for advance topics
>> on SQL Server. Just to give you an idea... a book that
>> might cover
>>
>> 1) Common SQL upgrade errors and fixtures
>> 2) How to move tempdb from one physical location to
another
>> 3) Understanding registry settings for SQL Server
>> 3) Other advance tips and tricks
>>
>> Thanks in advance.
>> Adam
>
>
>.
>

Report this post to a moderator

I used the SQL Server 2000 weekend crash course and the Microsoft SQL server pocket companion to get started. I installed a SQL Server innstance in lab on a W2K OS and played with it for about 40 hours.

I then got the Admin 911 SQL Server 2000 book and played and learned the more advanced concepts for about another 40 hours.

I then got the SQL Server 2000 Unleashed book and played and learned the new concepts in there for about another 40 hours.

I had a couple of fellow techies that were taking the 228 and 229 exams at the same time as I was so we were private emailing back and forth about whether this was the right approach or this other approach was the right one.

They were tough exams for me because I was really interested in learning the material, And the coding required is just hard for me to grasp. Seems to me I get the networking stuff right off the bat but the coding stuff I have to think about. well that's my 2 cents anyway.

__________________
MCSE, MCDBA, CNA, A+, Network+, I-NET+, CIW Security Analyst Professional, MCSA

There is no such thing as a wrong opinion.

Report this post to a moderator