SQL Server Valuable Features

it_user79482
Senior Developer at Crimsonwing
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 »
Aju Mathai
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 »
it_user272976
Managing Director at ResEvo d.o.o.
Analysis Services, because we are an independent software vendor in the business-intelligence area. View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: February 2020.
398,890 professionals have used our research since 2012.
Lei Liu
DBA,data architectuire at a tech services company
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 »
Royden Akerley
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 »
Rahul Kumar Singh
Software Developer at a tech vendor with 501-1,000 employees
* 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 »
Daniel Du Toit
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 »
it_user540858
IT Technician / Support Supervisor at GHASSAN ABOUD GROUP
Ability to convert to bigger DBs. It makes it easier to move or upgrade between branches. View full review »
reviewer1030020
Programmer Analyst at Cognizant Technology Solutions
* Creating and executing SQL queries, transactions, ACID properties * Creating and implementing stored procedures. View full review »
Pierre Marçon
User 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 »
Paul Fijma
Engineer / MS SQL DBA with 201-500 employees
The additional tools, like SSIS and reporting services, make this solution useful. View full review »
GhamdanAl-Anesi
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 »
Menoj-Roekalea
Cloud DBA at UNIT4
* SSMS * SSIS * Reporting services * FCI clustering * AlwaysOn * Basic availability groups. View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: February 2020.
398,890 professionals have used our research since 2012.