What users are saying about

1010data

5 Ratings

Microsoft SQL Server

Top Rated
912 Ratings

1010data

5 Ratings
Score 4.3 out of 101

Microsoft SQL Server

Top Rated
912 Ratings
Score 8.6 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
Marc Gilbert profile photo

Microsoft SQL Server

We use SQL Server to deliver large amounts of data to our clients. As some have moved away from stored procedures and views in favor of technologies that are faster to develop, such as LINQ with Entity Framework, we've noticed that data load time performance has degraded. To fix this, we've taken slow applications and moved querying logic into stored procedures and views to maximize performance.
No photo available

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
Marc Gilbert profile photo
  • It's a great database backend system. It will allow you to store a wide variety of databases and datatypes.
  • It's easy to create and execute, stored procedures to automate tasks.
  • It allows for us to set up a vast array of permission sets, so people who need to access it only can access the features they need.
No photo available

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • One of the weaknesses of SQL Server is the lack of tooling in places. That sounds strange as Microsoft has been known for easy to use GUI tools, but a number of features in the last 4-5 versions of SQL Server (Service Broken, replication, Extended Events, and more) haven't received much help in the tooling areas.
  • Scalability. While SQL Server scales up nicely, and new hardware platforms have dramatically increased the power of a single instance, there are still issues with larger scale applications built on SQL Server that might require more than one instance. Or that could benefit from additional hardware machines of the same size. SQL Server hasn't scaled out well across machines.
  • Licensing. While SQL Server is reasonably priced (to me), it is still expensive as cores grow and there are limits to the small scales of some applications. The complexity of licensing also means that it becomes complex to manage this across time, as well as more expensive than I would like.
  • Tuning. While there are a wealth of ways to tune systems, it feels more complex inside of SQL Server at times than it needs to be, especially for less experienced users. The platform should do more to help users understand where issues occur and give them guidance. I think the SQL Server 2016 Query Store will help here.
  • Maturity of some features. I think that some of the features have been a bit neglected, apart from tooling, in the last few versions. It seems like Spatial data, the Availability Groups, Service Broker, and more haven't gotten enough work to mature them to be more useful and helpful features.
Steve Jones profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft SQL Server10.0
Based on 5 answers
I think it is unlikely that sql server has disappointed someone, it is likely that someone will come initially discouraged if the needs and problems that occur are very challenging, but definitely have a SQL oriented system means having a solid base to work and on which maintain the their data securely
Luca Campanelli profile photo

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
Microsoft SQL Server9.5
Based on 8 answers
Once you have gained adequate experience to manage autonomously SQL Server sql server usability it is excellent, the fact remains that the SQL Server platform has a variety of very wide use, are so many variables to consider in a sql oriented system. Usability (mean maintainability) becomes more complicated if it is larger the amount of data to manage (with large I mean some TBs for each databases)
Luca Campanelli profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft SQL Server10.0
Based on 1 answer
Its does not have outages.
Srikanth S profile photo

Performance

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.0
Based on 1 answer
SSAS data cubes may some time slow down your Excel reports.
Srikanth S profile photo

Support

No score
No answers yet
No answers on this topic
Microsoft SQL Server8.2
Based on 5 answers
Nothing is perfect but Microsoft does fairly well even though they're such a large corporation. SQL server has a large user base and there are a lot of support tools you can find without even calling Microsoft. The internet has a plethora of knowledge and help and Microsoft has also done a great job of making articles on their MSDN website that explain and layout a lot of different things with SQL. With that comes the fact that you still have to go to the internet or on the phone to get help sometimes.
Bill Starling profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.0
Based on 1 answer
It was good
Srikanth S profile photo

Online Training

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.0
Based on 1 answer
very hands on and detailed training
Srikanth S profile photo

Implementation

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.7
Based on 4 answers
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
Bill Starling profile photo

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
Microsoft SQL Server is what my company purchased and available for us to use. Everyone in my department uses Microsoft SQL Server. I think mainly it's because of its affordability. Also, its functionalities are enough for our day to day operations since the size of data we analyze are usually not too large.
Darren Deng profile photo

Scalability

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.0
Based on 1 answer
SQL server does handle growing demands of a mid sized company.
Srikanth S profile photo

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
Marc Gilbert profile photo
  • As a data analytics company, all the revenue my company generates is based on the data that we consume through sql server
  • SQL Server has limed our ability work with only certain kind of datasets
Ashish Gupta profile photo

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Microsoft SQL Server

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details