Overview of Microsoft Appliances
summary
Explains concrete options for a SQL Server data warehouse: follow the Fast Track reference architecture or buy an appliance. Lists Dell/HP appliances: a plug‑and‑play data warehouse appliance, a BI/SharePoint appliance with PowerPivot, a database‑consolidation appliance for virtualized SQL sprawl, and the scale‑out Parallel Data Warehouse (PDW) version 2 with xVelocity columnstore and quarter rack options. Gives numbers and results: PDW distributes 600 billion rows across nodes to return complex queries in seconds (100 TB demo <20s), plus deployment wizards, load tools, and MDM/data‑cleansing roles.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:25Data warehouse in enterprises
- 8:25Master data management benefits
- 12:35Hardware challenges
- 15:25Fast Track reference architecture
- 27:51Microsoft data warehouse appliances
- 34:39Database Consolidation Appliance
- 42:14Parallel Data Warehouse performance
- 57:12Scaling data warehouse solutions
- 1:01:07Summary and Q&A
related talks
37mIs There Really Such a Thing as Turnkey Data Analytics Solution?
12mModern Data Warehouse for Small and Medium Business
53mAzure Synapse Analytics: Evolving Azure SQL Data Warehouse
20mChoosing the Right Data Store--An Overview of Azure Data Platform Choices
46mMicrosoft Fabric Synapse data warehouse Q&A
47mData analytics for the era of AI
51mIntroduction to Azure Data Platform
51mA Deep Dive into Microsoft Fabric Data Warehouse