SQL Server Valuable Features

RK
Senior General Manager at Worly Plumbing Supply, Inc.

Agent service is a good feature of SQL Server, where you can schedule certain tasks. The solution's encryption feature allows the data to be encrypted while transferring from one place to another. The solution's performance and speed are also good. Indexing and Magic Tables are very good features of SQL Server. We have a different transition style with the solution.

View full review »
HS
Works at a manufacturing company with 10,001+ employees

It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale.

PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades.

Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching. 

View full review »
PJ
Professional Services Manager at Business Intelligence DA

SQL Server is very popular in this region because of the price.

From version 2014 to version 2016, the performance really improved. We also moved to new hardware, resulting in a four-times speed-up of the processing. Now we can supply a 16-core, 15TB, data warehouse loading hundreds of thousands of transactions per day for $100,000 purchase or cheaper via hosting partners. The price of SE for the features it provides is why we use it so often.

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,995 professionals have used our research since 2012.
AhmadTalha - PeerSpot reviewer
Product owner at Digitt Plus (AFT)

SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational.

The solution's security features are good. 

View full review »
PE
Chief Technology Officer at Wolff Logics

The fact that SQL Server fully integrates within the entire Microsoft ecosystem is a plus.

View full review »
MJ
Senior Database Administrator at a comms service provider with 10,001+ employees

The ease of administration, in general, is the solution's most valuable aspect.

You can make the solution work pretty fast. Performance isn't an issue.

The initial setup is quick and easy.

The solution is stable.

The scalability is good. 

View full review »
Azizul Haque - PeerSpot reviewer
AVP, IT Division at NCC BANK LIMITED

We use SQL Server Reporting Services, and it is very good. We use scheduled jobs to transfer reports from one server to another server. 

View full review »
HB
Domain architect at a financial services firm with 10,001+ employees

The solution is easy to use, has rich feature sets, and is business-oriented. 

View full review »
Jayesh Bhandari - PeerSpot reviewer
Group IT Head at Ashapura Minechem Ltd

SQL Server is very easy to use. A person with limited skill also can handle the software easily. The retrieving time of the data is very fast. You don't require any higher configuration machine for that. If you have very limited resources, you can easily manage.

View full review »
Sumeet  Zalpuri - PeerSpot reviewer
Data engineer at ASR Nederland N.V.

Whenever we had to restore the data, it was not as difficult as restoring the database to any other RDBMS. The restoration of data is very easy compared to any other database. The solution is very intuitive and easy to use. It is one of the best relational database systems in the market. The restore and backup strategy was not complicated. The ease of use was excellent compared to any other databases.

View full review »
Praneeth N - PeerSpot reviewer
Director of Product Management at SID GLOBAL SOLUTIONS LLC

I find query optimization to be highly valuable for data management. Additionally, drag-and-drop query creation greatly facilitates data management tasks.

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

I can't comment on the valuable features of the product right now since I recently downloaded some whitepaper and manuals. I downloaded the documentation related to the tool, but I haven't used much of the system. I know that SQL Server is a good system, based on a report I read on the Gartner website.

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

The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables.

View full review »
MH
System Administrator at ARTIc

We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables.

View full review »
AM
Database Architect at Huron Consulting
  • Performance-wise, it is an excellent tool.
  • It is a Microsoft product, so there's a lot of support. 
  • It's not a new tool; it has been around for a while. 
  • It is one of the top five relational databases in the market. 
  • It is very user-friendly.
  • There are a lot of resources available for it.
View full review »
SE
IT Analysis at Kirkby (Tyres) Ltd

Having everything in one centralized set of databases is the most valuable feature.

View full review »
MM
Group CEO at Mmusi Group

It works fine in terms of performance and stability.

View full review »
AK
Sr. Supervisor - Enterprises Application DBA at a manufacturing company with 10,001+ employees

- There are hundreds of "Dynamic Management Views" (DMVs) & Dynamic Management Functions (DMFs) that are system views & system functions that return metadata of the system state and they provide valuable insight into the current SQL instance state. 

- Resumable online index rebuild 

- Table Partitioning and the Swap out to covert a Table Partition into a separate table.

- Python & R2 Integration, Graph Databases

- Automatic Database Tuning

- Very reliable Backup technology and many more

View full review »
YM
Senior Data Engeer at Qbros

The valuable features are Excel integration, writing a query in SQL Server, exporting the data, and copying the data.

View full review »
RN
President at a consultancy with 1-10 employees

One of the things I most like about SQL Server is the log shipping piece.

I have another client who uses GP, and they use Power BI to take the data out of the back end. I'm doing an IT assessment there, so I'm not really involved in that specifically, other than the fact this person has too many rights.

I have an auditing background, and I spent 25 years doing IT auditing as well. I understand I'm not a programmer, but I've been involved with enough of them. The log shipping really is one of the greatest features. It is not the only database you can do it in, but that was one of the better features of it because I am a backup nut. We use Veeam Backup and Replication to a local mass storage, but then we fully replicate everything in Veeam to another site with the exact same server set up at our other location. But I wasn't satisfied with that from a disaster recovery point of view. My IT company was, but I was not. I said, "I want to do SQL log shipping. I want to do an SQL backup and SQL log shipping and move it to Azure in the cloud," which is what we do every day. We have an hour by hour backup, in addition to our multiple nightly backups and our replication to our other site, and we've had to use it and it worked. This is a great feature.

View full review »
PL
Manager Global Identity & Access Management at a healthcare company with 10,001+ employees

What I find most useful in SQL Server is that it's easier to manage and to query. Its databases are well-designed. It's easy to do any changes, and it's easy to query the database through reports and whatever information you need.

View full review »
BL
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees

The most valuable aspect of the solution is that the metadata is just generalized. Metadata is the way that data is described both for technical aspects of building a database and for the user interfaces. Our metadata is the objects attached to the database, not in the software. 

It helps with moving the design of the database into reality.

View full review »
DV
Database Administrator at Court of Audit Belgium

The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities.

View full review »
JM
BI Developer at a tech services company with 51-200 employees

The most valuable aspect is the ability to use jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed.

View full review »
FR
CEO Owner at ALESON ITC

