SQL Server Primary Use Case

RK
Senior General Manager at Worly Plumbing Supply, Inc.

Most of our clients use SQL Server as a back-end source.

View full review »
HS
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.

View full review »
PJ
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
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
Software Engineer at Intelligent Systems

I use the solution in my company to take care of the database management area.

View full review »
MJ
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 »
Azizul Haque - PeerSpot reviewer
AVP, IT Division at NCC BANK LIMITED

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
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 »
Jayesh Bhandari - PeerSpot reviewer
Group IT Head at Ashapura Minechem Ltd

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 »
Sumeet  Zalpuri - PeerSpot reviewer
Data engineer at ASR Nederland N.V.

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 »
Praneeth N - PeerSpot reviewer
Director of Product Management at SID GLOBAL SOLUTIONS LLC

We use the tool to store and retrieve application data. It allows for storage via multiple threads and separates threads.

View full review »
Domenico Beneventano - PeerSpot reviewer
Professor at University of Modena and Reggio Emilia

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.

View full review »
Isam Ahmed - PeerSpot reviewer
System analyst at Ministry of Interior

We use it for warehouse data management, as well as for statistical reports. It facilitates tabling and query processing while supporting multiple database operations. 

View full review »
NC
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
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
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 »
DineshKumar27 - PeerSpot reviewer
Solution architect at Rackspace

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.

View full review »
XZ
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
IT Analysis at Kirkby (Tyres) Ltd

The solution is used as our backend database for our in-house applications. 

View full review »
MM
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
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.


View full review »
YM
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
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
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
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
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.

View full review »
JM
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
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.

View full review »
Ali Yazıcı - PeerSpot reviewer
IT Service Manager at Kuveyt Turk Participation Bank

We primarily use the solution for our banking database.

View full review »
MP
IT Cybersecurity and Compliance Coordinator at Plaenge

I use SQL Server for my SharePoint environment.

View full review »
Prashant Baste - PeerSpot reviewer
Sr. Solution Architect at Team Computers

We use this solution to extract data. We have a partnership with Microsoft and I'm a solutions architect. 

View full review »
MB
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 »
Ahmed-Ramy - PeerSpot reviewer
CEO at TMentors

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
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
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
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.

View full review »
Atal Upadhyay - PeerSpot reviewer
AVP at MIDDAY INFOMEDIA LIMITED

We use the solution to install different databases.

View full review »
PC
Independent Consultant at Unaikui

We use the solution for continuous integration, including CI/CD integration.

View full review »
EverVidal - PeerSpot reviewer
Architect of Solutions at Interbank

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
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.

View full review »
TP
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
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 »
Alvaro Callupe Arias - PeerSpot reviewer
Key Account Manager at Sumteccorp

We use SQL Server for tuning data transactional language.

View full review »
TL
SQL Database Administrator at Aurora Mental Health Center

We're primarily using the solution for our health record system.

View full review »
TN
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 »
Vishal Khare - PeerSpot reviewer
IT manager at Electrolux Home Products

We use SQL Server as a database solution.

View full review »
BC
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
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
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 »
Prashant Baste - PeerSpot reviewer
Sr. Solution Architect at Team Computers

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 »
Kevin Honde - PeerSpot reviewer
Data Solution Architect at Econet Wireless Zimbabwe

SQL Server is used as database software. People who are using .NET and Windows-oriented tools prefer SQL Server.

View full review »
RM
Digital Transformation Architect at Comdata

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

View full review »
Reza Sadeghi - PeerSpot reviewer
Software Development Team Lead at asa com

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 »
Rafael Keller - PeerSpot reviewer
IT Manager at Pluris Midia

The primary use is to maintain my database client.

View full review »
Matt Hardy - PeerSpot reviewer
Infrastructure Manager/Deployment Manager at Hivedome Consultancy Services

We use the solution as the backend for the application.

View full review »
DG
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 »
Mohamed Abozied - PeerSpot reviewer
Network Administrator at Alsafy

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. 

View full review »
Ariful Ambia - PeerSpot reviewer
Executive Director at a manufacturing company with 5,001-10,000 employees

We have a few transitional systems in our large company that we maintain with Microsoft SQL Server.

View full review »
US
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
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
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 »
Karoly Krokovay - PeerSpot reviewer
CEO at Informula Ltd

We developed a product for banks and we store the data in SQL Server.

View full review »
AS
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
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
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
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.

View full review »
Gajanan Shalgar - PeerSpot reviewer
Software Engineer at OMFYS Technologies India Pvt.Ltd

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 »
Sundaresan Subramanyan - PeerSpot reviewer
Founder and Managing Director at Analytic Brains Technologies Private Limited

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
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 »
Girish Vijay - PeerSpot reviewer
Deputy Manager IT at Carl Bechem Lubricants India Pvt. Ltd.

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
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
Chief ICT Officer at Barbados Public Workers Cooperative Credit Union Ltd

We use the product as a database for the applications. 

View full review »
Miyoba Sichimwi - PeerSpot reviewer
Information Technology Security Officer at South African National Accreditation System (sanas)

All our databases are using Microsoft SQL. It supports our application, such as HR and finance.

View full review »
AS
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 »
Ashif  Shaikh - PeerSpot reviewer
Senior Database Administrator at a tech services company with 501-1,000 employees

We are using it for storing important data. 

View full review »
Alaa T Alhorani - PeerSpot reviewer
Sr. Consultant (Enterprise Architect) at Devoteam

We use the product as a database, a data tool for everything. 

