I am mostly curious, but how do the numbers compare for others out there on SQL Standards for your customers?
A large majority of our customers require MSSQL and well, I hate it. I would much rather use PostgreSQL, but typically only the mom and pop outfits are game to use it.
I don't feel that PostgreSQL is any less secure if you set it all up properly. Maybe it is just a bunch of Microsoft Fanboys in the corporate IT Land?
I have Fortune 500 clients using PostgreSQL.
Really big companies have Linux teams, not just MS staff, and you can win concessions when you point to products like Google Big Data and Amazon Red Shift, which are enhanced PostgreSQL under the hood.
And you can purchase support for plain PostgreSQL from EnterpriseDB, the main sponsor of its developers.
The companies most resistant to non-MS products are the mid-size businesses that think they need a lot of hand-holding. The ones that are delegating their email domain to MS Office 365 typically fall into this category.
I would say that PostgreSQL is far more secure than MS SQL Server, due to the latter's integrated Windows auth option. Eww!
This is interesting to me. We have a few F500 customers and their IT kick and scream when we bring up Linux or PostgreSQL. I suppose you just have better customers haha.
I hadn't considered pushing the EnterpriseDB side of things, but this makes a lot of sense. Customers feel more comfortable when they actually have to purchase something hilariously enough.
Seems just like the experience of having the audacity to recommend Ignition instead of the Good Old FactoryTalk™
This is 100% our experience as well. So many of our customers are locked into MSSQL and their IT staff is all versed on Windoze, and none on Linux. So much security tightly integrated with Office365 SSO etc...
Given that a reasonable database license for a customer site with M$ is gonna cost you as much as the entire Ignition license, I am getting a lot of allowances made, especially as most of the mid size customers don't touch the database once it is set up, as it is historian generally which they call "non-mission critical".
This means I can get them a redundant Ignition license and Postgres for the same cost as M$ SQL and a single license.
Maybe we can get a tea party for our customers and Phils see if Phils can convince the rest of the world to go PG Linux route 