I like the Always On tool which improves the SQL server availability. We cross-link servers with Oracle, MySQL and other platforms using PolyBase as a service to join with big data systems like Spark.

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

Overall, it's a very good device.

The solution has proven to be very stable.

The scalability potential is very high.

The initial setup is very straightforward and the deployment happens very quickly.

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

The most valuable feature of SQL Server is that it is easy to set up.

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

This is a user-friendly solution. It's great that I can extract the data from the SQL server and store it in my local data source for BI purposes.

View full review »
MB
Sr. Training Manager with 201-500 employees

I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome.

View full review »
Ahmed-Ramy - PeerSpot reviewer
CEO at TMentors

Overall, we've been satisfied with the capabilities of the product.

The solution is stable. It works without issue - to the point you rarely need any technical support at all.

The scalability is very good.

It's got an easy initial setup.

View full review »
SS
IT Manager : HOD at Condot Systems

The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL Profiler and sqlcmd as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly. As a part of optimization, it is good for processing huge amounts of data.

View full review »
MA
Senior DBA & IT Consultant at MA Consulting

A valuable feature of the solution is that it is comparatively simpler to manage than Oracle. Now that the Linux version is an option, this can be taken into consideration, since Windows limited one's use to things which could only be done in Windows. 

View full review »
RN
Manager at a pharma/biotech company with 10,001+ employees

It's a standard product that is used with standard applications, which is why we use it.

There is no lack of features.

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

We mostly use linking servers and several applications; one pulls data from another. Thus, we created a Linked Server and implemented a replication algorithm to facilitate data transfer between different sources.

View full review »
Raphael Haroun  Ikyagh - PeerSpot reviewer
Network Administrator at Letshego

The product enables us to grant access to users. The product is easy to use.

View full review »
AR
Works at a financial services firm with 51-200 employees

For my business requirements, the performance is good. If we use it on a larger scale, it will not fit our business needs.

It is easy to use.

It has simple syntax, but you must check your packet on a daily basis.

View full review »
SS
Senior Software Developer at a manufacturing company with 5,001-10,000 employees

Out of all the tools in the complete SQL Server package, I'm mainly using Toolbox and SQL Profiler because I'm using SSIS packets, so we're using job scheduling a lot. And sometimes we are creating the SSIS packages, so I'm using SQL Server for MSD for maintenance purposes. SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot.

View full review »
TP
Solutions Architect at One Click

Scalability, cluster ability, ease of use, ease of implementation — these are all great. 

View full review »
MP
Database Administrator at a computer software company with 10,001+ employees

Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms.

View full review »
Alvaro Callupe Arias - PeerSpot reviewer
Key Account Manager at Sumteccorp

The product’s most valuable features are flexibility and scalability.

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

The solution comes at a more effective price than Oracle. 

It's a little bit more advanced than using MySQL or NoSQL.

It's more prevalent in the industry than SQL Postgre.

The initial setup is mostly straightforward.

The product is scalable. 

The stability has been mostly pretty good.

There is a lot of information about the solution readily available online.

View full review »
TN
System engineer at a financial services firm with 51-200 employees

The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features.

We do not know all the features of SQL Server.

View full review »
Vishal Khare - PeerSpot reviewer
IT manager at Electrolux Home Products

The performance of the SQL Server is very good.

View full review »
BC
Senior Developer at a government with 51-200 employees

There's a lot of great features. I like T-SQL, which is wonderful. The backups are excellent. There's a lot of things that are much easier to manage. All of the features and functions within the SQL language itself, the store procedures, I really, really enjoy. The security has been excellent.

The initial setup is very straightforward. 

The stability is very good.

We find it easy to scale if we need to.

View full review »
RU
Senior Solutions Architect at a manufacturing company with 51-200 employees

The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application. Additionally, the solution is simple and if it is configured properly it performs very well. 

View full review »
SM
Global Head ICT (CITP & MIE) at The Aga Khan Academies

It is a stable product, and it runs seamlessly. It is not complex.

It has been there for a long time, and they are doing whatever bug fixes they have to do. 

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

The basic features of the solution are excellent overall.

The initial setup isn't overly complex.

The pricing is reasonable.

The solution scales well.

The solutions very fast. It reads and writes six to eight times faster than any other tool.

View full review »
Kevin Honde - PeerSpot reviewer
Data Solution Architect at Econet Wireless Zimbabwe

It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based.

It is a very stable product, and it has got backup and recovery tools.

View full review »
RM
Digital Transformation Architect at Comdata

It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage.

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

One of the big advantages of this product is its performance, where it works well when the data is not complex.

View full review »
Rafael Keller - PeerSpot reviewer
IT Manager at Pluris Midia

What I like best about this product is the environment.

The documentation and manuals are very good.

View full review »
SA
Applications Business Intelligence Analyst at a aerospace/defense firm with 10,001+ employees

There are many, but I would have to say the two most important for me have been SQL Server Profiler -- to run traces and the ability to kill sessions in the enterprise manager tool. This command-based functionality lets you search and sort through processes actively running on the system to find your i/o hog – that is the user that is overloading the database either through a hung query or bad SQL code.

Once the hog user is found, the terminate or “kill” command can be used to shut down the hanging transaction. Similar to how clearing a vehicle crash on the interstate frees up waiting traffic, this kill command gives other users the ability to continue work as normal once the terminated transaction has been killed. This should be used sparingly though since it can cause waiting applications to corrupt data depending on how the application was written, but it is an often used research feature when a system starts to overload or show major signs of slowing.

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

SQL Server is easy to use, but there is a great deal of complexity that you can dive into to use it to its best. Also, it integrates well with other platforms.

View full review »
BL
Owner at 2 Bit

The solution is very fast. 

The data is reliable and I can normalize the database and normalize the data so that I can collect whatever information I need. If I collect the data correctly, then I can share whatever report I want.

Normally, when the data is in the database, it will always be a long-term information holder, instead of putting it in Excel or something like a spreadsheet or something like that. 

For me, the initial setup is very easy as I have years of experience with the product.

View full review »
FZ
Principal Database And Cloud Architect at a financial services firm with 10,001+ employees

I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it. 

You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers.

View full review »
DG
Information Systems Manager at a aerospace/defense firm with 51-200 employees

The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query.

