We just raised a $30M Series A: Read our story
2018-07-19T09:31:00Z

What is your primary use case for SQL Server?

5

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

ITCS user
Guest
7575 Answers

author avatar
Top 20Real User

We provide support services to clients. We find that some of our clients are running the latest system while others are still on Windows 2016, others are moving to 2019. Some other clients take time to upgrade. If I interact with five clients, I'll basically be in five different environments. Our use case for the SQL Server is for transaction processing. We store all the transactions that occur. For example, if you now purchase something from the point of sale, all the information about the good you are purchasing gets stored on the SQL Server. When you perform a transaction that information is stored at the bank that owns the point of sale and perhaps even your bank, where your money is will be stored in a SQL Server. All the people in all of the organizations, which are involved in the process use SQL Server. If your transaction goes through my server, I store part of the transaction there, and if I have to route that transaction to Visa or Mastercard, they have their own SQL Server, and they also store the transaction up until you get receive your goods at the particular merchant. Almost everyone in that transaction stores the information on their respective Microsoft SQL server.

2021-10-29T15:40:18Z
author avatar
Real User

We use SQL Server as a database management system for all of our projects.

2021-10-28T15:10:37Z
author avatar
Top 5LeaderboardReal User

We use SQL Server as a database solution.

2021-10-27T09:39:29Z
author avatar
Top 5Real User

It's a normal DMS, so it can be used everywhere you want to use any RDBMS or relational database. It's for normal transactions.

2021-10-11T21:54:00Z
author avatar
Top 5Real User

We primarily use the product for internally developed applications. There's some business intelligence and data warehousing used as well as some financial information.

2021-09-21T19:40:20Z
author avatar
Top 5LeaderboardReal User

We use SQL Server as a relational database mostly for the application backend activities and integrations.

2021-09-20T10:53:41Z
author avatar
Top 20Consultant

We set up SQL Servers for developers who develop applications for data mining. Our clients are generally small or medium-sized businesses. There's also a SQL Server Express that many software vendors use to support their applications. That gets installed often—usually as part of the application installation.

2021-09-17T18:45:00Z
author avatar
Real User

We are using SQL Server to build and store our whole company's data in our data warehouse.

2021-08-19T23:49:52Z
author avatar
Real User

Despite the core database is not SQL Server in my working company, SQL Server is widely being used as the backend for many in-house applications and customized applications like Solarwinds.

2021-08-11T20:53:08Z
author avatar
Top 5LeaderboardReal User

We have used it in a variety of ways, including for e-commerce deployments.

2021-08-11T13:30:12Z
author avatar
Top 5LeaderboardMSP

We use the solution for managing our database functions.

2021-08-07T06:35:13Z
author avatar
Top 5Real User

We are using the latest version. We can use the solution for the same application. On the database side we have Microsoft SQL and on the operating system side we have 2019.

2021-07-29T08:21:58Z
author avatar
Top 5LeaderboardReal User

We use a tool called Tosca for automation and all the automation artifacts we are saving are on the SQL Server.

2021-07-16T12:04:20Z
author avatar
Real User

We primarily use the solution mainly for databases on all types of applications.

2021-07-13T16:18:52Z
author avatar
Real User

We use SQL Server for database management.

2021-07-11T12:41:09Z
author avatar
Top 5LeaderboardReal User

We use SQL Server for web application and website development.

2021-07-11T12:39:11Z
author avatar
Top 5LeaderboardReal User

The solution is an RDBMS and can be used to simplify customers' requirements for a back-end database. The main function of the solution is to store information from front-end users.

2021-07-09T12:40:31Z
author avatar
Top 5LeaderboardReal User

This solution is part of the ERP that we have for application. We use it for many purposes, such as POS in-store cash registers for enterprise companies.

2021-07-09T10:16:58Z
author avatar
Top 5Real User

We use SQL Server for collecting and storing our data.

2021-06-18T07:34:42Z
author avatar
Top 5MSP

SQL Server is enterprise database software. It provides the back end for any number of different applications, including web applications, and other types of internal applications, and software-based applications. It also provides a back end for enterprise backup tools. It's incredibly diverse in terms of its use case.

