5 ms·

Wouldnt it be easier just to run sql server on windows at that point to take advantage of the ms ecosystem ? Edit: I am not familar with much of anything micro

Wouldnt it be easier just to run sql server on windows at that point to take advantage of the ms ecosystem ? Edit: I am not familar with much of anything microsoft related.

UnoriginalGuy 10y ago
You'd never run MS SQL Server and these other servers on the same machine either way, so you could easily run SQL Server on Linux and Reporting Services on Windows Server. Although if you're virtualizing Windows Server, it may be effectively free to run an additional Windows Server instance (since you pay per core regardless); but if your hypervisor's resources are already saturated then you could take SQL Server off of it and put it onto a inexpensive Linux Server.
Deinumite 10y ago
Maybe but this also gives you more hosting options if you are in the cloud. Also tools like puppet and chef for example have an easier time provisioning Unix like machines than Windows (although this has been changing, and the situation could be much better I haven't dealt with it for a bit). Also you don't have to deal with licenses for Windows server instances which can be another huge painpoint.
dogma1138 10y ago
There are quite a few products that require a Linux host for the main app server and a MSSQL or Oracle DB. Oracle support is being dropped left and right MSSQL is there because it was the defacto enterprise DB for ages and it also has a free version via MSSQL express. And lastly having more options is never a bad thing.
- statictype 10y ago
  There are quite a few products that require a Linux host for the main app server and a MSSQL or Oracle DB. Are there? I'm genuinely curious about what these products, are that run on Linux and use SQL Server.
  - dogma1138 10y ago
    I should've used the require just for the 2nd part just off top on my head a lot of IBM products (e.g. Lotus) can be installed on Linux and only run on MSSQL or Oracle with and ODBC connector rather than their DB2 internal DB.
- ams6110 10y ago
  Oracle support is being dropped left and right By whom? I think "big" enterprise software (SAP, Peoplesoft, etc.) has and will support Oracle for a long time. Many of their customers have huge investments in Oracle, not only financial but training and institutional knowledge.
krakensden 10y ago
It is hard to run Windows Server in the style favored by serious devops shops- CI for infrastructure, totally automated bring up, etc. There are lots of companies that don't/won't run SQL Server because they don't think they can do that with windows, or don't want to try and port their tooling.
- spydum 10y ago
  Exactly this.. The about shops that have all their server tooling for Linux, and want this nice 3rd party tool but it requires SQL Server.. Either team grins and bears supporting a one off OS and application, or they find another solution and MSFT loses a license.
- dogma1138 10y ago
  It's really not, it's that most devops engineers don't want to learn or even bother and most windows sysadmins simply don't know how. Windows automation kinda died when system admins stopped needing to know how to work with JET DB when needing to do one serious ad work. I don't can't think of a single CI or automation thing that works with Linux that you can't do in Windows if pushed I can probably come with considerably more things which are opposite. Licensing is the only thing really that makes windows machines a pain to work with unless you are big enough for a sell reporting volume licensing scheme.
  - inferiorhuman 10y ago
    My experience at a largely Windows based Fortune 1000 company was that Windows is that hard. I dealt with 12-ish factor apps on Linux exclusively, but the teams dealing with legacy stuff on Windows really struggled. If you're very careful with the tooling you may get lucky, but I watched as things like Chef, Sensu, and Collectd all took significantly more effort on the Windows platforms.
    - larrywright 10y ago
      More recent versions of Windows Server have definitely improved, but this is still pretty accurate. When given a set of tasks to do for Windows and Linux, the latter is always easier. If it takes x amount of time to automate something on Linux, it's 5x on Windows. Every time. Some of this is due to MS themselves, some of it is due to the software vendors, but it's a very real thing.

Wouldnt it be easier just to run sql server on windows at that point to take advantage of the ms ecosystem ? Edit: I am not familar with much of anything microsoft related.

UnoriginalGuy 10y ago

You'd never run MS SQL Server and these other servers on the same machine either way, so you could easily run SQL Server on Linux and Reporting Services on Windows Server. Although if you're virtualizing Windows Server, it may be effectively free to run an additional Windows Server instance (since you pay per core regardless); but if your hypervisor's resources are already saturated then you could take SQL Server off of it and put it onto a inexpensive Linux Server.

Deinumite 10y ago

Maybe but this also gives you more hosting options if you are in the cloud. Also tools like puppet and chef for example have an easier time provisioning Unix like machines than Windows (although this has been changing, and the situation could be much better I haven't dealt with it for a bit). Also you don't have to deal with licenses for Windows server instances which can be another huge painpoint.

dogma1138 10y ago

There are quite a few products that require a Linux host for the main app server and a MSSQL or Oracle DB. Oracle support is being dropped left and right MSSQL is there because it was the defacto enterprise DB for ages and it also has a free version via MSSQL express. And lastly having more options is never a bad thing.

statictype 10y ago
There are quite a few products that require a Linux host for the main app server and a MSSQL or Oracle DB. Are there? I'm genuinely curious about what these products, are that run on Linux and use SQL Server.
- dogma1138 10y ago
  I should've used the require just for the 2nd part just off top on my head a lot of IBM products (e.g. Lotus) can be installed on Linux and only run on MSSQL or Oracle with and ODBC connector rather than their DB2 internal DB.
ams6110 10y ago
Oracle support is being dropped left and right By whom? I think "big" enterprise software (SAP, Peoplesoft, etc.) has and will support Oracle for a long time. Many of their customers have huge investments in Oracle, not only financial but training and institutional knowledge.

krakensden 10y ago

It is hard to run Windows Server in the style favored by serious devops shops- CI for infrastructure, totally automated bring up, etc. There are lots of companies that don't/won't run SQL Server because they don't think they can do that with windows, or don't want to try and port their tooling.

spydum 10y ago
Exactly this.. The about shops that have all their server tooling for Linux, and want this nice 3rd party tool but it requires SQL Server.. Either team grins and bears supporting a one off OS and application, or they find another solution and MSFT loses a license.
dogma1138 10y ago
It's really not, it's that most devops engineers don't want to learn or even bother and most windows sysadmins simply don't know how. Windows automation kinda died when system admins stopped needing to know how to work with JET DB when needing to do one serious ad work. I don't can't think of a single CI or automation thing that works with Linux that you can't do in Windows if pushed I can probably come with considerably more things which are opposite. Licensing is the only thing really that makes windows machines a pain to work with unless you are big enough for a sell reporting volume licensing scheme.
- inferiorhuman 10y ago
  My experience at a largely Windows based Fortune 1000 company was that Windows is that hard. I dealt with 12-ish factor apps on Linux exclusively, but the teams dealing with legacy stuff on Windows really struggled. If you're very careful with the tooling you may get lucky, but I watched as things like Chef, Sensu, and Collectd all took significantly more effort on the Windows platforms.
  - larrywright 10y ago
    More recent versions of Windows Server have definitely improved, but this is still pretty accurate. When given a set of tasks to do for Windows and Linux, the latter is always easier. If it takes x amount of time to automate something on Linux, it's 5x on Windows. Every time. Some of this is due to MS themselves, some of it is due to the software vendors, but it's a very real thing.