View full review »
Mohamed Abozied - PeerSpot reviewer
Network Administrator at Alsafy

The solution is great for creating backups.

You can create databases using this product.

I like the way you can shrink the volume using SQL.

It's a very stable solution.

I've found the product to be able to scale well. 

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

SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server.

View full review »
US
Team Lead, Process Improvement at Fidelity Bank Plc

I like the way it can manage the users from the security section where you can change their roles. 

SQL is simple to manage, as long as you know the script, and know the tables that you make reference to. If there are errors, you can easily debug them. 

You can easily debug and resolve your issues. 

The ease of backup, how you can back up and call up your backups too is great. Backups hardly get corrupt, except if maybe you have some bad hard drive clusters or bad hard drive sectors.

It is stable.

It's an easy-to-use product.

I find the solution to be scalable.

View full review »
PT
Database Administration Team Leader at a transportation company with 10,001+ employees

I believe Always On is the most valuable feature. It's also easy to use and not very tricky.

View full review »
SL
Enterprise Architect at a educational organization with 10,001+ employees

SQL Server is easier to use than Oracle, programming-wise.

It is the latest technology and pretty powerful in terms of the high availability of the virtual server.

View full review »
ChristineSpence - PeerSpot reviewer
Software Solutions Account Manager at First Technology

SQL Server is easy to manage. 

View full review »
AS
Business Intelligence Manager at a consumer goods company with 10,001+ employees

We are using the net for our environment. We're using the ADF Azure data factory for our analysis services, and it is pretty good.

View full review »
GK
Data Architect at a computer software company with 1,001-5,000 employees

It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC. You don't have to do all the scripting for the database, then all the tables, keys, etc. It takes all that out of your hands.

View full review »
SK
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa

The SQL Server is low maintenance, it does not require advanced technical skills to maintain or use it as you might in other similar database solutions. You need some knowledge on how to access the solution and how to query it but it is fairly straightforward.

View full review »
OK
Solution Architect at KIAN company

The solution is very easy to use.

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

SQL Server and their offers are very good. You can switch over, export, and do other things. I got access from users and it is very flexible to use.

View full review »
LA
Manager Digital Technologies at a real estate/law firm with 51-200 employees

When you use the solution with Azure, for example, you get very good scalability. You can scale fast, whether it is horizontal or vertical.

If we use the product as a PaaS, Platform as a Service, it comes with all the security features you need - including against DDoS attacks.

The product offers good bloc storage, which you can buy at an additional cost. This allows you to have large object storage if you need it.

Over a period of time, their split engine has evolved and in the latest version, they've done a lot. Even from the management tool perspective, a lot of things have been done. A lot of functions have been added.

The initial setup is pretty straightforward.

Technical support has been good.

The solution has the capability to scale.

The pricing isn't as high as other options.

SQL is very easy to use. That's a very good thing about it in general.

View full review »
Sundaresan Subramanyan - PeerSpot reviewer
Founder and Managing Director at Analytic Brains Technologies Private Limited

SQL Server's Management Studio is very user-friendly. I like their database and the additional features it offers. It's also easy to integrate SQL Server with things like CLR, PowerShell, and command shell

View full review »
Girish Vijay - PeerSpot reviewer
Deputy Manager IT at Carl Bechem Lubricants India Pvt. Ltd.

The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful. Two other new batch mode features, memory grant feedback, and adaptive joins will enhance SQL Server's performance and efficiency as well. It is good to move from Microsoft to deal with big data analytics

View full review »
MM
Consultant at a transportation company with 10,001+ employees

It makes managing the database easy. Backups are very quick.

View full review »
IG
Chief ICT Officer at Barbados Public Workers Cooperative Credit Union Ltd

We don't encounter any issues with the solution. 

View full review »
AS
General Manager IT at a manufacturing company with 10,001+ employees

The backup capabilities are extremely good.

View full review »
Ashif  Shaikh - PeerSpot reviewer
Senior Database Administrator at a tech services company with 501-1,000 employees

Its security is good. The GUI of SQL Server is also very good.

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

SQL Server, as a database, is great.

When it comes to the governmental sector, it is easily dealt with and can handle a big load of data. Specifically, after they added the capability of building a big data cluster from the SQL Server itself it's been great. 

If it was a database developer who was working with it or database admin, it provides a lot of tools and potential utilization that helps in doing the work in the right way.

Stability-wise, it's stable. 

If we want to expand to other servers and create an extra node, it's expandable. If you want to connect it with another, let's say, cloud node, it's also expandable with the cloud node. 

Security-wise, it provides most of the required security aspects in the market suchg as hashing, or encrypting, or hiding some data in tables (according to privileges and tools of the users). That can be done throughout it easily. 

It's an out-of-the-box solution. Lately, after they created the SQL Azure, if you use the Azure SQL Explorer, or SQL Server Management Studio, both of them can connect to the same database easily. It's natively built on the same core.

View full review »
RV
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees

The solution is very stable. 

The scalability of the product is great.

View full review »
MS
Head of Technical Support at a real estate/law firm with 51-200 employees

SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well.

View full review »
AhmedElbadry - PeerSpot reviewer
NMS Service Automation & RPA Technical Lead at Vodafone

The solution is very stable.

The product scales well.

From a security perspective, we have no complaints. 

The initial setup is very straightforward. 

View full review »
DI
Lead Technical Instructor at codehub

I feel that this is the simplest of solutions. It is user-friendly, is a robust tool and is always reliable to users. The solution is within the Windows environment. This means that all users, who are already accustomed to Windows, will naturally prefer to use this environment over that of Linux or another operating system. 

View full review »
MB
BI Developer at a manufacturing company with 1,001-5,000 employees

The performance can be great. Tuning and understanding SSAS is not straightforward.

View full review »
ST
Director at a tech services company with 10,001+ employees

We like the whole product and we use most of the features.

View full review »
AS
Assistant Manager at ECU

Security is obviously the most valuable feature because I can provide certain logins for a particular level of security and I can provide specific permissions for certain logins. That's a very good feature. I like the user interface as well, it's easy to use. The SSMS Management Studio, which we use to do some work in database file query is a recent feature from 2018 and the SSMS is quite good. It has many features and it also shows the query statistics which I was not getting previously. The other feature I like is the query store which helped me a lot to analyze the data getting hit on the database. 

