4 ms·
Did you know there is now a TDS interface for Postgres, so SQL Server clients can use Postgres natively? https://babelfishpg.org/docs/internals/software-archit
by chasil 5y ago
Did you know there is now a TDS interface for Postgres, so SQL Server clients can use Postgres natively?
https://babelfishpg.org/docs/internals/software-architecture/ https://babelfishpg.org/docs/internals/software-architecture...
If you must use Microsoft SQL Server, at least deploy it on Linux.
Microsoft's published TPC-H scores are all higher on Linux than Windows, and Patch Tuesday is agony for those who need an available database.
Oracle's Ksplice is also free on Ubuntu. Try to use XFS, as all the top TPC scores seem to be using this filesystem.
http://tpc.org/tpch/results/tpch_perf_results5.asp?resulttype=all&version=3 http://tpc.org/tpch/results/tpch_perf_results5.asp?resulttyp...
- magicalhippo 5y ago> Did you know there is now a TDS interface for Postgres I did not, that's really interesting thanks! > If you must use Microsoft SQL Server, at least deploy it on Linux For customers where we'll still be managing the DB, that's definitely an option I'll push for checking out. That said, management can trump peak performance. We've been a Windows shop for 20+ years, if support judges it too hard to learn the idea is DOA.