Difference Between Production & Development

Hi
Heard a lot of people talk abt production & development environment
what all do they mean ....
Does supporting a production environment mean that its only
administration of the box
& does Development mean codint the T SQL statments
Someone please help & clarify this doubt...
ThanksNot a formal definition but just to give you an idea :-)
A development environment is where software and database developers write
and test their applications. When these applications are tested and complete
d
they are moved to the production environment.
A production environment is the live environment where final users enter
their data, query information and run their reports.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Double_B" wrote:

> Hi
> Heard a lot of people talk abt production & development environment
> what all do they mean ....
> Does supporting a production environment mean that its only
> administration of the box
> & does Development mean codint the T SQL statments
> Someone please help & clarify this doubt...
>
> Thanks
>|||"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:ACE47A28-2432-46D2-AE96-8E8ADE2356A4@.microsoft.com...
> Not a formal definition but just to give you an idea :-)
> A development environment is where software and database developers write
> and test their applications. When these applications are tested and
completed
> they are moved to the production environment.
> A production environment is the live environment where final users enter
> their data, query information and run their reports.
>
To further expand...
Some possible differences. In my development environment typically I'll
have databases set to simple recovery only as it doesn't matter if I lose
data. And this makes my disaster recovery model much more simple.
On the other hand for production, I use a full recovery model.
In development, the developers can "do what they want, when they want"
pretty much. If they lock up the database with a bad query, I don't care.
With production, I'm typically the only one making schema changes or doing
ad-hoc queries.
My Dev environment may or may not have RAID, UPS, etc. (typically it does
just because it's cheap enough).
My prod environment definitely has stuff like that.
[vbcol=seagreen]
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Double_B" wrote:
>

Difference Between Production & Development

Hi
Heard a lot of people talk abt production & development environment
what all do they mean ....
Does supporting a production environment mean that its only
administration of the box
& does Development mean codint the T SQL statments
Someone please help & clarify this doubt...
ThanksNot a formal definition but just to give you an idea :-)
A development environment is where software and database developers write
and test their applications. When these applications are tested and completed
they are moved to the production environment.
A production environment is the live environment where final users enter
their data, query information and run their reports.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Double_B" wrote:
> Hi
> Heard a lot of people talk abt production & development environment
> what all do they mean ....
> Does supporting a production environment mean that its only
> administration of the box
> & does Development mean codint the T SQL statments
> Someone please help & clarify this doubt...
>
> Thanks
>|||"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:ACE47A28-2432-46D2-AE96-8E8ADE2356A4@.microsoft.com...
> Not a formal definition but just to give you an idea :-)
> A development environment is where software and database developers write
> and test their applications. When these applications are tested and
completed
> they are moved to the production environment.
> A production environment is the live environment where final users enter
> their data, query information and run their reports.
>
To further expand...
Some possible differences. In my development environment typically I'll
have databases set to simple recovery only as it doesn't matter if I lose
data. And this makes my disaster recovery model much more simple.
On the other hand for production, I use a full recovery model.
In development, the developers can "do what they want, when they want"
pretty much. If they lock up the database with a bad query, I don't care.
With production, I'm typically the only one making schema changes or doing
ad-hoc queries.
My Dev environment may or may not have RAID, UPS, etc. (typically it does
just because it's cheap enough).
My prod environment definitely has stuff like that.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Double_B" wrote:
> > Hi
> >
> > Heard a lot of people talk abt production & development environment
> > what all do they mean ....
> >
> > Does supporting a production environment mean that its only
> > administration of the box
> >
> > & does Development mean codint the T SQL statments
> >
> > Someone please help & clarify this doubt...
> >
> >
> > Thanks
> >
> >

Difference between MSDE and SQL Server 2000

Hello everyone,i want to know abt the "Difference between MSDE and SQL Server 2000". For example the features they support, capacity and requirements etc...

Reply me asap.

Thanx in Advance.

Here are a few links that should help:

http://download.microsoft.com/download/8/1/7/817bb6e6-9d97-4a5d-be8d-508256ae4045/ChoosEd.doc

http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx

HTH!