View full review »
SB
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri

The feature that I have found most valuable is that it is easy to code. You can very easily get a resource to work on that. For example, if we have a big project it's hard to get a good resource in the IT industry. However, since SQL Server is the most popular solution, you can easily get resources to use it so the risk factors are very, very low. Even if someone leaves the company, you can easily replace them.

Additionally, it is very stable. 

You don't need to struggle for anything. Most of the codes are there.

View full review »
PS
Project Advisor at A private sector Company

I would rate MS SQL Server 4/5 for its ease of administration,rich features, Nice GUI support for all its complex features.

Valuable features include:

1.Management Studio (Nice GUI support for all its complex features.)

2.Hot add CPU

3.Configure Dynamic memory also configure MIN and MAX memory.( Very flexible)

4.Replication ( Very Simple).

5.Clustering (The best high availability feature available among all
its compitators due to its robustness and scalability).

6.SSIS ( Very rich).

7.In memory OLTP in SQL Server 2012

8.Always On (High Availability) in SQL Server 2012

9.SQL Server Profiler

10.DMVs

View full review »
NY
Consultant at a tech company with self employed

I value the ability it gives me to test on small machines and easily scale up to larger devices for live applications.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

The best feature in SQL Server is the CDC mechanism for adding data incrementally. Another good feature is the ability to store any type of data in SQL Server, it's a big advantage.

View full review »
JJ
Business Solutions Architect at a real estate/law firm with 501-1,000 employees

Support and adoption are important because skills are available to lower the total cost of ownership. 

High availability, read-only copy synchronization, and data integrity mean that it is relatively easy to ensure data security, availability, and integrity. Lower tier SKUs offer high-end features.

Data integration is available, as SSIS offers a flexible data integration platform with rich features including .NET integration for web-service integration, or bus architectures.

SSAS analytical DBs are powerful yet easy to develop and own.

SSRS offers enterprise reporting that is reasonably user-friendly.

It is easy to deploy cloud/on-premises hybrid implementations with a familiar and consistent toolset.

View full review »
NS
IT manager at IRPC PCL

The pricing of the product is very good.

We've found the stability to be very reliable.

The initial setup isn't too complicated. It's pretty straightforward.

View full review »
it_user422262 - PeerSpot reviewer
CEO/CTO at a tech services company with 51-200 employees

Probably the most useful feature of SQL Server is the ability to write and execute SQL on the fly.

Even though there are some very useful features on Oracle, MySQL, and other platforms, the SQL Server by far has the most robust capabilities of any database platform.

In my experience with numerous coding languages and platforms, the SQL Server has the only programming language that allows the user to create, compile, and execute code in its own language.

To clarify, Java, .NET, PL/SQL and all other programming languages can dynamically create code, but not their own. In other words, Java can dynamically create SQL and execute it, but it cannot create Java and compile/execute.

Other great features are:

  • Passing tables as parameters
  • Table valued functions
  • Horizontal table partitioning
  • Very granular disk partitioning
View full review »
Firaz Mohammed - PeerSpot reviewer
Information Technology Manager at a retailer with 51-200 employees

SQL Server provides access to audio information and audio tables. You can customize and create views. The ability to customize and upload these services is uncertain when migrating, but SQL in a local environment or Azure seems suitable for now. The ability to see tables, reviews, and custom script options is good.

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

SQL Server is a very mature solution.

View full review »
Serban Stancu - PeerSpot reviewer
Technical Director/ Project Manager / Consultant at SC Iceberg Data Intelligence SR

This solution is user-friendly and easy to understand.

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

One of the most valuable features of SQL Server is that it's easy to use. 

View full review »
AL
Senior Service Architect at a tech services company with 501-1,000 employees

While I don't like SQL Server so much, the selection was for clients so we needed to utilize it. Of course, one thing is that as great with this and other Microsoft products is that it's quite well documented and there are also light versions available. If you need to do something, you can also try it somehow on your own computer and so on. 

If I'm helping a client to define what they need to have or what they need to do in a public sector procurement process quite often we cannot fix the database as it would be limiting the competition. That's why we never rule out the SQL Server; it should be included as an option at this level.

The solution is stable. 

I haven't had issues with sizing or scaling.

View full review »
MF
Information Technology Manager at OrchidaSoft

It is easy to maintain, and it's easy to set up.

It is also easy to develop. Overall, it's easy.

It can work with many different sizes of data, anywhere from 10 to 50 gigs of data.

The performance of SQL Server is perfect. It does not need to be enhanced.

View full review »
BM
Senior Manager - RPA & Transition at a financial services firm with 10,001+ employees

The solution is extremely stable. The performance is reliable.

The scalability of the solution is very good.

Technical support is pretty good. they are prompt in their responses.

View full review »
SB
Software Manager at a computer software company with 1-10 employees

The only problem with this product is that it doesn't have an open source version.

View full review »
Meindert Van Der Galiën - PeerSpot reviewer
Information Technology Software Developer at a financial services firm with 501-1,000 employees

The solution is very easy to use for me. SQL is the most user-friendly system for databasing aside from Postgres. 

Due to the financial costs of Postgres, the SQL system is a good alternative as the product can be utilized free of charge. 

It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it.

View full review »
PV
BI Specialist at a educational organization with 1,001-5,000 employees

SQL Server is a highly stable solution.

View full review »
MN
IT Officer at a manufacturing company with 201-500 employees

Stability and usability, which is quite simple, are two of the solution's most valuable features. 

View full review »
MO
Senior Manager at a financial services firm with 201-500 employees

We find the Microsoft SQL Server affordable compared to its real competitors. 

We find it easy to manage. 

It offers a very robust infrastructure for us.

The solution is easy to set up.

We have found the stability to be good.

We've had a good experience with technical support. They are helpful.

View full review »
YT
Information Security Manager at a financial services firm with 501-1,000 employees

We have found the feature that allows us to publish web applications to be valuable. 

We have 20 servers and we use disparate ones for different applications, such as Kaspersky Anti-Virus Server and Windows SharePoint in respects of the surveillance system. 

View full review »
FA
IT Assistant at Hotel 2 Fevrier

the database management tool is very easy to use and largely meets expectations