View full review »
RV
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
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 »
AhmedElbadry - PeerSpot reviewer
NMS Service Automation & RPA Technical Lead at Vodafone

The solution is a part of a product. We use it for our database, among other items.

View full review »
DI
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
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
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
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. 

View full review »
SB
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
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
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
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
IT manager at IRPC PCL

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

View full review »
Firaz Mohammed - PeerSpot reviewer
Information Technology Manager at a retailer with 51-200 employees

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.

View full review »
Karol Bura - PeerSpot reviewer
IT Manager at Drukarnia Interak sp. z o.o.

This is the main database for our financial system. I'm the IT manager and we are customers of SQL server. 

View full review »
Richard Vivian - PeerSpot reviewer
Chief Technology Officer at KOLOK SA

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 »
Serban Stancu - PeerSpot reviewer
Technical Director/ Project Manager / Consultant at SC Iceberg Data Intelligence SR

I am an integrator of this solution and my customers use this for ETL and reporting.

View full review »
Muhammad_Irfan - PeerSpot reviewer
Sr. Network Administrator at ACMC

We primarily use SQL Server as a database management system. 

This solution is deployed on-prem. 

View full review »
MF
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
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
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 »
Meindert Van Der Galiën - PeerSpot reviewer
Information Technology Software Developer at a financial services firm with 501-1,000 employees

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
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.

View full review »
JM
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
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
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
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
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
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
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
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. 

View full review »
НЕ
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
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 »
MakhosonkeMatshoba - PeerSpot reviewer
ESM Specialist at LetsCloudIT

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 »
Craig Kona - PeerSpot reviewer
Chief Information Officer at SYNOVA CONSULTANCT

We use SQL Server for developing systems.

View full review »
VB
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
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 »
Veerender Kumar - PeerSpot reviewer
Product Owner at Software Technology

We use SQL Server to manage and store information.

View full review »
EM
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
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
IT Manager at ducart

The solution can be used for a host of applications.

View full review »
AG
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
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
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.

View full review »
Mudasir Shafi - PeerSpot reviewer
Testing Lead at Enstoa

We are using SQL Server for data processing.

View full review »
IH
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
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. 

View full review »
KJ
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
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
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
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. 

View full review »
PR
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.

View full review »
SJ
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
Database Operation Assistant Manager at a consumer goods company with 10,001+ employees

I use the solution for analytics and reporting.

View full review »
KopanoRamaphoi - PeerSpot reviewer
Consultant at Rpc Data

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 »
Ryan Dave Brigino - PeerSpot reviewer
Software Engineer at Es'hailSat

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
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
Vice President, Product Engineering at Logitix

We primarily use the solution as a relational database system.

View full review »
MA
Owner at BNS

We are using this solution for business websites.

View full review »
RL
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 »
it_user823959 - PeerSpot reviewer
Works at a tech services company with 10,001+ employees

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
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 »
Ferhat Alkan - PeerSpot reviewer
Kurucu, Bilgisayar Programcısı at Optimus Yazılım

We are an independent software vendor and users of this product. I'm a company founder. 

View full review »
Al Fath Nuur Rochman - PeerSpot reviewer
Co-Founder at a logistics company with 1-10 employees

We're using SQL Server for database work.

View full review »
FN
Senior Database Administrator at ITGStore

We use the solution as a database for saving and managing data and applications.

View full review »
SR
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
Engineer at a manufacturing company with 10,001+ employees

We use this solution as our database.

View full review »
MP
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
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.

View full review »
EO
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
Managing Director at D3

We are using SQL Server for our financial application package.

View full review »
MR
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
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
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
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
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
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
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
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
Data Architect at ACPAS Loan Management Software

We primarily use the solution for non-management processes.

View full review »
JP
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
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
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
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.
View full review »
磊刘
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
Technical Content Writer at a computer software company with 51-200 employees

We primarily use the solution to store databases. 

View full review »
MO
Marketo Consultant at Webtech software servies

We use SQL Server for web application and website development.

View full review »
MR
Cloud DBA at UNIT4
  • Effectiveness in a production environment
  • New features test
View full review »
AK
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees

SQL Server is used for storing data.

View full review »
SF
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
Senior Systems Engineer at a energy/utilities company with 201-500 employees

We are using it for various applications.

View full review »
SY
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
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
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 »
it_user525360 - PeerSpot reviewer
Enterprise Programmes Architect at a logistics company with 10,001+ employees

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 »
it_user272976 - PeerSpot reviewer
Managing Director at a tech services company with 11-50 employees

Initially as a post-transactional database, but now it's mainly a transactional database and for Analysis Services.

View full review »
AJ
Data Analyst

We primarily use SQL Server for reporting.

View full review »
JP
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
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
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
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
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.
View full review »
JI
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
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
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
Engineer / MS SQL DBA at Solvinity

The database is primarily used as back-end storage.

View full review »
FK
Managing Partner at Veribir Ltd

We are using SQL Server for internal development projects.

View full review »
Anteneh Asnake - PeerSpot reviewer
Modern Data Center and Cloud Engineer II at IE Network Solutions PLC

We use the solution for managing our database functions.

View full review »
IF
CEO at a tech services company with 51-200 employees

The solution is used for database management.

View full review »
Girish Kumar. - PeerSpot reviewer
Consultant at Botmantra

We use the solution for managing database information from our clients and for testing database access.

View full review »
AA
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
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
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
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
Chief Information Officer at a tech consulting company with 51-200 employees

We use SQL Server for database management.

View full review »
SA
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
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
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
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
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
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.