Microsoft SQL Server vs. Couchbase vs. FoundationDB

We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.

Product back end and reporting

Managing script output and input, as well as data cleansing.

Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

Users and companies are stored in SQL Server

Integration with LOB systems.

Our beloved DB.

Back End: DataBase

社内サーバー

This is database for all Windows applications.

Stores rules for PRS

Datastorage

My go to database when working with Microsoft Technologies.

Data source from the data warehouse.

UI & administration data.

Azure SQL service to use as a main storage

for BI

Backing database for several distinct APIs

Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.

Everyone needs a robust database, right?

Main data storage. Any writes to Couchbase auto-replicate to Elasticsearch (via XDRC) and from there on propagate into the internal Jezebel pipeline via opes.

We use Couchbase heavily in our PowerStandings platform to enable real-time analytics of agent data, as well as data storage for parts of our new Playbooks product.

Real-time data interaction on 600000+ rpm.