2021-06-03T09:43:04Z
author avatar
Top 5Real User

We're using it for our on-premise servers, and we have the latest version of SQL Server. We use SQL Server for the database for Microsoft Navision. We also use it for the Track-It application that helps users in logging in their IT requests. We also manage all the IT inventory through Track-It. It does automatic auditing and traces online IT equipment.

2021-06-02T15:44:56Z
author avatar
Top 20Real User

We are using it for accounts payable and accounts receivable automation. We make accounts payable and accounts receivable solutions, and we're using SQL Server as one of the building blocks.

2021-05-31T15:41:02Z
author avatar
Top 5Real User

We develop software for another company. We mainly develop on-premises solutions. We use this solution with our accounting ERP software. Our product is called Orchida ERP and we have many clients in Egypt who are using this software. Its database is SQL Server. We mainly work in ERP. We currently have a small project in SharePoint for Microsoft, but 80% of our work is with Orchida ERP We have our software with SQL server for 20 years. Our software will not work without SQL Server. We provide consultancy in installing this solution for our clients.

2021-05-29T17:22:34Z
author avatar
Top 5LeaderboardReal User

Microsoft SQL Server is a database application, meaning it acts as the backend system for help with the backend data repository system. It concerns itself with every activity that happens at the front end of the database in Microsoft SQL Server. ERP Microsoft solutions is one reason that the SQL server has compatibility. The management of Microsoft SQL Server is actually quite easy. It has a GUI interface and enables a person to do whatever is required at the command line level. It functions as a repository for storing one's data in the relational database.

2021-05-27T21:04:00Z
author avatar
Top 5LeaderboardReal User

We use the solution for nearly all of the services we provide that utilize Windows Server. We use it to provide continuous service and in respects of our mail server.

2021-05-27T15:16:00Z
author avatar
Top 5LeaderboardReal User

We use the product for information systems. This is a must both for us. We use it for our Enterprise Portal.

2021-05-13T12:18:00Z
author avatar
Top 20Real User

Our primary use case is for data mart and data warehousing. My company is a service company and we provide the professional services for deployment of BI solutions. We are customers of SQL Server and I'm head of data analytics.

2021-05-08T15:48:08Z
author avatar
Real User

It is used for everything under the sun. We're currently using it for a health pass for a medic aid information management system. It is also used by companies in banking and retail. We are using SQL Server 2014 on Windows Server 2012 platform, and we also have SQL Server 2016 on Windows Server 2016 platform. I have primarily worked on the hardware, but I am now also working in the Amazon AWS cloud.

2021-05-07T23:13:07Z
author avatar
Top 5LeaderboardReal User

I use this solution as our data warehouse. We use the reports, data analysis, and for connecting our databases to multiple resources.

2021-05-05T14:15:13Z
author avatar
Top 20Real User

I am an IT professional, I write services for my clients. I provide support services for SQL, firewalls, and operating systems. IT infrastructure support in general is what I provide.

2021-04-06T13:38:19Z
author avatar
Top 5LeaderboardReal User

The solution is primarily used for studying data and statistics. We have some services that we are monitoring and keeping records and doing reports, and we use it for that.

2021-04-01T10:10:32Z
author avatar
Top 20Real User

It is used for the backend database for our ERP system and the document management system. We are using its latest version.

2021-03-30T19:25:39Z
author avatar
Top 5Real User

We primarily use the solution for recording transactions and information related to the reservation of a service.

2021-03-27T19:05:32Z
author avatar
Top 5LeaderboardReal User

We developed a product that is using five or six databases supported on SQL Server.

2021-03-11T01:58:50Z
author avatar
Top 5LeaderboardReal User

My background is primarily in software development, and I use SQL Server among other tools in that capacity. SQL Server was one of the main databases in my previous company, and it is used for storing data from different applications.

2021-03-05T16:15:31Z
author avatar
Top 20Real User