View full review »
HP
Computer engineering student at a educational organization with 501-1,000 employees

The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services.

The solution is very stable.

The solution scales well.

The initial setup is straightforward. 

View full review »
HV
Infrastructure and Networks at a financial services firm with 10,001+ employees

We like everything. We use all of the features that SQL offers. 

We like business integration, database, and analysis.

View full review »
VP
Chief Information Officer at a financial services firm with 501-1,000 employees

Working with SQL Server, it is quite convenient to use the SSMS tools to write a profile. I also like the profiling tools.

I like that the new version has a memory-optimized table to improve the performance.

View full review »
MM
Director of Data Analytics at a insurance company with 1,001-5,000 employees

That question is not that easy to answer, to say that there is a feature in a database that you like more than others. When you are running a database, you expect it to do many different things, and if fails in one area, it basically takes it out of the picture completely.

View full review »
SP
General Manager/MVP at Yotta Infrastructure Solutions LLP

The features that we have found the most valuable are reliability, availability perspective, and current scalability. 

View full review »
НЕ
Senior SQL DBA at a financial services firm with 51-200 employees

Always On is my favorite feature. I do like availability groups and cannot imagine how I lived with them before. 

Microsoft tries to release new features with every version, but I cannot say that they are killer features. Usually these are just "nice to have" stuff. However, SQL Server works and it works just fine. It is really reliable if you don't shoot your own leg. All the basic functionality is 100% bulletproof. 

View full review »
BG
Systems Analyst/DBA at Vecima Networks

Everything is valuable. It is a relational database system which is critical for storing reporting data or any data that is highly relate-able. Plus your data is one of the most important assets in your company.  Might as well have a good system to protect it.

View full review »
SA
IT Director at DAR AL ARKAN

Apart from the standard SQL database-related features, the 2012 version enables the AlwaysOn functionality which enables two or more SQL Servers that can be clustered, with heartbeat across geographic locations along with high availability failover and 99.9999% uptime.

View full review »
MakhosonkeMatshoba - PeerSpot reviewer
ESM Specialist at LetsCloudIT

I like the stability of the solution, the fact that you have two, three, four nodes replicating at any given time at different locations, and they're all synchronized; if one is lost it automatically moves to another. The other advantage here is that when it comes to application maintenance, you switch onto another node while you maintain another server and there's no downtime. 

View full review »
Craig Kona - PeerSpot reviewer
Chief Information Officer at SYNOVA CONSULTANCT

The most valuable feature of SQL Server is the performance.

View full review »
VB
Data Analyst at a financial services firm with 501-1,000 employees

The most valuable aspect of the solution is its ease of use.

It's a pretty stable solution.

We found it to be quite scalable. 

View full review »
BR
senior system integrator at a retailer with 10,001+ employees

It's useful as a backend server.

We have found the solution to be scalable. 

View full review »
Veerender Kumar - PeerSpot reviewer
Product Owner at Software Technology

They have improved the UI and ease of accessing the database and server which is good.
You can load it up and start using it from the very minute it is implemented.

View full review »
VG
Regional Head Customer Experience at a financial services firm with 10,001+ employees

The solution is easy to use and provides similar features to other competitors.

View full review »
AG
Technical Director at Progetti e Soluzioni

The product is very stable.

It offers very good documentation. When there are some little issues, it's always very easy to go into the documentation for troubleshooting purposes. There's just so much documentation on hand and a really great community around the product that is very helpful.

It's a very complete product.

We've found it to basically be pretty problem-free.

The integration with other products has always been quite good.

The security of the product has never given us any issues.

View full review »
AM
Sr. DBA/Developer at a financial services firm with 5,001-10,000 employees

The performance is a very valuable aspect of the solution.

SQL is very easy to manage.

View full review »
NM
Systems Specialist at Zillione Technology

Its availability for a secured server is one of its most valuable features. Also its replication features are valuable- we can manage eight replicas. Their clustering and availability groups are also valuable.

View full review »
it_user79482 - PeerSpot reviewer
Senior Developer at a tech vendor with 201-500 employees

Without any doubt the Integration Services and Analysis Services are the most widely used. These are the basis for data quality, data gathering, ETL process, as well as collation for the data warehouse, Cube-generation, and ad-hoc processes. The ease in which you may mold a process flow or even modularly add in new structures is something which is much needed in my job.

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

The most valuable features of SQL Server are the speed, great support, and it is from a known vendor.

View full review »
IH
Advisory Software Engineer at a tech services company with 1,001-5,000 employees

The solution has a user-friendly environment and supporting functionalities. It also has great memory and processing databases.

View full review »
RC
Principal JDE Business Analyst at a manufacturing company with 201-500 employees

I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else.

They've been adding a lot of great functionality such as columnstore indexes to improve the way indexes are rebuilt and to be able to do online index rebuilds. All those are great features.

View full review »
KJ
Deputy Manager at a computer software company with 10,001+ employees

SQL Server has scaled as per our requirements.

View full review »
RZ
Principal, Sr. IT Consultant at a consultancy with 51-200 employees

It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups. It's quite an interesting feature that enables high availability for the SQL Server. I think it's important. So that's the feature that I'm particularly interested in and it works pretty well.

View full review »
CL
Senior BI Consultant at a tech services company with 11-50 employees

I have found the whole solution with all its features wonderful.

View full review »
PR
Technical Specialist at a media company with 10,001+ employees

The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product.

You don't really need a learning code to study MySQL. If you know the basics, it's quite easy to use the product. There isn't a high learning curve and you don't have to be overly technical.

The initial setup was straightforward.

View full review »
SJ
Chief Technology Officer & Vice President, Delivery at a recruiting/HR firm with 1-10 employees

It is easy to use and very stable.

View full review »
AW
Database Operation Assistant Manager at a consumer goods company with 10,001+ employees

I have found the most valuable features to be the flexibility and the vast amount of features available.

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

The most valuable feature is that it is easy to use and you don't have to do a lot of configuration. For example, there is no installation.

When you want to insert data, it is easy to do. For example, if I want to test something then I log into my GitHub account, download what I want, and then upload it to the SQL server.

The integration with other products like SQL Developer is really good. Connecting it to Visual Studio is also quite good.

