PolyBase Revealed Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond

Harness the power of PolyBase data virtualization software to make data from a variety of sources easily accessible through SQL queries while using the T-SQL skills you already know and have mastered. PolyBase Revealed shows you how to use the PolyBase feature of SQL Server 2019 to integrate SQL Ser...

Descripción completa

Detalles Bibliográficos
Autor principal: Feasel, Kevin. author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2020.
Edición:1st ed. 2020.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631662606719
Tabla de Contenidos:
  • 1. Installing and Configuring PolyBase
  • 2. Connecting to Azure Blob Storage
  • 3. Connecting to Hadoop
  • 4. Using Predicate Pushdown to Enhance Query Performance
  • 5. Common Hadoop and Blob Storage Integration Errors
  • 6. Integrating with SQL Server
  • 7. Built-In Integrations: Cosmos DB, Oracle, and More
  • 8. Integrating via ODBC
  • 9. PolyBase in Azure SQL Data Warehouse
  • 10. Examining PolyBase via Dynamic Management Views
  • 11. Query Tuning with Statistics and Execution Plans
  • 12. PolyBase in Practice.