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:
>