March 26, 2004 at 3:01 pm
I can't believe it, but I am actually having to defend myself on some basic best practices. And I've been asked to provide documentation to back up my claims. Here are a few of the things I'm trying to convince people. If anyone can point me to trusted documentation about these issues, I would really appreciate it. If instead, I am wrong, please let me know that too. Thanks.
1. Users, even 'power users', should not be using Query Analyzer to access or ad-hoc query a production database.
2. Whatever tool users do use to ad-hoc query the database should be accessing carefully defined Views and not directly accessing Tables.
3. SQL Server developers need and should have a development environment that includes a SQL Server to which they have suffiecient access to create, modify and delete databases.
Thanks so much for helping me out with this.
Jana Bagwell
March 26, 2004 at 6:09 pm
1. Users, even 'power users', should not be using Query Analyzer to access or ad-hoc query a production database.
2. Whatever tool users do use to ad-hoc query the database should be accessing carefully defined Views and not directly accessing Tables.
Yes this is a very poor pratice to allow someone to do so as they could potentially bog down the Server with a poorly written query. Besides for them to do ad-hoc queries it means they need access to tables and this means exposing data you may not want seen for security. Tie 'em up with SPs or VIews.
3. SQL Server developers need and should have a development environment that includes a SQL Server to which they have suffiecient access to create, modify and delete databases.
Of course they need somewhere to do their work that is common and on their own server is best. Production can be easily brought to a standstill if they make a mistake in something simple (especially cursors). Besides it doesn't have to be a world class machine and I find it better that the machine they program on isn't near as beefy since issues will show up much better and they will be forced to really think about design.
Regards
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply