What users are saying about

1010data

5 Ratings

1010data

5 Ratings
Score 5.2 out of 101

Microsoft SQL Server

854 Ratings
Score 8.5 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.

Microsoft SQL Server

SQL Server is better equipped for larger companies due to licensing and maintenance cost. Smaller companies or individuals are probably better suited to use MySQL since it's free. However, the support Microsoft gives for SQL server has to be weighed, it's one of the reasons we are willing to pay the extra costs.

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
  • 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.

Cons

  • The ten.do interface could use more detailed documentation
  • 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.

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft SQL Server10.0
Based on 5 answers
We're constantly rolling out new applications on this platform.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Microsoft SQL Server9.4
Based on 8 answers
Microsoft SQL Server is a sold and robust platform. We find it easy to administer, develop, deploy, and manage solutions on this platform. We have used this technology for over 20 years and have entrusted our organization to run on this platform on a worldwide scale. It has been one of the best business decisions we've made.

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.

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.

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.

In-Person Training

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

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

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.

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
SQL has better admin tools than other similar products and is cost effective in comparison to other products. As a Microsoft tech company, it made logical sense for us to select SQL Server.

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.

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.
  • Microsoft SQL server is priced less as compared to other enterprise database choices. This makes the initial investment more cost effective and in turn reflects better ROI.
  • Microsoft is easy to use and administer. Resources are readily available to support SQL Server. Microsoft SQL Server Management Studio makes life simpler when it comes to basic database administration tasks. As resource cost to maintain SQL Server is much less, it helps in gaining more positive ROI.
  • ROI can easily turn into negative side if solution evolves into a complex enterprise one, requiring better performance and bigger size of data. SQL Server cannot handle enterprise data as well as Oracle. Detailed architectural planning is needed before choosing SQL Server for an enterprise solution as the cost to move from SQL later could be more.

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