Definition

Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)

Mark Fontecchio

By

Mark Fontecchio

Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW) is a pre-built data warehouse appliance that includes Microsoft SQL Server database software, third-party server hardware and networking components.

Parallel Data Warehouse has a massively parallel processing (MPP) architecture. As such, Microsoft has billed Parallel Data Warehouse as being well-tuned for big data processing.

Like other server appliances, one of the main features of Parallel Data Warehouse is that it is easier to set up when compared to buying commodity hardware and software and configuring them in house. There are currently two versions of Parallel Data Warehouse: one uses Hewlett-Packard servers and the other uses Dell hardware.

See also: data center in a box

This was last updated in August 2013

Continue Reading About Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)

New to SQL Server PDW? First, tinker with client tools

Parallel Data Warehouse has speed, space, special requirements

Dig Deeper on Database management

Business Analytics

Data pipelines deliver the fuel for data science, analytics
While analytics and data science lead to informed decision-making, the systems that ingest data from its source and prepare it ...
Google unveils new Looker tool, BigQuery pricing models
The tech giant revealed a standalone tool that opens up its analytics platform's semantic layer to users of any BI vendor and ...
Real-time analytics presents challenges to unlock benefits
Real-time analytics enables organizations with faster decision-making. However, bad data, or a culture that isn't ready for ...

SearchAWS

AWS Control Tower aims to simplify multi-account management
Many organizations struggle to manage their vast collection of AWS accounts, but Control Tower can help. The service automates ...
Break down the Amazon EKS pricing model
There are several important variables within the Amazon EKS pricing model. Dig into the numbers to ensure you deploy the service ...
Compare EKS vs. self-managed Kubernetes on AWS
AWS users face a choice when deploying Kubernetes: run it themselves on EC2 or let Amazon do the heavy lifting with EKS. See ...

Content Management

Why version control is necessary in digital asset management
Creative teams often use different versions of their digital assets across marketing channels. Learn how version control in DAM ...
Compare SharePoint Syntex disadvantages and benefits
Microsoft promotes its SharePoint content AI services -- Syntex -- as a way to streamline content management in a cost-effective ...
6 SharePoint Syntex use cases
File discovery is one of the most popular use cases for SharePoint Syntex. But how else can you use it? Here, see how real-world ...

SearchOracle

Oracle sets lofty national EHR goal with Cerner acquisition
With its Cerner acquisition, Oracle sets its sights on creating a national, anonymized patient database -- a road filled with ...
With Cerner, Oracle Cloud Infrastructure gets a boost
Oracle plans to acquire Cerner in a deal valued at about $30B. The second-largest EHR vendor in the U.S. could inject new life ...
Supreme Court sides with Google in Oracle API copyright suit
The Supreme Court ruled 6-2 that Java APIs used in Android phones are not subject to American copyright law, ending a ...

SearchSAP

SAP looks to grow S/4HANA Cloud presence in midmarket
Grow with SAP is a new program targeted at driving SAP S/4HANA Cloud sales in the midmarket, but can it address the perception ...
SAP agrees to sell Qualtrics stake for $7.7B
SAP's sale of Qualtrics reaches its final stage as it sells shares for $7.7 billion. The deal recoups the initial investment but ...
SAP Datasphere looks to build a business data fabric
A new service on SAP Business Technology Platform is aimed at helping companies get value from SAP and non-SAP data by keeping ...

Close