MS SQL server
Srikanth S | TrustRadius Reviewer
Updated February 16, 2016

MS SQL server

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft SQL Server

It is used across the whole organization to build analytical tools for the business users to best analyze the sales data.
  • Sql Server Integration services is a a great tool for ETL needs
  • SQL Server Analysis Services is a great tool to build data marts and data cubes.
  • SQL Server Reporting Services is a great reporting tool.
  • SQL server installation always takes long time, that can be definitely improved.
  • The Management Studio front end still needs work as does Indexing.
  • Few in SSIS Realtime data refresh in SSRS More datasources in Power BI
  • It is definitely one of the best tools available for all the database needs
  • It is easier to install and easy to get on with.
  • Consistent and reliable.
MS SQL server is the best database management tool available and it has been improving every year addressing the needs for ever growing data.
Volume of the data, it cannot store as much data as Oracle or Teradata does.

Using Microsoft SQL Server

15 - Tsql, Admininstration Skills,SSIS,SSRS,SSAS
  • DataWarehouse
  • Data Analytics
  • Data Reports
  • C# and VB.net coding and scheduling them
  • Web Service calls
  • DataBase transfer
  • Make use of cloud technology with SQl Server 2016
  • DataStorage space is increased a lot because of sql server 2016
It is a great product answering all Data needs.

Evaluating Microsoft SQL Server and Competitors

Yes - MS Access... MS Access wouldn't support huge volumes of data like Sql Server does.
  • Price
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
  • Vendor Reputation
Product Usability

Microsoft SQL Server Implementation

Check your hardware before installing SQL Server like hard disk space.
Yes - SSMS,SSIS,SSAS
  • Server compatability issues

Microsoft SQL Server Training

  • Online training
  • In-person training
  • Self-taught
very hands on and detailed training

Configuring Microsoft SQL Server

Its is very good
Hardware requirements have to be met, make sure RAM is available
No - there is no facility to customize the interface
Some - we have added small pieces of custom code - we can use VB.net code or C# code and its easy to implement.
Use add on tools like red gate

Microsoft SQL Server Support

I had prompt responses and forums to look into from time to time.
ProsCons
Good followup
Problems get solved
No escalation required
Support understands my problem
Not kept informed
Support doesn't seem to care
No - It is not my decision.
The issue was with MDS and MS support helped with excel plugins.

Using Microsoft SQL Server

Ease of use and over all functionality
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
Familiar
None
  • SQL Server Management studio is easy to understand
  • SQL server reports are easy to build
  • Running queries and retrieving data and moving it to excel is easy
  • Analysis services may be complex to start with
  • Integration Services to an extent
  • MDX queries

Microsoft SQL Server Reliability

SQL server does handle growing demands of a mid sized company.
Its does not have outages.
SSAS data cubes may some time slow down your Excel reports.

Integrating Microsoft SQL Server

It is easy to integrate
  • MS Excel
  • SharePoint
  • Cognos
Its is easy to implement
  • File import/export
  • API (e.g. SOAP or REST)
  • Javascript widgets
  • ETL tools
Cognos reporting tools
Check the compatability

Relationship with Microsoft

Easy to work with and knowledgeable
Support is available most of the times
Installation ,support
little bit of patience needed while dealing with support teams

Upgrading Microsoft SQL Server

Yes - Integration services may take a little longer
  • Query execution times
  • New functionality available
  • Data Storage space
  • Cloud technology
  • Improved Reporting services interface
  • New additions to analysis services
Yes - All the features are not available in free editions
Yes - Advanced features in enterprise editions.