We are primarily using the solution for pulling data and analysis. In the auto industry, are the dealer management systems for which there is kind of portals from which the dealers are maintaining information can have access to retail data, bookings, and details surrounding individual customers. We are fetching data and using it for analytics purposes, basically.

2021-03-05T09:38:33Z
author avatar
Top 5Real User

We use SQL Server to process a lot of data. We are using versions and 2015 and 2018.

2021-02-24T11:06:46Z
author avatar
Real User

We use SQL Server for our internal applications.

2021-02-18T14:03:20Z
author avatar
Top 5Real User

We primarily use the solution as a relational database system.

2021-02-14T14:42:24Z
author avatar
Top 20Real User

We use this Relational Database Management System for Line of Business systems, including Enterprise Resource Planning, Data Warehouse, Web Applications, and Business Intelligence. Solutions are procured, built, and enhanced in the REIT industry, FMCG ERP, distribution and warehousing, manufacturing systems, knowledge workers such as workflow and portals, web applications, custom developments areas, enterprise reporting and analytics for internal reporting, and decision support systems. Integration solutions provide robust integration to various and disparate third-party systems.

2021-02-12T14:21:00Z
author avatar
Real User

We use SQL Server for our application data. As a government agency, all of our data is stored in our environment on-premises.

2021-02-11T18:46:53Z
author avatar
Top 5Real User

We use SQL Server to store, retrieve, and manage data.

2021-02-11T11:56:34Z
author avatar
Top 5LeaderboardReal User

Our server projects are mostly related to SQL Server, and we're using it. All our healthcare projects are using the SQL Server, and we're able to load millions of data without any issues.

2021-02-08T09:45:20Z
author avatar
Top 20Real User

The solution is our main database and stores our data at the organization. We're a Microsoft shop. That's why it's the main database. We have licenses for the servers. The only reason I'm using that is that that's what we have. However, I don't actually like working with it.

2021-02-02T07:46:00Z
author avatar
Top 5LeaderboardReal User

We primarily use the solution for non-management processes.

2021-01-27T11:24:04Z
author avatar
Top 20Real User

We primarily use the solution as a database for business operations.

2021-01-26T08:40:56Z
author avatar
Top 5LeaderboardReal User

The .NET applications use SQL Servers on a very large scale. Basically, about 80% or 90% of the database platform is on SQL Server. We are working on version 2019, but we are also now working on the cloud databases. Our goal is to stay away from versions. We are going to go version-less and move to Azure SQL or managed instance, which is version-less. This way we won't need to worry about any upgrades or any version changes because Microsoft is going to take care of these things. We will always have the latest and greatest version.

2021-01-23T13:47:39Z
author avatar
Real User

I handle the banking software. We have another software called City Life, a life insurance package. We develop those packages - the banking package and the life insurance package. We have almost 70 - 80% of the market share in our country. I also use and love Delphi. We develop in that language. The backend is SQL Server at this moment and we are researching how we can move from SQL Server to some other open source solutions.

2021-01-06T07:14:00Z
author avatar
Top 5LeaderboardReal User

We are a company that produces stock market analytics data and we are working on creating an alerting system for our customers. We use Microsoft SQL Server in our development and I have a lot of experience with it. In my development role, I store about two gigabytes of data every month.

2020-12-30T13:34:32Z
author avatar
Real User

We use the solution for many tasks. We use it as a data warehouse. However, we also use it for workflows and processing jobs.

2020-12-29T10:05:47Z
author avatar
Top 20Real User

Currently, I'm moving to another set of projects. One is for a small company that supports a client and is building on a different surface on the SQL server. The cloud that is used is essentially Amazon AWS.

2020-12-28T10:53:51Z
author avatar
Top 5LeaderboardReal User

We have a few use cases. They range from temporary storage to long-term storage to backup systems. We're using the full versatile suite for the product currently. It's not just a stand-alone system.

2020-12-24T07:39:41Z
author avatar
Real User

We are using this solution for application databases and data warehouses.

2020-12-09T17:43:34Z
author avatar
Top 5LeaderboardReal User

We primarily use the solution as a WAP server and we have it on-premises.

