How do you or your organization use this solution?
Please share with us so that your peers can learn from your experiences.
Mainly, I do infrastructure support. We do fine-tuning, information, configuration, higher-level availability, and replication. Also, single and clustering solutions - both kinds. We do on-premises and cloud deployments. This is because some customers use Microsoft Azure, mainly in the financial sector, such as the Sri Lanka Government, who has many databases that cannot go on the cloud. The financial sector also works with on-prem databases. I am mainly using the SQL Server from 2019. That's the latest version since last January while our customers are mainly using the 2016 and 2017 versions. This is because we are not providing the latest version. We are testing some bugs now. In terms of functionality, I think the 2017 version is better. I have not fully tested the 2019, so I cannot give a recommendation for it.
Our primary use case of this solution is to develop solutions for our clients.
Our primary use case is to have a database of customers. We also use it to manage accounts. We have an on-premises deployment.
We use it for analytical and operational enterprise reference data management including management of campaign, product and financial management hierarchies. We currently only use batch interfaces to feed or get data from it. We also use it to maintain source to enterprise data mappings that are fed to ETL via a generic RDM (Reference Data Management) design. We have a variety of different groups of data stewards who use the tool for data management and they get automatically notified when source systems feed new data that needs to have stewardship carried out.