What users are saying about

1010data

5 Ratings

Microsoft SQL Server

Top Rated
874 Ratings

1010data

5 Ratings
Score 4.7 out of 101

Microsoft SQL Server

Top Rated
874 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.

Microsoft SQL Server

If you have an organization with over 50 employees then you will benefit from Microsoft SQL. Anything less than that and you are going to need Microsoft SQL Express. The full licensing model gives you all features for that edition. Things like compressed backups, clustering, and anything to do with more than one server will require the heavier duty licensing. We use it for most everything except our websites. Our websites run on Python Django which does not work with Microsoft SQL Server. Other than the lack of support on that front we are 100% satisfied with it at the moment

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
  • Fast and efficient compression on backups. Typically we see about a 65% reduction in size compared to the data file.
  • It just "works". We say this very little in IT but it really does just work. Almost every enterprise application out there works with it and the downtime is very minimal.
  • You have the opportunity to cluster servers. You can easily create a cluster of SQL servers to share resources instead of buying all new equipment and scattering the database footprint.

Cons

  • The ten.do interface could use more detailed documentation
  • The patching has sometimes been an issue for us. It either doesn't work or the process isn't explained well for the different SQL instances on one engine.
  • I wish they would design a way to allow SQL backups to go somewhere other than a local drive. A UNC path would be best. This would allow us to rotate off the backups to a longer term storage device.
  • It takes up a huge amount of memory and space on a server.
  • There is no benefit to running it in VMWare. We typically find that servers run better in VMWare for our use cases but SQL seems to run just the same and you don't save on licensing so there really is no benefit.

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft SQL Server10.0
Based on 5 answers
We have entrusted our organization on the Microsoft SQL Server platform due to its robustness and solid architecture. We have had very little downtime throughout the years and have found the platform to improve greatly with each new version. It's tight integration with the Visual Studio environment makes development much easier. Administration and maintenance is easy as well, utilizing its out-of-the-box toolset for ensuring that the database platform is running smooth and performing well.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Microsoft SQL Server9.5
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
We've had problems with support bouncing the incident around between groups or engineers and having to repeat information that was already presented.

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
Make sure that all teams are fully represented in project meetings and planning. You'll need full involvement from networking, Windows, security, application teams, architects, and DBAs.

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
We've evaluated a number of database platforms, including Oracle, MySQL, Interbase/Firebird, and MongoDB. While there are similarities in each of the platforms, one key difference is the tools included to administer and develop against the platform. We found that Microsoft SQL Server, hands down, to be the easiest and more robust toolset and have entrusted our organization with this technology.

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.
  • low cost so that is affordable for all industries.
  • very flexible and easy to use
  • beautiful GUI and lots of features like security, debugging, intelligence

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