Microsoft SQL Server

Microsoft SQL Server is used in our organization by IT personnel to Store data, fetch data specific to requirements. For instance, in Sales Module SQL server is used to fetch data specific to a sales transaction and it helps to troubleshoot the errors reported by users. Similarly, it is used by IT technical team and other IT functional team to query the data stored in data server.

I work for a company that creates a software suite that allows our customers to manage and track their work, their companies and contacts, user logins, etc. We use an extensive database built over the years and several stored procedures that can be called from our software to perform calculations and format data in needed layouts.

Microsoft SQL Server supports the databases for our primary accounting system (MS Dynamics GP). This avoids us using much less efficient flat files or less compliant software from, for example, open source solutions.

I primarily use Microsoft SQL Server 2019 and 2022 data engine to run commercial workloads of various customers. A frequent configuration use case is the usage of Microsoft SQL Server Always On failover cluster instances to provide high availability and redundancy at the Microsoft SQL Server instance level. In some cases, I also make use of Microsoft SQL Server replication to ensure that a primary (publisher) database is replicated, by using transaction of snapshot replication, to a subscriber SQL instance from which the customer can run various SQL queries for analytical reporting purposes without affecting the SQL production workloads. Another common case where I make use of Microsoft SQL Server is when running hybrid cloud SQL workloads, in which case I combine on-premise SQL Server deployments, Azure VM-based SQL Server deployments and Azure SQL or Azure SQL Managed Instance resources.

We use MSSQL Server along with SSIS and SSRS as it's a very competent software suite and very stable. It integrates well with other software that we use, namely JAMS Scheduler.