Re: Developer design Best Practices
From: Gkurtas (Gkurtas_at_discussions.microsoft.com)
Date: 09/10/04
- Next message: Colin Bunting: "Multiple instances in a virtual server"
- Previous message: hogwart: "Attach a DB that was never Detached"
- In reply to: Peter Yao: "Re: Developer design Best Practices"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Sep 2004 06:51:14 -0700
Answers and more questions:
Peter: I am consolidating a list of 23 servers that host individual or
multiple smaller databases that were created adhoc on those servers for the
sake of an application that was hosted on the box. Multiple people installed
SQL on these machines and than installed their application and pointed it
locally. All of these will now be collapsed (if feasible) onto the new design
of development and production servers, which are beefier and faster and
hopefully more secure.
Amanda defined the issue I was asking about in better detail.
The developers have had free reign over SQL for a long time including
production machines. Many of the objects in these databases are owned by not
only long gone developers but sometimes third party vendor accounts who also
do not provide the passwords for these accounts.
I am trying to find out the best method for allowing developers to develop
freely on the development machines while limiting or denying access to
production. This is probably not so easily answered in a newsgroup format but
some pointers to a whitepaper or other resource for this information would be
most helpful. All of the posts so far are accurate and I appreciate the the
input but I need more detail on how exactly to configure this environment. I
am not looking for hardware - cluster - platform configuration info but more
on the permissions and roles and access level stuff.
My plan is to have 4 machines in use - two for development and two for
production with a fifth machine in use on our DMZ for that rare external
database.
- Next message: Colin Bunting: "Multiple instances in a virtual server"
- Previous message: hogwart: "Attach a DB that was never Detached"
- In reply to: Peter Yao: "Re: Developer design Best Practices"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