2020-12-08T15:13:05Z
author avatar
Top 5Real User

We are using this solution for business websites.

2020-12-06T10:59:48Z
author avatar
Top 20Real User

The primary use is to maintain my database client.

2020-12-03T12:47:24Z
author avatar
Top 5LeaderboardReal User

We use it mostly for integration into an ERP system. We also use it for our internal development of products.

2020-11-30T11:06:00Z
author avatar
Real User

We are a software development company. Most of our developers use SQL Server. We plan to continue using this solution in the future. We use SQL Server for relational database management. We have a variety of customers who use it in the government sector and in the tourism sector.

2020-10-28T19:12:04Z
author avatar
Top 20Real User

We are using SQL server for both transactional and analytical purposes, and for storing the data.

2020-09-03T07:49:44Z
author avatar
Top 5LeaderboardReal User

ERP Database. Using the SQL queries, the user can quickly and efficiently retrieve a large number of records from a database. In standard SQL, it is very easy to manage the database system. It doesn't require a substantial amount of code to manage the database system. Long established are used by the SQL databases that are being used by ISO and ANSI. Using the SQL language, the users can make different views of the database structure.SQL has a difficult interface that makes few users uncomfortable while dealing with the database.

2020-08-06T12:29:00Z
author avatar
Top 5Real User

We use on-premises, standalone deployment of SQL Server for our own CRM database. There are around seven to eight users in our company.

2020-08-02T08:16:00Z
author avatar
Top 5LeaderboardReal User

In my role as faculty, I would use it to facilitate having a database with all the teachers needed that are equivalent to Oracle as a database for a small scale project.

2020-07-26T08:18:59Z
author avatar
Top 20Real User

Our primary use case for this product is as a transaction database and for the provision of rational data through the application-based server. The main application of my current organization is pointing towards the SQL server database and some servers which are later used for data warehousing. So mainly we use it for transaction data and data warehousing. I'm the assistant manager and data administrator, and we are customers of SQL.

2020-07-22T08:17:25Z
author avatar
Top 5LeaderboardReal User

We are currently developing our own business application and we are using SQL Server as the database. We deploy it as a .NET application and the webserver is IIS. The SQL is a three-node clustered system.

2020-07-16T06:21:10Z
author avatar
Top 20Vendor

We use SQL Server to ingest and to extract reports for multiple customers.

2020-07-16T06:21:00Z
author avatar
Top 20Real User

We primarily use the solution for our daily operations.

2020-06-15T07:33:50Z
author avatar
Top 20Real User

My primary use case is for data mining and processing data from plants. It's normally just for databases for the systems.

2020-04-19T07:40:00Z
author avatar
Real User

We have a Windows Server environment. This is a production system for secure document issuing in a government department.

2019-09-22T17:46:00Z
author avatar
Real User

Our correlation and relational databases are on Microsoft SQL Server. The company uses two platforms: MySQL and Microsoft SQL Server. Some applications are on MySQL, and some applications are SQL Server. I have pretty much worked all my life in Microsoft SQL Server.

2019-03-24T08:52:00Z
author avatar
Consultant

Very pleasing and satisfying experience. * Used to create queries * Implemented store procedures * DBA can also use this effectively.

2019-03-07T09:15:00Z
author avatar
Real User

The customer's MES system use it. The database system desgin as always on architecture. Like Data guard in Oracle , always on contain double data and sync data by using transactions store in transaction log

2019-02-15T03:06:00Z
author avatar
Real User

* Effectiveness in a production environment * New features test

2019-02-13T15:52:00Z
author avatar
Real User

This is a departmental database engine which supports primarily localized solutions, data capture, and retrieval. However, with the exception of our aviation group, it is used for localized data lake or reporting solutions support.

2018-11-19T01:28:00Z
author avatar
Real User

I use SQL Server to optimize SQL queries and find the estimated cost of my queries. I also use it to fine tune my procedures and functions.

2018-08-10T00:57:00Z
author avatar
User

The database is primarily used as back-end storage.

2018-07-19T09:31:00Z
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
555,358 professionals have used our research since 2012.