MS SQL Parallel Data Warehouse

(6)
4.5 out of 5 stars

Parallel Data Warehouse offers scalability to hundreds of terabytes and high performance through a massively parallel processing architecture.

Work for MS SQL Parallel Data Warehouse?
Panoply vs 3  2x

Learning about Microsoft?

We can help you find the solution that fits you best.

Find the Right Product

MS SQL Parallel Data Warehouse Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 6 Microsoft reviews
LinkedIn Connections
Microsoft review by <span>Mohamed B.</span>
Mohamed B.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

MS SQL Parallel Data

What do you like best?

The parallel data warehouse is a massive storage appliance with exceptional speed.

The platform is all Microsoft and integrates well with all other Microsoft products and infrastructure.

Microsoft's support of the product has been outstanding.

What do you dislike?

Report Builder allows for quite a bit of customization but we found it be missing some the features that make other application like Crystal Reports so easy to use. Simple features such as moving columns within a table can be a bit frustrating. Formatting text and writing formulas (expressions) is easier in Crystal Reports.

Recommendations to others considering the product

If you want a 10-40x faster due to parallel loading of data. Data loading speed is 250Gb/hr per compute node (a half rack of 4 compute nodes gives 1 TB/hour, with minimal query performance impact) then this is the right program for you

What business problems are you solving with the product? What benefits have you realized?

We use it for analyze large data

Sign in to G2 Crowd to see what your connections have to say about MS SQL Parallel Data Warehouse
Headshots
Microsoft review by <span>Tony W.</span>
Tony W.
Validated Reviewer
Invitation from G2 Crowd
Reviewed On

Good big data alternative to something like Hadoop, except for .NET platforms

What do you like best?

I like the fact that the documentation system is well supported and managed, and it is easy to onboard an entire dev team on managing big data infrastructure.

What do you dislike?

I dislike that sometimes the desktop application on the PC platform is a bit sluggish to load, especially when managing large datasets such as ones with over 1 million rows of data.

Recommendations to others considering the product

This is recommended for web app as well as desktop app developers who want a solid product for managing their big data needs and analytics. However, a drawback is that the software may sometimes be sluggish in retrieving datasets.

What business problems are you solving with the product? What benefits have you realized?

I am building a photo sharing website and currently developing a mobile app for photo sharing as well. Am experimenting with Parallel desktop for big data purposes in case users upload a large number of photos and provide a lot of detail.

What Data Warehouse solution do you use?

Thanks for letting us know!
Microsoft review by <span>James P.</span>
James P.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Integral piece of our team

What do you like best?

Quick, easy, ready for whatever we need in our team.

What do you dislike?

UI and work flow could use a refresh but does not impact functionality.

What business problems are you solving with the product? What benefits have you realized?

All SQL data for our work flow.

Microsoft review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

best for scalability and query performance

What do you like best?

It provides scalability and good query performance by running independent servers in parallel.

What do you dislike?

Not much to dislike but does not support all faetures of sql server

Recommendations to others considering the product

NA

What business problems are you solving with the product? What benefits have you realized?

We are handling mid size company data so its the best tool for us to handle low volume data.

Microsoft review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Organic
Reviewed On

Efficient query mechanism

What do you like best?

1. Easy to setup

2. No need to buy commodity hardware and software and configuring them in house.

3. Easy to scale out

What do you dislike?

Report building can cause little frustration.

What business problems are you solving with the product? What benefits have you realized?

Microsoft SQL Server Parallel Data Warehouse provides significant performance boost from 10-100 X times faster for data loading operation.It minimized the cost of design with lower infrastructure requirements.

Microsoft review by <span>Peter B.</span>
Peter B.
Validated Reviewer
Organic
Reviewed On

Easy to Use .. Worth the Money

What do you like best?

SQL Server DBMS is a great tool to manage your databases. It's real easy to use, much easier than Oracle in my mind. It's also a lot less expensive than Oracle. Notification process works well.

What do you dislike?

Not much to dislike, except if you have volumes, and volumes of data .. then it's just not as robust.

Recommendations to others considering the product

If you are a mid-size company without volumes of data, then this is the tool for you. It's real easy to set up and configure and the maintenance of your servers will be seamless.

Kate avatar
Kate from G2 Crowd

Learning about MS SQL Parallel Data Warehouse?

I can help.
* We monitor all MS SQL Parallel Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.