View full review »
Ryan Dave Brigino - PeerSpot reviewer
Software Engineer at Es'hailSat

The solution is quite stable.

The solution has the capability of scaling.

The performance is good. 

It's very easy to use.

View full review »
MM
Head of IT, CTO at a insurance company with 51-200 employees

It's much more friendly in comparison with Oracle.

We are using the standard features. I don't see any areas that can be simplified with the standard functionalities. We don't use any special extended features.

From my point of view, using SQL Server 2017 and 2019 is very good. I haven't experienced any issues or been in a situation where I was struggling with problems for which I didn't have access to proper documentation or proper functions.

View full review »
MS
Vice President, Product Engineering at Logitix

The solution offers very high performance.

It is a very reliable solution. We find it to be quite stable.

We've found the product to be very scalable, specifically from MSSQL

The product offers various deployment models.

View full review »
MA
Owner at BNS

The most valuable features are programmability and reliability.

View full review »
RL
Technical Department Manager at Direcbusiness Technologies, Inc.

We have been using SQL Server from the start, so it's a stable product.

View full review »
it_user823959 - PeerSpot reviewer
Works at a tech services company with 10,001+ employees

SSAS is the most interesting feature to organize the data and let the users play with it.

SSIS is also very powerful, but not always user-friendly. It requires you to build a solution around SSIS.

View full review »
Ferhat Alkan - PeerSpot reviewer
Kurucu, Bilgisayar Programcısı at Optimus Yazılım

The most valuable feature for me is that the database engine is always on.

View full review »
VA
Data Analyst at a healthcare company with 10,001+ employees

SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful.

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

What I find most valuable in SQL Server is that it's user-friendly.

View full review »
FN
Senior Database Administrator at ITGStore

Most valuable features include: high availability, clustering, save backup and recovery.

View full review »
SR
Director -Data Architecture and Engineering

SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties.

View full review »
MP
CEO at SkyNet

What I like most is the management, as it is very easy compared with other products.

View full review »
ST
System Engineer at asa

The most valuable feature is the system architecture.

View full review »
it_user715902 - PeerSpot reviewer
CEO and Founder at a tech services company

Performance improvements, optimizer enhancements. Most of our clients have high demands for performance, and this version of SQL Server delivers what we need.

View full review »
PN
Data Analyst at a media company with 1,001-5,000 employees

The ability to organize and structure our data in order to extract and provide it to various products and systems within our organization. It is widely used and has great online support from many third-party sites.

View full review »
it_user290769 - PeerSpot reviewer
Enterprise Architect with 51-200 employees
  • Business intelligence platform
  • Analysis services (multidimensional and tabular)
  • Relational database features
  • Data extraction and transformation (integration services)
View full review »
EO
Senior Systems Engineer at Dimension Data

Its usability is very good. Its performance is satisfactory.

View full review »
TU
Managing Director at D3

One of the best features of SQL Server is the efficient retrieval of information.

View full review »
IC
ICT Consultant at a tech services company with 11-50 employees

The solution is easy to use.

The deployments are very easy.

Technical support is very helpful.

The product can scale if a company needs it to.

The stability is quite reliable. 

View full review »
OB
Operations Director at ALTERSIS Performance

The solution has proven to be very flexible.

The product is quite stable.

Overall, we've found it to be extremely easy to use. 

The initial setup is pretty straightforward. It's not difficult to implement and the deployment doesn't take too long.

Technical support has been pretty good so far. They are helpful.

It's a good option for those that have a lot of Microsoft solutions in use.

View full review »
DB
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees

SQL SSIS is the most useful aspect of the solution.

We find the product to be relatively stable.

The solution seems to be pretty flexible.

View full review »
it_user158343 - PeerSpot reviewer
Software Architect at a tech consulting company with 51-200 employees
  • SQL Server Integration Services tools
  • Data Quality Services tools
  • Master Data Services tools
  • SQL Server Reporting Services tools
  • Data Partitioning (Horizontal Partitioning) tools
  • ColumnStore Indices
  • In-Memory OLTP tables
View full review »
it_user290733 - PeerSpot reviewer
IT Consultant & IT Project Manager Assistant with 10,001+ employees

The SSIS, SSRS, and DB are the most valuable features because they help in everything.

View full review »
it_user158343 - PeerSpot reviewer
Software Architect at a tech consulting company with 51-200 employees

SQL Server integration services tools

Data quality services tools

Master data services tools

SQL Server reporting services tools

Data partitioning (horizontal partitioning) tools

ColumnStore indexes

In-memory OLTP tables

View full review »
VC
Sr. Solution Architect at a computer software company with 5,001-10,000 employees

The solution is very easy to use, because even the technical engineers that we get are able to use it more efficiently. I like the programming interface they have where they help us get the table names that we are dealing with, and the field names in that particular table. 

The interface for building the queries or writing the store procedures is good.

View full review »
MK
Senior Digital Services Engineer at a pharma/biotech company with 1,001-5,000 employees

The solution is stable.

The product is scalable.

The solution is configurable. 

View full review »
SW
GF at Innopact GmbH

If you compare the SQL Server with the block storage it's stable and it's working. 

The product has been on the market for over 25 or 30 years. It's an extremely mature solution.

The solution is pretty scalable.

The initial setup is pretty straightforward, depending on your requirements.

View full review »
KV
Data Architect at ACPAS Loan Management Software

The product is very good at centralizing information.

The solution has very good features related to timezones.

The product is quite stable.

If you need to, you can scale the solution very easily.

View full review »
JP
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees

The analytics are pretty good.

As a data warehouse and storage solution, it's quite good.

It's easy to put the data back onto the SQL Server or Oracle. 

The solution is pretty fast. We find it to be responsive.

There are a lot of services, such as the SSISS, SIS, and SSI's that work quite well.

View full review »
KG
Lead Data Architect at a financial services firm with 1,001-5,000 employees

The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.

View full review »
JM
System administrator at a mining and metals company with 10,001+ employees

The availability is the most valuable feature. It has high availability. It also has good performance. 

View full review »
PS
Programmer Analyst at a tech services company with 10,001+ employees
  • Creating and executing SQL queries, transactions, ACID properties
  • Creating and implementing stored procedures.
View full review »
磊刘
DBA,data architectuire at LG CNS Co.

