Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
IdRatherBeProgramming
Starting Member
19 Posts |
 Posted - 2008-07-15 : 16:27:05
|
| A long time ago, I read that installing your IDE on your database server and doing application development/programming directly from this database server was a very bad thing to do, but can't easily find any articles to support that... If it's your desktop, that's one thing... But should you ever install, lets say any version of the Visual Studio IDE and do development directly on a shared database server?I'd prefer recommendations and facts to support the recommendations rather than getting people's opinions, but feel free to voice opinion as well. Any links to articles would be helpful.I need to convince a senior developer that he shouldn't be installing Visual Studio 2003 and doing VB.NET development on our shared database server... And I don't want to look like it's me complaining about an opinion I have.There's got to be some reputable source that recommends against this...Please help! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-15 : 16:49:13
|
| All you need to do is show how much resources the IDE is taking on the database server. Open up Performance Monitor and monitor his process.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
IdRatherBeProgramming
Starting Member
19 Posts |
Posted - 2008-07-17 : 16:21:25
|
quote:
Originally posted by tkizer
All you need to do is show how much resources the IDE is taking on the database server. Open up Performance Monitor and monitor his process.Tara Kizer
And his response will be, "I don't need to develop those particular apps that often, so it's not that big of deal"...He's a dinosaur and set in his ways, so I need something concrete or he'll just attribute it me being a pain for no reason... |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-07-17 : 16:25:07
|
| He's doing development on a PRODUCTION server?All he has to do is forget which environment he is in one time to bring the application to a screeching halt.e4 d5 xd5 Nf6 |
|
|
|
IdRatherBeProgramming
Starting Member
19 Posts |
Posted - 2008-07-28 : 11:29:53
|
quote:
Originally posted by blindman
He's doing development on a PRODUCTION server?All he has to do is forget which environment he is in one time to bring the application to a screeching halt.e4 d5 xd5 Nf6
I'm actually talking about a shared development database server (thank god), but the key word is shared. He's got the Visual Studio IDE installed on our database server and is writing code, debugging, etc. on this server. I can't find one reason to install VS on a database server to begin with. If you need that environemnt, both VS and SQL Server should be installed on your local machine. But I can't find anything (reputable) on-line to support this.Is this a really bad idea (as I believe it to be) or am I just over-reacting? |
|
|
|
|
|
|
|
|
Need help convincing developer of bad practices...