SQL Server backend - run rails on Linux or Windows?


I have to use SQL Server as the backend of a Rails application. I
would appreciate any recommendations in regards to where to run the
Rails application itself. Would Linux or Windows be a better choice
given the SQL Server constraint.


Linux. Ruby on Windows is notoriously slow, and deploying to Linux you get to take advantage of Capistrano and the other tools and stuff that goes well with Rails. Connecting to SQL Server from Linux shouldn't cause any big issues using FreeTDS and UnixODBC or equivalent. At least it doesn't for us.

Linux is always a better choice for deployment. Depending on how your SQL server is set up, you may or may not encounter issues with connecting to your SQL Server. Windows deployment of Rails is slower than Linux but it can be made to run at an acceptable level.