Hi guys, I'm getting ready to engage 3 to 4 projects that require MS SQL. Across all of the applications and projects the recommendation is to house the SQL server on its own machine and the actual application on another. I have a few questions about this.
Is the best way to have the app on one server and the SQL server on another machine?
Can I have one SQL server for all my applications (i.e all my applications connect to the same server)?
Is it better to have a separate SQL machine for each of my applications i'm launching?
Is it ok to run my SQL server off of virtual server? If so, what are the recommendations?
You're probably wondering what the applications are. But you probably wouldn't know if I told you. These are just 3rd party software vendors that use SQL. Ones a payroll solution out of Saudi Arabia. Another is some warehouse software. Barring their own idiosyncrasies, they all use a standard approach to using SQL server.