SQL Server Primary Use Case
RK
Ranjeet Kumar
Senior General Manager at Worly Plumbing Supply, Inc.
Most of our clients use SQL Server as a back-end source.
View full review »HS
HarkamalSingh
Works at a manufacturing company with 10,001+ employees
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.
PJ
PeterJones
Professional Services Manager at Business Intelligence DA
We are a solution provider and SQL Server is one of the products that we implement for our clients. People use SQL Server primarily for business intelligence.
If you have Navision or Dynamics AX, and you need a data warehouse to be able to improve the performance of your business, then that is what our company does.
For this review I will describe one of our clients. They are a large company that owns convenience stores, and they do several billion euros a year in business world wide. The convenience stores are located in large travel hubs like airports, train stations, office buildings, and large supermarkets. Everyone who flies/travels a lot has shopped in their stores. In Romania, they have 300 stores and sell between 300,000 and 500,000 items a day across the network.
This customer is very mature and we have provided a lot of features. The most important is forecasting. When the store manager comes to the store in the morning they receive an order proposal dashboard from us. We will have taken the data from the close of business the night before, then built a forecast for the manager to help decide what to order the next day. This a very important application. We are able to calculate the orders across the network better than the ERP can.
Another use case has to do with the actual items in convenience stores. They sell products such as cigarettes, drinks, sandwiches, magazines, and more. In Eastern Europe, there's still a high percentage of people that smoke cigarettes, and what you want to do, as a retailer, is negotiate your contracts with the large vendors.
There are people called buyers, and they sign contracts with the major suppliers. Our use case provides a tablet with a very rich dashboard to show everything that is going on between the buyer and the vendors that they buy from. In those negotiations, especially when dealing with very larger vendors, you sell millions of euros of goods, such as cigarettes, each year. The goal is that you are trying to get the vendor to give you a lower price. At the same time, the vendor is trying to get you to pay a higher price. That's business.
In that discussion, the person with the best data gets the best price. Naturally, it's a high-conflict discussion and you have to have a way of taking out the conflict and replacing it with a more logical, rational argument. The person with the best data wins the argument and gets the best price. That capability is worth a lot of money. Although only a dozen people use it, it's one of the top applications used by that customer.
View full review »Buyer's Guide
SQL Server
March 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.
PE
Phil Ernst
Chief Technology Officer at Wolff Logics
We use SQL Server for data warehousing or business-intelligent projects. When you leverage the solution with Azure, it's the only database you'll ever need. Oracle is overpriced, but Azure SQL and on-premise SQL are both great products.
View full review »JA
Jem Ahmed
Software Engineer at Intelligent Systems
I use the solution in my company to take care of the database management area.
MJ
seniorda483732
Senior Database Administrator at a comms service provider with 10,001+ employees
We primarily use the product for internally developed applications. There's some business intelligence and data warehousing used as well as some financial information.
View full review »We use it for the banking database. It is for banking software, accounting software, and human resource software that we develop to run our bank.
In our production environment, we are using SQL Server 2014 Enterprise, but we also have an installation of SQL Server 2019 for our development environment.
View full review »HB
reviewer1264416
Domain architect at a financial services firm with 10,001+ employees
There are many applications between Microsoft and SQL. Most are in the legacy direction, but some are more modern databases with those application requirements. We have used it for multi-purposes such as back-office products applications and cloud office environments.
View full review »SQL Server is very useful in managing databases for various applications. It is easy to use, making it accessible even for those with limited skills. SQL is a preferred choice for handling limited data. Additionally, Microsoft provides excellent support for SQL Server.
View full review »We extracted data from SAP and stored it in SQL Server. We created a connection between the Data Services Server and the SQL Server. If anything went wrong, there were SQL Server experts who took care of everything. So, we extracted data from our ERP system and stored it in SQL Server.
View full review »We use the tool to store and retrieve application data. It allows for storage via multiple threads and separates threads.
View full review »There are no specific use cases attached to the solution. From an academic point of view, I make the tool available to the students for some training or tests. I also used it to compare the functionalities of Oracle Data Integrators with other data integration systems.
We use it for warehouse data management, as well as for statistical reports. It facilitates tabling and query processing while supporting multiple database operations.
NC
Nick S.
System Design Manager at a manufacturing company with 10,001+ employees
We use the solution to provide the database layer for multiple applications.
View full review »MH
Mohammed Habeeb
System Administrator at ARTIc
We are using SQL Server for the backend of our SAP and are planning on moving to a cloud version soon.
View full review »AM
Aju Mathai
Database Architect at Huron Consulting
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.
View full review »There are three variations available within SQL Server, the first one being that you can migrate your SQL instances from an on-premises version to the cloud. Second, you have an option to modernize the SQL platform and move to managing instances on the cloud. Third, SQL Server has an offering called Azure SQL, where you can deploy Azure instances in a flexible manner, and it can automatically scale up or down, depending upon the requirements. There are specific features you can license, as per the CPU cores and transactions you deal with in your business. There are various models of the tool that are available.
XZ
Xiaoqing Zou
Integration developer at Blackwoods
SQL Server, a widely adopted database management system, is utilized across numerous sectors. Initially competing with Oracle and Db2, SQL Server has gained popularity. It serves as the backend database for a variety of applications.
View full review »SE
Simon Evans
IT Analysis at Kirkby (Tyres) Ltd
The solution is used as our backend database for our in-house applications.
View full review »MM
Mpho Morake
Group CEO at Mmusi Group
We do data warehousing on it. We have databases on it. A lot of our applications use it for transactions and data.
We're using version 2019. We're trying to migrate to 2021 because 2023 is not yet that stable.
View full review »AK
Anandan Kanagarajan
Sr. Supervisor - Enterprises Application DBA at a manufacturing company with 10,001+ employees
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.
YM
YahyaMahdy
Senior Data Engeer at Qbros
We use the solution for data quality purposes like checking, testing, and writing its cases using data validity and quality measurements.
View full review »RN
reviewer1695144
President at a consultancy with 1-10 employees
This client, specifically, is using it for Dynamics NAV. I don't know what they're calling it today. Microsoft changes the names all the time, 365 NAV Dynamics. This is ridiculous. We're using it for that, and we have more of a niche CRM database called Tour de Force. It's owned by a company called White Cup. They own a bunch of companies, and it sits on Microsoft SQL, as well.
View full review »PL
reviewer1056471
Manager Global Identity & Access Management at a healthcare company with 10,001+ employees
SQL Server is our primary database for identity access management.
View full review »BL
reviewer1389651
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
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.
View full review »DV
Dany Van Den Steen
Database Administrator at Court of Audit Belgium
In my data warehousing project, I use SQL Server alongside Power BI. SQL Server serves as the data storage solution, while Power BI is used for data visualization.
JM
JasminaMarkovic
BI Developer at a tech services company with 51-200 employees
SQL Server is used to establish secure storage and protect databases from potential vulnerabilities, including those originating from Slack.
View full review »FR
Francisco Racionero
CEO Owner at ALESON ITC
We are consultants and users of this solution and we deploy both on cloud and on-prem. The primary use case of this solution is for its Health Check feature. I'm the company owner and CIO.
We primarily use the solution for our banking database.
View full review »MP
Marcelo Pissinati
IT Cybersecurity and Compliance Coordinator at Plaenge
I use SQL Server for my SharePoint environment.
View full review »We use this solution to extract data. We have a partnership with Microsoft and I'm a solutions architect.
View full review »MB
MichaelBarnett
Sr. Training Manager with 201-500 employees
It has all of our data. Our company sells contracts when you buy a car. We sell aftermarket insurance for the tyre, wheel, ding, dent, windshield, etc. When somebody buys a contract, we capture all of that data into a legacy database PostgreSQL, and my task is to incorporate that into our financial platform using T-SQL. So, I write queries, procedures, and views. I use SSIS, and I use SSRS. My job is to get the data into our financial system so that we can process claims, payments, cancellations, and refunds.
In terms of its version, we're up-to-date. We have version 2019.
View full review »We use the solution on FastAutomate, our core product, to store the aggregated data from different nodes. It resides on the server that's handling the agents. We also use it for different organizations for development. Therefore, we use it for development mainly.
View full review »SS
Shivanshu Srivastav
IT Manager : HOD at Condot Systems
We use Microsoft SQL Server as our main database. We implement our solutions to the client site, providing the machines and the SQL Server license depending on their requirements.
The SQL Server is being deployed on-prem. Most of our clients are from the pharmaceutical industry. If there is a physical database, they want a self-hosted server always on-premises. However, the market is slowly adapting to cloud servers. Scalability and security have increased, so now people are going with cloud servers like AWS, Azure, and Google Cloud. Most of our clients are hosted on-premises and they have their own server, so we don't go with any cloud server. However, we are planning to move ahead with cloud servers for many of our clients.
View full review »MA
Maurice Aelion
Senior DBA & IT Consultant at MA Consulting
We use the latest version.
Most SQL Server applications come with package applications from the shelf. This means that when one buys an application, most of these applications work with SQL Server as a basis. They add SQL Server as a database to applications which come with it that one buys. As such, I don't see many people developing new applications with SQL server.
View full review »RN
reviewer1572765
Manager at a pharma/biotech company with 10,001+ employees
We have hundreds of databases that are using SEL Server and there may be other capabilities.
We use the solution to install different databases.
View full review »PC
Prajith Chowthee
Independent Consultant at Unaikui
We use the solution for continuous integration, including CI/CD integration.
View full review »I have SQL Server running in an on-premise environment, but we are testing it out on the cloud. We are trying out using APIs to access a database. SQL Server creates a lot of opportunities for us. While some of the larger companies have Oracle, SQL Server is more common in Peru. I'm responsible for administration and implementation, including configuration and data replication.
View full review »AM
reviewer1635153
VP Global Information Technology at a insurance company with 10,001+ employees
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.
TP
Tim Platson
Solutions Architect at One Click
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.
View full review »MP
reviewer1570953
Database Administrator at a computer software company with 10,001+ employees
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.
View full review »We use SQL Server for tuning data transactional language.
View full review »TL
Tim Lenz
SQL Database Administrator at Aurora Mental Health Center
We're primarily using the solution for our health record system.
View full review »TN
ThembaNhlapo
System engineer at a financial services firm with 51-200 employees
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.
View full review »We use SQL Server as a database solution.
View full review »BC
BruceCollins
Senior Developer at a government with 51-200 employees
Usually, we use a lot of the vendor software, like ManageEngine, and stuff like that. They use Postgres, however, I prefer to use Microsoft's SQL server. We have a couple of servers and we integrate that information into it. I can run reporting and analysis off of that.
View full review »RU
reviewer1524594
Senior Solutions Architect at a manufacturing company with 51-200 employees
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.
View full review »SM
Sanjeeb Mohanty
Global Head ICT (CITP & MIE) at The Aga Khan Academies
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.
View full review »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.
View full review »SQL Server is used as database software. People who are using .NET and Windows-oriented tools prefer SQL Server.
View full review »RM
RogerMorera
Digital Transformation Architect at Comdata
We developed a product that is using five or six databases supported on SQL Server.
View full review »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.
View full review »The primary use is to maintain my database client.
View full review »We use the solution as the backend for the application.
View full review »DG
reviewer1001628
Information Systems Manager at a aerospace/defense firm with 51-200 employees
It is used for the backend database for our ERP system and the document management system. We are using its latest version.
View full review »I use the SQL Server for backups and for creating databases and a lot of other stuff. I also use it to shrink data and some stuff like this.
We have a few transitional systems in our large company that we maintain with Microsoft SQL Server.
View full review »US
Uchechi Sylvanus
Team Lead, Process Improvement at Fidelity Bank Plc
I use the client, however, I can also use the server, the Microsoft SQL Server Studio. I can use both, both the client and the studio.
We connected Automation Anywhere to the DB. Our reporting tool is also connected to that DB. Our financial application is also connected to the DB and some other databases too as well as some of our APIs.
View full review »PT
Paulo Toscano
Database Administration Team Leader at a transportation company with 10,001+ employees
We use it for both database services and analysis services.
View full review »SL
reviewer1385976
Enterprise Architect at a educational organization with 10,001+ employees
We use SQL Server for our application data.
As a government agency, all of our data is stored in our environment on-premises.
View full review »We developed a product for banks and we store the data in SQL Server.
View full review »AS
Amir Saudi
Business Intelligence Manager at a consumer goods company with 10,001+ employees
We have a large amount of information and data. We are using a lot of business models for our menu mix.
View full review »GK
reviewer1671969
Data Architect at a computer software company with 1,001-5,000 employees
We do data warehousing, and our clients are mainly large commercial Insurance providers in the United States.
View full review »SK
Santosh Kurakula
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
We use SQL Server as a relational database mostly for the application backend activities and integrations.
View full review »OK
OmidKoushki
Solution Architect at KIAN company
I have been working on SQL Server for installations, configuring for developers, and for creating backup jobs from the MBF files.
I use SQL Server for .NET. We have ERP software in the background and we use the SQL Server for its creation.
View full review »SQL Server can be useful for a lot of businesses and enterprise solutions. SQL Server is very powerful and useful when you need to store, retrieve, process, and analyze a large amount of data. In my organization, almost everyone uses SQL Server. That's about 10 people using it.
View full review »GS
Gheorghe SANDRU
Managing Partner at Bizz Advisers SRL
We use this solution to manage our database and store information. I use another platform for more specific needs.
Within our organization, there are roughly 10-12 employees using this solution.
View full review »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.
View full review »MM
reviewer2112948
Consultant at a transportation company with 10,001+ employees
We do backups or restore or query tables to create the views, create some triggers to send the attachment report files, and to report on data.
View full review »IG
Irwin Gibson
Chief ICT Officer at Barbados Public Workers Cooperative Credit Union Ltd
We use the product as a database for the applications.
View full review »All our databases are using Microsoft SQL. It supports our application, such as HR and finance.
View full review »AS
Azeezulla Sheriff
General Manager IT at a manufacturing company with 10,001+ employees
This application is used as a contact center and would be great for banks.
View full review »We are using it for storing important data.
View full review »We use the product as a database, a data tool for everything.
RV
reviewer1624716
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees
We primarily use the solution mainly for databases on all types of applications.
View full review »MS
reviewer1428423
Head of Technical Support at a real estate/law firm with 51-200 employees
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.
View full review »The solution is a part of a product. We use it for our database, among other items.
View full review »DI
Dimitris Iracleous
Lead Technical Instructor at codehub
We are a company that possesses data relating to the banking and telecommunications sectors. We use the solution to organize all data received from subscribers and customers.
View full review »MB
reviewer1494501
BI Developer at a manufacturing company with 1,001-5,000 employees
We use this solution to analyze the profitability of sales.
Within our organization, there are roughly 30 people using the analysis services solution from the Business Intelligence side.
View full review »ST
reviewer1022898
Director at a tech services company with 10,001+ employees
We use SQL Server to process a lot of data. We are using versions and 2015 and 2018.
View full review »AS
Aditya Sawant
Assistant Manager at ECU
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.
SB
Shanti Sahu
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri
We use SQL Server to ingest and to extract reports for multiple customers.
View full review »NY
reviewer2265342
Consultant at a tech company with self employed
The solution is used primarily for medium companies in vertical accounting applications. We use the solution as a good general-purpose database.
View full review »KG
reviewer1488372
Associate Manager at a consultancy with 501-1,000 employees
We use SQL Server to import data from different source systems. Depending on requirements, you act as the resource and can schedule jobs in the Azure environment. The server can be stopped when not required so there's no cost when it's not being used. We make use of the pipeline to put the data into the SQL Azure environment and extract it to the server. I'm the associate manager.
View full review »JJ
JohannesJoubert
Business Solutions Architect at a real estate/law firm with 501-1,000 employees
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.
View full review »NS
Navee Srichaiyanont
IT manager at IRPC PCL
We primarily use the solution as a WAP server and we have it on-premises.
View full review »We use SQL Server to host our ERP system. It serves both as the underlying database and server application software. This database solution handles all our ERP calls.
This is the main database for our financial system. I'm the IT manager and we are customers of SQL server.
View full review »We use SQL Server for storing all our company information, such as ERP, customer applications, and our wealth management systems. All of our data is stored in SQL Servers.
View full review »I am an integrator of this solution and my customers use this for ETL and reporting.
View full review »We primarily use SQL Server as a database management system.
This solution is deployed on-prem.
View full review »MF
Mohamed_Farouk
Information Technology Manager at OrchidaSoft
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.
View full review »BM
Biswajit Mohanty
Senior Manager - RPA & Transition at a financial services firm with 10,001+ employees
Typically, the SQL Server is used in many, many ways. We primarily use SQL Server when there is a data requirement for our projects.
Typically there are uses around where you are creating a database. I've yet to store the data in our RPA server. We need MS Excel through Microsoft.
Any sort of RPA process where you require data through housing data or using a database, you need an SQL Server.
View full review »SB
Surendra Bajracharya
Software Manager at a computer software company with 1-10 employees
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.
View full review »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.
View full review »MN
Michael Ndwiga
IT Officer at a manufacturing company with 201-500 employees
While we were still using the solution, we employed version 2008, which is a bit on the old side.
We basically used the solution for hosting the database for Sage ERP.
JM
reviewer1715886
SQL Server Senior Architect at a computer software company with 1,001-5,000 employees
SQL Server can be used for managing and storing information.
I have a lot of databases with more than one terabyte of information and we use technology, such as Stretch database to switch out the information to Azure databases with this type of technology.
View full review »YT
reviewer1478394
Information Security Manager at a financial services firm with 501-1,000 employees
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.
View full review »FA
Florent ADODO
IT Assistant at Hotel 2 Fevrier
We use SQL Server with Sage products.
It is used by our finance team and also human resources.
View full review »HP
hugodpereira
Computer engineering student at a educational organization with 501-1,000 employees
I primarily use the solution for the development of various applications, database connections, that I need for projects.
I just use it myself, for assignments. I am a student and am studying the product.
View full review »HV
Helder Valente
Infrastructure and Networks at a financial services firm with 10,001+ employees
We use this solution for data warehousing and products to the platforms developed by the company.
View full review »VP
reviewer1501629
Chief Information Officer at a financial services firm with 501-1,000 employees
We use SQL Server for our internal applications.
View full review »MM
reviewer1187943
Director of Data Analytics at a insurance company with 1,001-5,000 employees
We are using this solution for application databases and data warehouses.
View full review »SP
SashisekharPanda
General Manager/MVP at Yotta Infrastructure Solutions LLP
We use on-premises, standalone deployment of SQL Server for our own CRM database. There are around seven to eight users in our company.
НЕ
Недашковский Евгений
Senior SQL DBA at a financial services firm with 51-200 employees
Usually I install an SQL Server as part of something bigger from Microsoft (NAV, CRM, SharePoint, SCCM, SCOM, BizTalk, etc.) or some custom built solution that was designed around this DMBS.
I also teach in a university. My students admit that SQL Server is quite easy to install and work with if you are a total beginner (compared with others).
View full review »BG
Gh0ce
Systems Analyst/DBA at Vecima Networks
The primary use of SQL Server is to store and retrieve data. If you go into the extra features that come with your license, you can also do reporting, analytics and ETL.
View full review »We use this solution to store our data and for running queries, simple select queries that enable me to create the views I need and report from those views. I'm an ESM specialist and we are customers of SQL Server.
View full review »We use SQL Server for developing systems.
View full review »VB
reviewer1803756
Data Analyst at a financial services firm with 501-1,000 employees
I'm a web developer, and I use SQL for the backend.
View full review »BR
reviewer1037115
senior system integrator at a retailer with 10,001+ employees
We primarily use the solution as a backend server.
There are a few applications of the Oracle product for our data sitting on the SQL Server as well.
View full review »We use SQL Server to manage and store information.
View full review »EM
reviewer1703928
Enterprise Solutions Architect at a comms service provider with 501-1,000 employees
We use SQL Server as a database management system for all of our projects.
View full review »VG
reviewer1322280
Regional Head Customer Experience at a financial services firm with 10,001+ employees
We use a tool called Tosca for automation and all the automation artifacts we are saving are on the SQL Server.
View full review »ID
Irad Dukad
IT Manager at ducart
The solution can be used for a host of applications.
View full review »AG
Alberto Geminiani
Technical Director at Progetti e Soluzioni
We primarily use the solution for recording transactions and information related to the reservation of a service.
View full review »AM
reviewer1359642
Sr. DBA/Developer at a financial services firm with 5,001-10,000 employees
We primarily use the solution for our daily operations.
View full review »NM
NipunaMaliga
Systems Specialist at Zillione Technology
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.
We are using SQL Server for data processing.
View full review »IH
reviewer1159494
Advisory Software Engineer at a tech services company with 1,001-5,000 employees
Our use case is creating data warehouses using the SQL Server database.
The solution is deployed on-premises and on public and private clouds.
View full review »RC
Ryan Cerney
Principal JDE Business Analyst at a manufacturing company with 201-500 employees
All of our .NET applications and some of our third-party applications require a single server database, AutoCAD, and things like that. Our custom apps are the largest estate of databases.
In our production environments, we're on version 17. I've worked with the most recent version but not in a production environment.
KJ
reviewer1233759
Deputy Manager at a computer software company with 10,001+ employees
We are business consults. We use SQL Server to ensure that critical applications remain operational by performing BCM activities across application and database servers.
View full review »RZ
Roman Zubrytsky
Principal, Sr. IT Consultant at a consultancy with 51-200 employees
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.
View full review »CL
reviewer1621938
Senior BI Consultant at a tech services company with 11-50 employees
Our primary use case is for SQL Server is data warehousing and business intelligence.
View full review »MY
reviewer1523223
IT at a financial services firm with 201-500 employees
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.
PR
reviewer1569966
Technical Specialist at a media company with 10,001+ employees
I primarily use it to extract some configuration information for my product - in order to understand how the configuration is done for my base product.
SJ
reviewer1407519
Chief Technology Officer & Vice President, Delivery at a recruiting/HR firm with 1-10 employees
We are a product-based company, and we use it as part of our product. It is deployed in a public cloud and on-premises.
View full review »AW
reviewer1566654
Database Operation Assistant Manager at a consumer goods company with 10,001+ employees
I use the solution for analytics and reporting.
View full review »We are a solution provider and this is one of the products that we implement for our clients.
It can be used for different things such as data warehousing and online transactional processing (OLTP). This is a product that I have never used in production, however.
View full review »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.
View full review »MM
reviewer1522923
Head of IT, CTO at a insurance company with 51-200 employees
We are using this solution as a database. The main purpose is as an SQL Server.
View full review »MS
Mike Sax
Vice President, Product Engineering at Logitix
We primarily use the solution as a relational database system.
View full review »MA
MartinAnderson
Owner at BNS
We are using this solution for business websites.
View full review »RL
Rmegio Lawag
Technical Department Manager at Direcbusiness Technologies, Inc.
We use it mostly for integration into an ERP system. We also use it for our internal development of products.
View full review »Implementing solutions for controllers and project managers on their financial data for 10 years, and now using the Power BI Microsoft solution.
View full review »HT
Hoang Ta
System Engineer at CMC CSI saigon
SQL Server is only running in China, it is not connected to our site.
We have some PCs running on Windows 7, but it is not supported.
View full review »We are an independent software vendor and users of this product. I'm a company founder.
View full review »We're using SQL Server for database work.
View full review »FN
Florent NOPOUDEM
Senior Database Administrator at ITGStore
We use the solution as a database for saving and managing data and applications.
SR
reviewer1653840
Director -Data Architecture and Engineering
We are using SQL Server to build and store our whole company's data in our data warehouse.
View full review »MC
reviewer1642500
Engineer at a manufacturing company with 10,001+ employees
We use this solution as our database.
View full review »MP
Mohammed-Pasha
CEO at SkyNet
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.
View full review »ST
MD.SIHAB TALUKDAR
System Engineer at asa
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.
EO
Edgar Orare
Senior Systems Engineer at Dimension Data
It is for supporting our custom applications. We have a number of custom applications that we use that have SQL embedded.
I am using the version before the latest one.
View full review »TU
TonderayiUsada
Managing Director at D3
We are using SQL Server for our financial application package.
View full review »MR
reviewer909060
IT Developer at a financial services firm with 10,001+ employees
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.
View full review »IC
reviewer1646865
ICT Consultant at a tech services company with 11-50 employees
We have used it in a variety of ways, including for e-commerce deployments.
View full review »OB
Ossama Benaziz
Operations Director at ALTERSIS Performance
We use the product for information systems. This is a must both for us. We use it for our Enterprise Portal.
View full review »DB
reviewer1473555
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees
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.
View full review »SB
Sipho Ngubonde
Admin at IEC (Electoral Commission of South Africa)
SQL is our main data store for enterprise applications, all applications that we have in the organization.
View full review »VC
reviewer938061
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
SQL Server is the database for the transactional database that is being used.
The solution can be used for the BI, the data warehouse part as well, but mostly I have seen it used for the transaction data being stored by the DBMS part of it.
View full review »MK
Mazen Kassem
Senior Digital Services Engineer at a pharma/biotech company with 1,001-5,000 employees
We only use it as a logging solution. We use it as logging for processing our database. It holds records for some systems and so on. That's it.
View full review »SW
Stephan Warreyn
GF at Innopact GmbH
We primarily use the solution for data storage. We use it for its data warehouse, BI services, and AI.
View full review »KV
Karel Van Der Walt
Data Architect at ACPAS Loan Management Software
We primarily use the solution for non-management processes.
View full review »JP
reviewer1470330
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees
We use the solution for many tasks. We use it as a data warehouse. However, we also use it for workflows and processing jobs.
View full review »KG
reviewer1413750
Lead Data Architect at a financial services firm with 1,001-5,000 employees
We are using SQL server for both transactional and analytical purposes, and for storing the data.
View full review »JM
Johan Malan
System administrator at a mining and metals company with 10,001+ employees
My primary use case is for data mining and processing data from plants. It's normally just for databases for the systems.
View full review »PS
reviewer1030020
Programmer Analyst at a tech services company with 10,001+ employees
Very pleasing and satisfying experience.
- Used to create queries
- Implemented store procedures
- DBA can also use this effectively.
磊刘
Lei Liu
DBA,data architectuire at LG CNS Co.
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
View full review »HG
reviewer1595568
Technical Content Writer at a computer software company with 51-200 employees
We primarily use the solution to store databases.
View full review »MO
Manjunatha OK
Marketo Consultant at Webtech software servies
We use SQL Server for web application and website development.
View full review »MR
Menoj-Roekalea
Cloud DBA at UNIT4
- Effectiveness in a production environment
- New features test
AK
reviewer977976
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees
SQL Server is used for storing data.
View full review »SF
Stefano Festa
CEO at netison
We manage backups for our customers, so we are not developers and we don't use SQL to provide a service. We are a managed service provider focused more on IT support and SQL configuration. So we don't use SQL as a product by ourselves. Instead, we provide instructions for how to back up SQL and do maintenance on it for our customers who need a SQL server for their CRM and ERP products. Their products need to have a SQL server to use in order to use their services. So we handle the maintenance for our customers.
View full review »DK
reviewer1314546
Senior Systems Engineer at a energy/utilities company with 201-500 employees
We are using it for various applications.
View full review »SY
cto267069
CTO at a tech services company with 11-50 employees
The solution is primarily used as a relational database. It's a great option for anyone who needs to still use a database.
View full review »PS
reviewer1643577
Project Manager at a comms service provider with 51-200 employees
SQL Server is our main database solution. For example, we use it for our contact center software.
View full review »RS
reviewer1309482
Business Analytics Manager at a transportation company with 201-500 employees
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.
View full review »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.
View full review »Initially as a post-transactional database, but now it's mainly a transactional database and for Analysis Services.
View full review »AJ
Abaso Jadhav
Data Analyst
We primarily use SQL Server for reporting.
View full review »JP
reviewer1561038
Chief Technology Officer at a financial services firm with 11-50 employees
The main use of this solution is to control and manage data storage information.
View full review »DS
reviewer1430925
Technical Director at a security firm with 51-200 employees
It is used for many things. We primarily use it for our two-tier and three-tier applications.
View full review »EN
reviewer1564890
Head of Data Analytics at a tech services company with 11-50 employees
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.
View full review »RS
Rahul Kumar Singh
Software Developer at OATI
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.
View full review »DM
DenisMunger
Chief of Engineering at a comms service provider with 11-50 employees
We use it
- to capture long distance calls for billing
- as a quoting database
- to redirect phone calls based on customer caller line id.
JI
reviewer1707912
System Analyst and Team Lead at a tech services company with 11-50 employees
I am a professional and I use this SQL Server in different companies. One of the companies I worked for was in the automotive industry. They had automobile products which they developed the SQL Server and database. At that time it was the first time I used SQL Server. I have also used Suprema which is a biometric system that also had an SQL Server. Our main products for data we have used SQL Server. However, my main application is developed on Oracle and MySQL, not any other database solution.
All of our systems use this solution, it can control security, data management, and integration.
View full review »RP
reviewer1362969
IT Specialist at a government with 1,001-5,000 employees
We use SQL Server for collecting and storing our data.
View full review »OY
reviewer1503438
Specialist Systems Engineer at a tech services company with 51-200 employees
We use SQL Server for database integration as we sometimes use queries to take information from the database. For example, if I need a couple of information that is archived or not indexed, I will inform the SQL Server team to help.
View full review »PF
Paul Fijma
Engineer / MS SQL DBA at Solvinity
The database is primarily used as back-end storage.
FK
Faruk Kutlu
Managing Partner at Veribir Ltd
We are using SQL Server for internal development projects.
View full review »We use the solution for managing our database functions.
View full review »IF
reviewer1593270
CEO at a tech services company with 51-200 employees
The solution is used for database management.
View full review »We use the solution for managing database information from our clients and for testing database access.
View full review »AA
reviewer1556808
ASM at a healthcare company with 51-200 employees
It's a database that we use for our commercial applications, and our ERP sits on it.
View full review »SK
reviewer1491816
Senior Architect at a computer software company with 10,001+ employees
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.
View full review »WL
reviewer1484775
Senior Programmer at a tech services company with 51-200 employees
We primarily use the solution as a database for business operations.
View full review »GA
GhamdanAl-Anesi
Member of the Board & Co-Founder, Executive Manager at Networld Systems
We have a Windows Server environment.
This is a production system for secure document issuing in a government department.
View full review »SP
reviewer1614828
Chief Information Officer at a tech consulting company with 51-200 employees
We use SQL Server for database management.
View full review »SA
Shafeeq Ahamed
Enterprise Solutions Department Manager at Smart Vision
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.
View full review »MG
reviewer1546989
CEO at a tech services company with 11-50 employees
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.
View full review »SS
reviewer1085256
Software Engineer at a tech services company with 10,001+ employees
We use SQL Server to store, retrieve, and manage data.
View full review »SA
reviewer1680246
Chief Engineer at a tech services company with 51-200 employees
We used SQL Server to store all of our lab data on the database. We had a front-end application that needed SQL in the background for archiving all the laboratory data.
View full review »CL
reviewer1410678
Data Analyst at a tech company with 51-200 employees
I use this solution as our data warehouse.
We use the reports, data analysis, and for connecting our databases to multiple resources.
View full review »KH
reviewer1517148
Program Solution Architect at a tech services company with 11-50 employees
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.
View full review »Buyer's Guide
SQL Server
March 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.