I'm going to be developing a php site (actually more of a application), but the standards and restriction of what I'm building make MS SQL Server the most appropriate DB solution (will also be running things like SSRS).
So what would be the best way to do this in terms of performance and maintainability?
An obvious solution is to run a virtual machine on the same physical machine as the web server. I haven't yet picked a hosting solution and I know this will eliminate any of the simpler/cheaper hosting solutions, since this will require much more configuration than they'll allow.
I also read in answer to a somewhat similar question here that dual booting was an option. What is this? The only dual booting I'm familiar with is having the option to boot to either OS, not run both concurrently.
How big of a performance hit will I take if I choose to host the DB on a separate machine all together? Or if I elect to have both servers hosted through the same host?
I really don't want to go the route of running the web app and php on MS Server, so that's pretty much out of the question. If push came to shove, I suppose I could just have a MySQL DB on the same machine then replicate that DB on a different MS SQL Server machine. Of course any reports or data import/export wont be real-time.
So any advice or suggestions is really appreciated. Luckily I'm still in the early planning phase and have time to consider different options.