Category Archives: PDW/APS

Analytics Platform System 2016 Release

Microsoft has a new release for the Analytics Platform System (APS).  This appliance update is called APS 2016 and has been released to manufacturing and is now generally available.  APS is Microsoft’s scale-out Massively Parallel Processing fully integrated system for … Continue reading

Posted in PDW/APS, SQLServerPedia Syndication | 4 Comments

Data Warehouse Fast Track for SQL Server 2016

Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to deliver validated, pre-configured solutions that reduce the complexity of implementing a data warehouse on SQL Server Enterprise Edition.  The Data … Continue reading

Posted in Appliance, Data warehouse, Fast Track, PDW/APS, SQL Server, SQLServerPedia Syndication | 5 Comments

Analytics Platform System (APS) AU5 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU5), which is sort of like a service pack, except that it includes many new features.  Below is what is new in this … Continue reading

Posted in PDW/APS, SQLServerPedia Syndication | Comments Off on Analytics Platform System (APS) AU5 released

Analytics Platform System (APS) AU4 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU4), which is sort of like a service pack, except that it includes many new features.  Below is what is new in this … Continue reading

Posted in PDW/APS, SQLServerPedia Syndication | Comments Off on Analytics Platform System (APS) AU4 released

How an MPP appliance solution can improve your future

Massive parallel processing (MPP) is the future for data warehousing. So what is MPP?  SQL Server is a Symmetric Multiprocessing (SMP) solution, which essentially means it uses one server.  MPP provides scalability and query performance by running independent servers in parallel.  That … Continue reading

Posted in Big Data, PDW/APS, SQLServerPedia Syndication | 4 Comments

Azure SQL Data Warehouse

Analytics Platform System (APS) is Microsoft’s massively parallel processing (MPP) data warehouse technology.  This has only been available as an on-prem solution (see video Overview of Microsoft Analytics Platform System).  Until now.  At the recent Microsoft Build Developer Conference, Executive Vice … Continue reading

Posted in Azure SQL DW, Data warehouse, PDW/APS, PolyBase, SQLServerPedia Syndication | 14 Comments

Using Power BI to access on-premise data

The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on a Power BI Site that will reference data on-premises.  To do this you will use certain on-premise Power BI products … Continue reading

Posted in PDW/APS, Power BI, SQLServerPedia Syndication | 5 Comments

Analytics Platform System (APS) AU3 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU3), which is sort of like a service pack, except that it includes many new features.  These appliance updates are made available frequently, … Continue reading

Posted in PDW/APS, SQLServerPedia Syndication | Comments Off on Analytics Platform System (APS) AU3 released

The Modern Data Warehouse

The traditional data warehouse has served us well for many years, but new trends are causing it to break in four different ways: data growth, fast query expectations from users, non-relational/unstructured data, and cloud-born data.  How can you prevent this … Continue reading

Posted in Big Data, Data Lake, Data warehouse, Hadoop, PDW/APS, SQLServerPedia Syndication | 8 Comments

Analytics Platform System (APS) AU2 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has recently released an appliance update (AU2), which is sort of like a service pack, except that it includes many new features.  These appliance updates are made available frequently, … Continue reading

Posted in PDW/APS, SQLServerPedia Syndication | 1 Comment