No more typing reviews! Try our Samantha, our new voice AI agent.
it_user6414 - PeerSpot reviewer
CEO at a tech company with 51-200 employees
Real User
May 10, 2013
SQL Server offers tight integration at low pricing
Pros and Cons
  • "Database developers who want to have a clear logical and physical understanding of database systems will no doubt benefit much from using SQL Server."
  • "SQL Server work best with Windows Operating System and it is not compatible with some other systems hence limiting its platform friendliness."

What is most valuable?

• SQL Server provide end users and database programmers with a broad spectrum of services such as Analysis and Reporting services, Data Engine, Integration Services thus making database development and management easier and reliable. • SQL Server offers a platform on which data in all levels- structured, semi-structured, and unstructured data can be managed, integrated and analyzed thus enabling an organization to realize its mission-critical information. • Latest versions of SQL Server provide a handy development studio that not only make the creation of database objects easy but also offer useful tools such Object Explorer to allow quick processes.

What needs improvement?

• SQL Server work best with Windows Operating System and it is not compatible with some other systems hence limiting its platform friendliness. • Advance versions with higher functionality such as Work Group Edition have high installation requirement such as multi-processor computers, larger primary memory and are not open source.

What other advice do I have?

• Database developers who want to have a clear logical and physical understanding of database systems will no doubt benefit much from using SQL Server. I personally marvel at the extensible support provided by the management studio especially on disk and file management as I enjoy using SQL Server 2008. SQL Server is friendly to both beginners and experts and its installation process can be customized to suite different features.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user6579 - PeerSpot reviewer
it_user6579Engineer at a tech services company with 1,001-5,000 employees
Consultant

Good Article. Though i would like to add some points.

1) Microsoft SQL Server is easy to use and offers more features, like full support for triggers.
2) Closely integrated with Microsoft products like .NET Framework.
3) Various features for data restoration and recovery.
4) Microsoft SQL Server only runs on Windows-based servers.
5) Costly license fees.

it_user5520 - PeerSpot reviewer
Network Manager at a manufacturing company with 501-1,000 employees
Vendor
Apr 1, 2013
Will be my first choice for a DBMS again in the future.
Pros and Cons
  • "A great DBMS for organizations of all sizes."
  • "For each additional core feature you want to add to your DBMS edition, it is more money."

Valuable Features:

A great database management system for all size companies. SQL server is more user friendly than competitors. Provides easy installation. If you need support or research for the product, it is easy to find help online. There are 3 editions available which will meet any companies needs. Latest version is cloud ready. Offers power and flexibility.

Room for Improvement:

For each additional core feature you want to add to your DBMS edition, it is more money. This is not a FREE program as most other DBMS are. So basically, the more you want, the more you pay.

Other Advice:

A great DBMS for organizations of all sizes. Will be my first choice for a DBMS again in the future. The installation process was simple. You will pay for this SQL Server, but don't be afraid to try the free programs also.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user6579 - PeerSpot reviewer
it_user6579Engineer at a tech services company with 1,001-5,000 employees
Consultant

Yes agree with the author that the system is user friendly and installation process is also simple and hassle free. SQL Server is a relational DBMS and supports various features like triggers and many more. Though the features comes with the price which cannot be affordable for some organizations.

See all 2 comments
Buyer's Guide
SQL Server
May 2026
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
900,644 professionals have used our research since 2012.
PeerSpot user
Database Manager at a tech company with 51-200 employees
Real User
Feb 2, 2013
A tool of choice for many corporate environments
Pros and Cons
  • "SQL Server has a dynamic resource allocation feature that allows disk and memory usage to scale to meet changing database demands, providing better performance and simplifying software management."
  • "Reloading all the data in a database can cause potential data loss especially when the size of database is large."

Valuable Features:

• SQL server has dynamic resource allocation feature that allows disk and memory usage scale to meet changing database demands. This facility provides better performance and simplifies software management.• SQL Server’s Graphical Query Analyzer not only helps building stored procedures and interactive queries but also graphically displays the steps performed by query processor to execute the query. • SQL Server’s Online Analytical Processing (OLAP) provides services like data warehousing, data marts and decision support to many medium sized companies.• Data Transformation Services is a powerful and flexible tool provided by SQL server, it simplifies importing and exporting data between and OLE-DB compatible databases.

Room for Improvement:

• Installation and operation of SQL Server requires Internet Explorer (IE). • Reloading all the data in a database can cause potential data loss especially when the size of database is large. • No Cascading declarative referential integrity is available in SQL server.

Other Advice:

Microsoft SQL Server is the tool of choice for many corporate environments because it is a commercial database server. Its core role in the commercial world is only to store data which is slightly different than other databases like MS Access. In addition to data storage capability, MS Access allows developing a full user interface for data entry and reports generation. Whereas SQL Server simply stores data. Significant numbers of companies are moving to SQL Server. When it comes to costs SQL will very often make a very good business case.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user4524 - PeerSpot reviewer
it_user4524Founder & Principal Architect at a tech services company with 1,001-5,000 employees
Consultant

I politely disagree with the Cons portion of your review. SQL Server does not require Internet Explorer for installation and operation. The only optional module within SQL Server that requires IE present on the server (but not required for the end users) is SQL Server Reporting Services.

I also disagree with the statement about reloading data can cause data loss if the database is large. If the product is used properly, the potential for data loss is extremely small. I load large data sets quite frequently, and data loss simply does not occur. If you are experiencing data loss during loads, you might have an infrastructure problem that is contributing to instability.

Also, SQL Server has had cascading declarative referential integrity features since SQL Server 2000. See msdn.microsoft.com/en-us/library/aa902684(v=sql.80).aspx for more information.

See all 2 comments
reviewer1680246 - PeerSpot reviewer
Chief Engineer at a tech services company with 51-200 employees
Real User
Sep 30, 2021
Stable, straightforward installation, and priced well
Pros and Cons
  • "The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete."
  • "We used SQL Server to store all of our lab data on the database, with a front-end application that needed SQL in the background for archiving all the laboratory data."
  • "The solution could improve by having better integration."

What is our primary use case?

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.

What needs improvement?

The solution could improve by having better integration.

For how long have I used the solution?

I have been using SQL Server for approximately three years.

What do I think about the stability of the solution?

The solution could be more stable.

What do I think about the scalability of the solution?

We have approximately 200 users that use an application that uses the SQL Servers database.

How was the initial setup?

The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete.

What about the implementation team?

Our IT department does the implementation and maintenance of the solution.

What's my experience with pricing, setup cost, and licensing?

There is an annual license and it is priced reasonably.

What other advice do I have?

I would recommend this solution.

I rate SQL Server a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2026
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.