table partition options,  that is very useful to separate unnecessary cost. 

For legacy data,  we can do partition swith out and store into flat files or old tables.

When it necessary, we can switch in back.

View full review »
it_user796899 - PeerSpot reviewer
Sr. Database and Application Administrator with 10,001+ employees
  • Ease of installation.
  • Ease of creating your databases.
  • Ease of changing what your databases look like when you need to.
  • Creating tables is simple.
  • They have lots of different options that you can use for the fields within the tables. 

It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work.

It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that. It also will do clustering, so you can have two database servers looking at the same data simultaneously. 

You can always access the data. You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations.

View full review »
it_user143286 - PeerSpot reviewer
Senior IT Consultant/Program Mgmt at Consultant
Activity Monitor and Dynamic Management Views View full review »
HG
Technical Content Writer at a computer software company with 51-200 employees

Since MongoDB, we have come up and there are lots of tools that do enhance the database management system or keep an eye on our data. People can easily access it. 

The solution is stable. It's reliable. 

The initial setup is simple. 

View full review »
MO
Marketo Consultant at Webtech software servies

The most valuable features of this solution are easy queries and straightforward programming for beginners.

View full review »
MR
Cloud DBA at UNIT4
  • SSMS
  • SSIS
  • Reporting services
  • FCI clustering
  • AlwaysOn
  • Basic availability groups.
View full review »
AK
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees

I have found SQL Server easy to use.

View full review »
SF
CEO at netison

Microsoft has a very broad landscape of products that they provide—almost everything that you need. SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer. And even if you don't like Microsoft, you should know how to use it because just about every customer uses Microsoft, so you have to use it. So it doesn't matter if I like it. It's everywhere, so you have to know how to use it.

View full review »
it_user408555 - PeerSpot reviewer
Technical lead/Senior embedded software engineer at a wireless company with 51-200 employees

Database Engine

Integration Services

Reporting Services

View full review »
it_user4524 - PeerSpot reviewer
Founder & Principal Architect at a tech services company with 1,001-5,000 employees
- Ease of use of this product is much better than equivalent products - New AlwaysOn availability group enhancements bundles more DR and HA features in one easy to use interface - In-Memory OLTP, or project Hekaton, allows for utilizing memory to boost application performance with only minor application changes - Power, scalability, flexibility, and bundled tooling means it will meet all of your organizational DBMS needs for all size workloads - Support from MS and free knowledge and support from the MS community is terrific - Virtualization friendly! - Core features of the product include many features that require additional licenses with other platforms - SImple to setup and keep running View full review »
DK
Senior Systems Engineer at a energy/utilities company with 201-500 employees

It is easy to deploy and easy to maintain.

View full review »
SY
CTO at a tech services company with 11-50 employees

The solution is very common. It's easy to use.

The product offers a lot of support. Technical support has been great.

It's a reliable solution currently in this space.

The solution doesn't take a long time to set up. It's pretty straightforward. 

View full review »
PS
Project Manager at a comms service provider with 51-200 employees

In Poland, SQL Server is the most popular database engine, and overall, our customers like it.

View full review »
YA
Chief of Information Technology at a manufacturing company with 201-500 employees

We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use.

View full review »
RS
Business Analytics Manager at a transportation company with 201-500 employees

Their integration, SSRS and SSIS tools are really good. The flow is great.

The pricing of the solution is okay. It's less expensive than Oracle, for example.

View full review »
it_user525360 - PeerSpot reviewer
Enterprise Programmes Architect at a logistics company with 10,001+ employees

Traditional DB toolkit closely integrated into Microsoft Office. This makes it truly easy to deploy in a light non-business critical environment.

View full review »
it_user272976 - PeerSpot reviewer
Managing Director at a tech services company with 11-50 employees

Analysis Services, because we are an independent software vendor in the business-intelligence area.

View full review »
it_user718458 - PeerSpot reviewer
Corporate Data and BI Lead - Database Administrator at a logistics company with 10,001+ employees

Most of SQL Server High Availability and Disaster Recovery solutions. They are easy to configure and maintain.

View full review »
it_user284160 - PeerSpot reviewer
Freelance at a tech services company with 51-200 employees

The ability to browse table structures and re-design it easily.

View full review »
it_user5520 - PeerSpot reviewer
Network Manager at a manufacturing company with 501-1,000 employees
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. View full review »
AJ
Data Analyst

I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.

View full review »
EK
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees

I like that it's a cloud solution, is simple to set up, and is simple to use.

We are also totally satisfied with the stability and scalability of SQL Server.

View full review »
DS
Technical Director at a security firm with 51-200 employees

It is stable, and it works okay.

View full review »
EN
Head of Data Analytics at a tech services company with 11-50 employees

This solution is very easy to use, and it's very democratic in the enterprise. A lot of customers use this type of database, and that's why the deployments are very often in the medium enterprise.

View full review »
GV
Manager with 501-1,000 employees

It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner.

View full review »
YW
Information Security Engineer at a security firm with 11-50 employees

The most valuable feature is easy installation. It was very easy to install.

The interface is very user-friendly.

View full review »
VS
DWH Architect at B2BSoft

The columnstore index feature is useful for us, and we also use the integration services. It is also very stable.

View full review »
RS
Software Developer at OATI
  • SQL Server Profiler: Know exactly which procedures and functions are being called and how much read and write they are taking.
  • Tuning Advisor: It suggests where to add indexes and from where to remove them. It works like an adviser.
  • Storage capability
  • Debugger: The debugger tool can execute code step-by-step.
View full review »
DM
Chief of Engineering at a comms service provider with 11-50 employees
it_user117381 - PeerSpot reviewer
Lead Software Engineer at a tech services company with 11-50 employees

The AlwaysOn high-availability feature is the most valuable feature of SQL Server to us. This is because of the relative ease of the configuration, rather than configuring for OLTP-OLAP distinction.

View full review »
JI
System Analyst and Team Lead at a tech services company with 11-50 employees

Many developers like SQL Server.

View full review »
RP
IT Specialist at a government with 1,001-5,000 employees

I like that it's relatively stable.

View full review »
OY
Specialist Systems Engineer at a tech services company with 51-200 employees

I use the menu on the management view credit section to get information from the database.

