Hi all,

What version of SQL Server I need to install for preparing MCDBA?

is "Developer" version enough?

or I need "Enterprise" version"?

do I need to setup network (2 computer?) or stand alone is enough?

are there many questions about "Replication" in the exams?

which book is good to learn about "performance tuning and optimisation"?

Thanks a lot for your comments, advices.

anthony

Report this post to a moderator

You should have direct experience with real SQL Server.

For preparation, you should have at least SQL Server evaluation version.
Enterprise version is not really needed. If you use "online simulation", you
do not need real SQL Server, but I never recommend this.

One is good enough (SQL 2000 allow multiple instances), but two is better.
You can play with replication and linked servers across the LAN cable.

There is not much questions about replication, but you should not give up
this section. Replication is difficult when you have no real experience. If
you have used some, it is not too difficult.

Many good topics are in Book On-Line.

Somchai

"anthony" <anthony@allette.com.au> wrote in message
news:OjCiEYMyCHA.2868@TK2MSFTNGP12...
> Hi all,
>
> What version of SQL Server I need to install for preparing MCDBA?
>
> is "Developer" version enough?
>
> or I need "Enterprise" version"?
>
> do I need to setup network (2 computer?) or stand alone is enough?
>
> are there many questions about "Replication" in the exams?
>
> which book is good to learn about "performance tuning and optimisation"?
>
> Thanks a lot for your comments, advices.
>
> anthony
>
>

Report this post to a moderator

I advise the "Microsoft SQL Server Performace Optimization and Tuning
handbook" by Ken England. It's an excellent book and it thought me a lot
about indexes, more than "Inside SQL Server" even (which has also a good few
chapters on tuning btw)

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


"anthony" <anthony@allette.com.au> wrote in message
news:OjCiEYMyCHA.2868@TK2MSFTNGP12...
> Hi all,
>
> What version of SQL Server I need to install for preparing MCDBA?
>
> is "Developer" version enough?
>
> or I need "Enterprise" version"?
>
> do I need to setup network (2 computer?) or stand alone is enough?
>
> are there many questions about "Replication" in the exams?
>
> which book is good to learn about "performance tuning and optimisation"?
>
> Thanks a lot for your comments, advices.
>
> anthony
>
>

Report this post to a moderator

dude..

If you have developer edition, use it.. developer can pretty much do
anything enterprise can. 1 pc is fine, just install 2 instances of sql.

to get through this exam know T-SQL, practice it.. there are loads of
question on syntax.
also many on when to use views and when stored procedures..
know XML and it's syntax....

otherwise don't panic it's a fair exam.. not to difficult not to easy..

Rob..

Wrote and passed today YEAHH!!!
"anthony" <anthony@allette.com.au> wrote in message
news:OjCiEYMyCHA.2868@TK2MSFTNGP12...
> Hi all,
>
> What version of SQL Server I need to install for preparing MCDBA?
>
> is "Developer" version enough?
>
> or I need "Enterprise" version"?
>
> do I need to setup network (2 computer?) or stand alone is enough?
>
> are there many questions about "Replication" in the exams?
>
> which book is good to learn about "performance tuning and optimisation"?
>
> Thanks a lot for your comments, advices.
>
> anthony
>
>

Report this post to a moderator

Hi Jacco,

This is one of my favorite books. I used it to study for both 228 and 229.
More than that it helped me a lot at my job.

Danut

"Jacco Schalkwijk" <NOSPAMjaccos@eurostop.co.uk> wrote in message
news:#wcoJYRyCHA.2532@TK2MSFTNGP10...
> I advise the "Microsoft SQL Server Performace Optimization and Tuning
> handbook" by Ken England. It's an excellent book and it thought me a lot
> about indexes, more than "Inside SQL Server" even (which has also a good
few
> chapters on tuning btw)
>
> --
> Jacco Schalkwijk MCDBA, MCSD, MCSE
> Database Administrator
> Eurostop Ltd.
>
>
> "anthony" <anthony@allette.com.au> wrote in message
> news:OjCiEYMyCHA.2868@TK2MSFTNGP12...
> > Hi all,
> >
> > What version of SQL Server I need to install for preparing MCDBA?
> >
> > is "Developer" version enough?
> >
> > or I need "Enterprise" version"?
> >
> > do I need to setup network (2 computer?) or stand alone is enough?
> >
> > are there many questions about "Replication" in the exams?
> >
> > which book is good to learn about "performance tuning and optimisation"?
> >
> > Thanks a lot for your comments, advices.
> >
> > anthony
> >
> >
>
>

Report this post to a moderator

Right now I am reading "Professional SQL Server 2000 Programming" by
Robert Vieira - and so far it rocks. I think it will be a great book
for the 229 test, and reviews up at Amazon seem to support that
theory.




Kurt


<robbeney@worldonline.co.za> wrote in message news:<3e3a5f70$0$231@hades.is.co.za>...
> dude..
>
> If you have developer edition, use it.. developer can pretty much do
> anything enterprise can. 1 pc is fine, just install 2 instances of sql.
>
> to get through this exam know T-SQL, practice it.. there are loads of
> question on syntax.
> also many on when to use views and when stored procedures..
> know XML and it's syntax....
>
> otherwise don't panic it's a fair exam.. not to difficult not to easy..
>
> Rob..
>
> Wrote and passed today YEAHH!!!
> "anthony" <anthony@allette.com.au> wrote in message
> news:OjCiEYMyCHA.2868@TK2MSFTNGP12...
> > Hi all,
> >
> > What version of SQL Server I need to install for preparing MCDBA?
> >
> > is "Developer" version enough?
> >
> > or I need "Enterprise" version"?
> >
> > do I need to setup network (2 computer?) or stand alone is enough?
> >
> > are there many questions about "Replication" in the exams?
> >
> > which book is good to learn about "performance tuning and optimisation"?
> >
> > Thanks a lot for your comments, advices.
> >
> > anthony
> >
> >

Report this post to a moderator

I got my MCDBA using the evaluation version.

RD (MCSD, MCDBA, MCSE)

"anthony" <anthony@allette.com.au> wrote in message news:OjCiEYMyCHA.2868@TK2MSFTNGP12...
> Hi all,
>
> What version of SQL Server I need to install for preparing MCDBA?
>
> is "Developer" version enough?
>
> or I need "Enterprise" version"?
>
> do I need to setup network (2 computer?) or stand alone is enough?
>
> are there many questions about "Replication" in the exams?
>
> which book is good to learn about "performance tuning and optimisation"?
>
> Thanks a lot for your comments, advices.
>
> anthony
>
>

Report this post to a moderator