

Microsoft Parallel Data Warehouse and Dell PowerStore compete in the data storage and management category. Dell PowerStore appears to have the upper hand due to its stronger integration with VMware, machine learning functionalities, and robust NVMe support, setting it apart in terms of performance and scalability.
Features: Microsoft Parallel Data Warehouse enhances data loading times significantly, integrates seamlessly with the Microsoft ecosystem including Power BI, and boasts strong OLAP capabilities. Dell PowerStore provides exceptional integration with VMware, supports NVMe for high performance, and excels in deduplication and compression, enhancing storage efficiency.
Room for Improvement: Microsoft Parallel Data Warehouse could benefit from better integration with non-Microsoft tools, improved scalability, and less setup complexity. Dell PowerStore needs more stable upgrades, enhanced NAS functionalities, and better price flexibility alongside improved support and security features in relation to the S3 protocol.
Ease of Deployment and Customer Service: Microsoft Parallel Data Warehouse offers flexible deployments with options for on-premises, public, and hybrid cloud setups, while Dell PowerStore is primarily focused on on-premises with excellent VMware integration. Customer service for both is generally satisfactory but users of Microsoft Parallel Data Warehouse often rely more on online resources compared to Dell PowerStore's traditional support approach.
Pricing and ROI: Microsoft Parallel Data Warehouse is noted for its cost-effectiveness, especially for large data sizes, with an all-inclusive licensing model that avoids hidden costs. Dell PowerStore, although positioned as more expensive, offers competitive pricing given its NVMe and deduplication capabilities, and is recognized for delivering significant ROI through effective data management and integration with existing tools.
If you purchase storage with 300 terabytes, you can easily achieve one petabyte of effective capacity.
It's been trouble-free the entire time, with very high performance, as it has been designed and built properly.
We have seen a return on our investment in Dell PowerStore; definitely our cost per terabyte has been very good compared to some of the other vendors that we would have been using previously, and our performance benchmarks have exceeded what we were expecting.
I would rate the technical support of Dell PowerStore between nine and ten out of ten.
They're responsive, knowledgeable, and have a quick turnaround.
On a scale of one to ten, I would rate Dell support as a ten, focusing on that aspect alone, because it's what allows me to sleep at night.
They are responsive and get back to us.
I would rate my experience with technical support around six on a scale of 1 to 10 because I have not had a particular experience with technical support.
The solution's scalability is a ten out of ten.
It scales up and scales out both ways, and as our data keeps growing, it is very easy to just keep attaching and keep growing.
Scaling up can be done from a single enclosure that already has two controllers to a maximum of four storage units with up to eight controllers, and a massive amount of storage can be added.
We go from a couple of users to tons of users all the time, and it scales and handles things really well.
I give the scalability an eight out of ten, indicating it scales well for our needs.
As a consultant, we hire additional programmers when we need to scale up certain major projects.
When I removed all the cables, it failed over within five minutes.
It's quite stable and reliable in general.
I have not experienced any downtime, bugs, or glitches, and it's much better than previous technologies.
Microsoft Parallel Data Warehouse is stable for us because it is built on SQL Server.
Something needs to be done with the caching to ensure that if some issue occurs, there needs to be an ability to disable caching during maintenance to make it static, safe, and good.
Pricing must also be considered, as Dell PowerStore is quite expensive compared to competitors in the market like HPE Alletra, Huawei Dorado, or Hitachi storage, for example.
The main reason why people move to Pure Storage is because it's simplified.
It would be better to release patches less frequently, maybe once a month or once every two months.
Addressing the cost would be the number one area for improvement.
When there are many users or many expensive queries, it can be very slow.
Likely the cost is $400,000 whereas IBM may be $250,000.
Based on my experience, the cost of Dell PowerStore for around 500 GB of capacity is very competitive compared to any other platform in the market.
I asked for a new quotation on a server, and it is quite expensive; it is really expensive.
Microsoft Parallel Data Warehouse is very expensive.
This includes storage sharing, adding servers to the service, and the wireless host connection on the network side.
Dell PowerStore offers good integration capabilities, especially since it helps with backup, which is an important aspect.
In terms of whether my company could reduce the power consumption with Dell PowerStore, I would say that my company had a use case with a customer around three weeks ago where their old Dell EMC VNX Storage System used to draw about 2500 watts compared to Dell PowerStore which drew about 800 watts, which is a really a big saving looking at the twenty-four hours and seven days of usage of the system.
The columnstore index enhances data query performance by using less space and achieving faster performance than general indexing.
Microsoft Parallel Data Warehouse is used in the logistics area for optimizing SQL queries related to the loading and unloading of trucks.
There's a feature that allows users to set alerts on triggers within reports, enabling timely actions on pending applications and effectively reducing waiting time.
| Product | Market Share (%) |
|---|---|
| Dell PowerStore | 1.4% |
| Microsoft Parallel Data Warehouse | 1.7% |
| Other | 96.9% |

| Company Size | Count |
|---|---|
| Small Business | 54 |
| Midsize Enterprise | 34 |
| Large Enterprise | 81 |
| Company Size | Count |
|---|---|
| Small Business | 16 |
| Midsize Enterprise | 6 |
| Large Enterprise | 22 |
Dell PowerStore is a scalable, high-performance platform supporting both modern and traditional workloads, enhancing IT operations with AI-driven automation and advanced data reduction features.
Designed for flexibility, Dell PowerStore integrates seamlessly with VMware, providing robust security and high IOPS. Users benefit from fast NVMe storage, intelligent data management, and scalable performance to handle diverse workload demands. However, improvements are needed in replication, enterprise functionalities, and UI complexity. Stability and support issues highlight the need for enhanced monitoring and pricing strategies.
What are the key features of Dell PowerStore?
What benefits does Dell PowerStore offer?
In industries like finance, healthcare, and IT, Dell PowerStore is critical for VMware virtualization, high-performance databases, and backup storage. It supports hosting virtual machines, mirroring storage, and handling SAP and Oracle databases effectively. Its role in hybrid and on-premises setups showcases its adaptability and integration capabilities for mission-critical tasks.
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.