View full review »
PF
Engineer / MS SQL DBA at Solvinity

The additional tools, like SSIS and reporting services, make this solution useful.

View full review »
it_user369171 - PeerSpot reviewer
Brazil IT Coordinator at a transportation company with 1,001-5,000 employees

The most valuable feature is the easy installation. The user just needs to know how to read.

View full review »
it_user308226 - PeerSpot reviewer
SAP NetWeaver Implementer at a tech services company

It allows for performance tuning to maximize performance. With the enhancements to the tuning wizard indexes are added to the needs of the system structure and use. I find this helps prevent locking of the system.

View full review »
FK
Managing Partner at Veribir Ltd

SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based.

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

The solution is easy to use.

View full review »
CM
Systems Engineer at a tech services company with 11-50 employees

Right now, we are using DB2 and the SQL Server. It's really helpful for the replication of data. It's real-time and very easy to use.

The product is very stable. We find it to be reliable.

The scalability is okay. 

The installation is pretty straightforward.

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

I have found that SQL Server works very well in the Microsoft Dynamics environment.

View full review »
it_user493200 - PeerSpot reviewer
Pre-Sales/System Architect at a tech services company with 5,001-10,000 employees

The Microsoft SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.

View full review »
AA
ASM at a healthcare company with 51-200 employees

SQL Server is definitely easy to use, and with the volume that we have, it's also stable.  Maintenance is much easier compared to other products. I may not be comfortable with Oracle because I don't have much experience with it. But in this case, SQL Server is much better for me. 

View full review »
RP
Project manager at a tech services company with 11-50 employees

Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better.

View full review »
it_user125703 - PeerSpot reviewer
Management Trainee for Training at a tech services company with 11-50 employees
  • Net integration is best for me
  • Better optimizer
  • Ease of use (admin tools)
View full review »
it_user359604 - PeerSpot reviewer
Web Content Editor at a consumer goods company with 501-1,000 employees

SQL Server Migration Assistant for Access (AccessToSQL).

View full review »
SK
Senior Architect at a computer software company with 10,001+ employees

It's more user-friendly than most databases. If we don't have to use the command mode, it's very easy.

View full review »
WL
Senior Programmer at a tech services company with 51-200 employees

I personally work with Microsoft products and therefore I like the continuity it provides. I like sticking with the brand.

The solution is very stable.

The product has very good online documentation that can be used for troubleshooting.

The solution can scale as necessary.

We've found the setup to be quick and relatively easy.

View full review »
GA
Member of the Board & Co-Founder, Executive Manager at Networld Systems

The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.

View full review »
it_user280197 - PeerSpot reviewer
BI Solution Architect at a tech services company with 501-1,000 employees

The database engine within SQL Server 2014 is one of the most valuable components of the platform to me.

The engine provides a solid and efficient database backend for any relational database requirement, performance is strong and there are options such as table, index partitioning and columnstore indexes that enhance the scalability of the platform.

In addition to the database engine, I would also highlight the built-in integration services platform (SSIS) for ETL purposes as well as the Reporting and Analysis Services functionality (SSRS and SSAS respectively).

One of the key features that I would use regularly to support the delivery of a Data Warehouse solution would be the Master Data Services (MDS). This is an extendable Master Data Management platform that works very well out-of-the- box.

View full review »
it_user118071 - PeerSpot reviewer
Engineer at a hospitality company with 1,001-5,000 employees

It's a solution that's always on.

View full review »
it_user165207 - PeerSpot reviewer
Infrastructure Analyst / Engineer (24x7) at a tech services company with 501-1,000 employees
  • Reliability
  • Ease of use
  • Extensive Knowledge Base to improve and maintain the product
View full review »
SP
Chief Information Officer at a tech consulting company with 51-200 employees

The main feature of this solution is ease of use.

View full review »
MG
CEO at a tech services company with 11-50 employees

It is integrated with Microsoft tools.

View full review »
SS
Software Engineer at a tech services company with 10,001+ employees

This product works well, serving as our operational database.

The interface is user friendly.

View full review »
it_user540858 - PeerSpot reviewer
IT Technician / Support Supervisor at a transportation company with 501-1,000 employees

Ability to convert to bigger DBs. It makes it easier to move or upgrade between branches.

View full review »
it_user585195 - PeerSpot reviewer
DBA de Desenvolvimento at a tech services company

The way the product shows the execution plan and the facility to the developer and tests the SQL code.

View full review »
it_user231318 - PeerSpot reviewer
Associate Consultant with 501-1,000 employees

There are lots of features including the analysis, database, and reporting, services. We use it mainly for reporting and analysis purposes.

The components I use are -

  • SSAS 8.5/10
  • SSIS 8/10
  • SSRS 7/10
View full review »
it_user135978 - PeerSpot reviewer
Developer at a retailer with 501-1,000 employees
Indexes, CTE, aggregate functions, partitions, memory optimized tables, service broker, CLR (C# assemblies),... View full review »
it_user285990 - PeerSpot reviewer
Service Operations Manager at a tech vendor with 51-200 employees
  • Reliability
  • Transaction management
  • Its higher limits for storage and table management
View full review »
it_user3876 - PeerSpot reviewer
Database Manager at a tech company with 51-200 employees
• 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. View full review »
CL
Data Analyst at a tech company with 51-200 employees

It's a flexible solution.

View full review »
it_user6414 - PeerSpot reviewer
CEO at a tech company with 51-200 employees
• 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. View full review »
it_user941640 - PeerSpot reviewer
Systems Analyst Developer with 1-10 employees

It is widely used and we never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient. It is something unique that tracks reporting of records, personnel, finances and more. It also integrates well with everything, not just Microsoft tools. 

View full review »
KH
Program Solution Architect at a tech services company with 11-50 employees

It is easy to use and easy to perform a backup.

It is easy to find resources that can manage SQL Server.

View full review »
it_user252576 - PeerSpot reviewer
Business Intelligence and Decision Support Team Leader at a university with 1,001-5,000 employees

It’s easy to develop and learn for newbies, and community MVP’s are so powerful and qualified, so info is easily accessible.

Also, SQL Server is not only a DBMS solution anymore, it is also a BI platform, and improvements are being made continuously.

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,995 professionals have used our research since 2012.