Re: SQL server 2000 C/S

From: Charles (Charles_at_discussions.microsoft.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 11:47:02 -0700

Thanks Geoff

Thats kind of what I had in mind. I actually do have plans on developing
apps. In regards to the developer edition , If I install it on client
machine, that machine is virtually being used as an application
server....right? By the way, is true that installing SQL Server 2000
admid/server tools on your main (DNS) domain controller degrades your
network?

Thanks,

cs
"Geoff N. Hiten" wrote:

> I would load SQL server and the tools on your servers and the client tools
> only on your clients. I might load a developer edition of SQL on a client
> system set up as a development console, but that depends on whether you plan
> on doing development. One system can be configured ot handle both the SQL
> server and any application, but that would not adequately simulate a
> 'real-world' environment. Be prepared to reconfigure systems a lot to
> handle different scenarios as you progress.
>
> I would also start studying SQL 2005 which is now in Beta 2. I suspect
> there will be a big demand for people with skills in that product as soon as
> it hits the streets.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> I support the Professional Association for SQL Server
> www.sqlpass.org
>
> "Charles" <Charles@discussions.microsoft.com> wrote in message
> news:C9699B0E-5AFB-4E90-AE39-0BAC8209713D@microsoft.com...
> > Hi ,
> >
> > I am an aspriring IT consultant. I'm currently in the process of working
> on
> > my MCDBA certification. Currently I'm an application analyst for a
> healthcare
> > orginazation and I am planning on switching over to the DBA world. If you
> > don't mind, I have a question in regards to the client server
> architecture
> > of SQL 2000. I'm currently developing a lab in my home office were I've
> > prepared 2 servers and 3 clients so that I can replicate a typical server
> > envronment with SQL 2000 as the DB solution. In regards to the layout,
> what
> > do you think would be the best setup with the equipment I have? I'm
> assuming
> > you install the client and server tools on the DB server and the client
> tools
> > on the individual clients. But for optimum learning purposes, do you have
> > better suggestions? This structure and obviously a two tier , but I'm
> > assuming that most orginaztions set SQL on an n-tier structure. A reply
> would
> > be greatly appreaciated.
> >
> > Thanks,
> >
> > Charles
> >
> > P.S. I would ask my DBAs at work, but with their cocky attitudes i'm a
> > little reserved from asking them this kind of question
> >
> >
>
>
>