Microsoft PDW: Modern Data Warehouse with Big Data Analytics (aka APS)

Join Parallel Data Warehouse (PDW) Architect Brian Walker and SQL Server BI Expert Sanjay Soni to get the details on the Microsoft Analytics Platform System (APS)—the logical next step in the evolution of your data warehouse. APS is a turnkey big data analytics appliance combining a high-performance massively parallel processing (MPP) SQL Server data warehouse with Hadoop into a single solution which offers seamless integration for all of your data and which can improve your data loading and query response time as much as 100x beyond legacy solutions. It enables querying of structured and unstructured data with simplicity and speed, using standard SQL queries. The solution even tackles your Big Data and business intelligence needs.

Join the experts for this informative and demo-rich Jump Start, and learn to create the insights your business needs without massive and expensive system redesigns.

Course Outline:

  • SQL Server APS (PDW with Hadoop Insight Region) Intro
  • APS Use Cases
  • Hardware Architecture Overview
  • Software Overview
  • Data Distribution Theory
  • Data Loading
  • Column Store/Workload Management
  • PolyBase Overview
  • BI Integration Demo
  • Recap and Close
Instructor Team
Brian Walker | Microsoft Architect, PDW Center of Excellence

Brian Walker is an Architect on the MCS Parallel Data Warehouse Center of Excellence (PDW CoE) team. The PDW CoE team has a global charter to train and mentor Architects, Consultants, and Partners on the most effective solution architectures and data designs for the PDW environment. The PDW CoE team also has a global remit to facilitate PDW training, proof of concepts, and FastTrack for engagements and deployment that will lead to PDW solutions.

Brian has more than 15 years of experience in the enterprise data warehousing space for both the Oracle and Teradata environments within the telecommunications and financial services industries. These experiences have provided a range of capabilities that spans business analytics, management information reporting, IT compliance, and production environment management. Brian also has extensive consulting experience focused on the implementation of Massively Parallel Processing (MPP) enterprise data warehouse solutions leveraging the DATAllegro and Microsoft SQL Server 2008 R2 ​Parallel Data Warehouse appliances in the retail, manufacturing, and financial services industries.

Brian continues to explore new techniques to increase performance and manageability of the end-to-end processing of data in an enterprise data warehouse solution.

Sanjay Soni | Microsoft Senior Technical Product Manager, SQL Business Intelligence and Data Warehousing | @SQLBI101

Sanjay Soni is a Senior Technical Product Marketing Manager on the SQL Server Business Intelligence (BI) and Data Warehousing Marketing team at Microsoft. His previous Microsoft roles include Business Intelligence Evangelist, responsible for enabling self-service BI to more than 40,000 users at Microsoft. Sanjay is known for his passion and enthusiasm and for driving structure and delivering results for BI and data warehouse customers for 15 years.

Sanjay is a Microsoft Certified Database Administrator (MCDBA) and a Microsoft Certified Technology Specialist (MCTS), and he specializes in BI using Microsoft technologies, including Power BI, Analysis Services, Reporting Services, SharePoint BI, and parallel data warehousing. Sanjay has authored and presented a variety of papers and sessions at various conferences, including Tech-Ed, BI Conference, PASS, SQL Connections, SharePoint Conference, and TDWI. Many of his papers have been published in SQL Server magazine and on various websites, including and TechNet. In addition to his work internal to Microsoft, Sanjay presents regularly to customer organizations through Executive Briefings and Direct Engagements on the topics of delivering BI to the masses.

Live Event Details
April 29, 2014
9:00am-5:00pm PDT
What: Fast-paced live virtual session
Cost: Free
Audience: It Pro

Understanding of SQL Server and/or overall relational database concepts.