Hey all,
I was wondering if anyone could share with me any best practices they follow in regards to the locations of developing databases. In this time of stolen laptops, privacy issues - I would think that it would be best practice to not have production copies of databases on laptops that are not totally secured, either by full hard drive encryption, or scrambling databases.
<script></script>
In places that I have worked in the past, the "development" and "QA" databases resided on a server secured in the server room, along with the production databases and servers. Developers / Engineers would connect to the data, and work that way...not having full databases loaded on any laptop.
At the place I am now, the developers / engineers all have their own (full or MSDE / Express is still being determined) version of SQL server, along with the full versions of the databases they work with on a day to day basis. This scares me because 1. the work cannot get backed up and 2. it takes users data and places it at risk. 3. possible license issues if these are not MSDE/Express
Please share with me your thoughts and best practices you follow in your employment.
Thanks