MS SQL server
Updated February 16, 2016
MS SQL server
Score 9 out of 10
Vetted Review
Verified User
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.
Using Microsoft SQL Server
50 - Sales
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
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
Not many changes
Microsoft SQL Server Implementation
- Implemented in-house
Yes - SSMS,SSIS,SSAS
- Server compatability issues
Microsoft SQL Server Training
- Online training
- In-person training
- Self-taught
Yes, easy to pick up
Configuring Microsoft SQL Server
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
| Pros | Cons |
|---|---|
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
| Pros | Cons |
|---|---|
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
Yes, but I don't use it
Microsoft SQL Server Reliability
Integrating Microsoft SQL Server
- MS Excel
- SharePoint
- Cognos
Its is easy to implement
- Hadoop
no
- File import/export
- API (e.g. SOAP or REST)
- Javascript widgets
- ETL tools
Cognos reporting tools
Check the compatability
Relationship with Microsoft
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.