PolyBase Revealed (eBook)
XIX, 311 Seiten
Apress (Verlag)
978-1-4842-5461-5 (ISBN)
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 Server with Azure Blob Storage, Apache Hadoop, other SQL Server instances, Oracle, Cosmos DB, Apache Spark, and more. You will learn how PolyBase can help you reduce storage and other costs by avoiding the need for ETL processes that duplicate data in order to make it accessible from one source. PolyBase makes SQL Server into that one source, and T-SQL is your golden ticket. The book also covers PolyBase scale-out clusters, allowing you to distribute PolyBase queries among several SQL Server instances, thus improving performance.
With great flexibility comes great complexity, and this book shows you where to look when queries fail, complete with coverage of internals, troubleshooting techniques, and where to find more information on obscure cross-platform errors. Data virtualization is a key target for Microsoft with SQL Server 2019. This book will help you keep your skills current, remain relevant, and build new business and career opportunities around Microsoft's product direction.
- Install and configure PolyBase as a stand-alone service, or unlock its capabilities with a scale-out cluster
- Understand how PolyBase interacts with outside data sources while presenting their data as regular SQL Server tables
- Write queries combining data from SQL Server, Apache Hadoop, Oracle, Cosmos DB, Apache Spark, and more
- Troubleshoot PolyBase queries using SQL Server Dynamic Management Views
- Tune PolyBase queries using statistics and execution plans
- Solve common business problems, including 'cold storage' of infrequently accessed data and simplifying ETL jobs
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage where he specializes in T-SQL and R development, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead curator at Curated SQL (curatedsql.com). A resident of Durham, North Carolina, USA, Kevin can be found cycling the trails along the Triangle whenever the weather is nice enough.
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 Server with Azure Blob Storage, Apache Hadoop, other SQL Server instances, Oracle, Cosmos DB, Apache Spark, and more. You will learn how PolyBase can help you reduce storage and other costs by avoiding the need for ETL processes that duplicate data in order to make it accessible from one source. PolyBase makes SQL Server into that one source, and T-SQL is your golden ticket. The book also covers PolyBase scale-out clusters, allowing you to distribute PolyBase queries among several SQL Server instances, thus improving performance.With great flexibility comes great complexity, and this book shows you where to look when queries fail, complete with coverageof internals, troubleshooting techniques, and where to find more information on obscure cross-platform errors. Data virtualization is a key target for Microsoft with SQL Server 2019. This book will help you keep your skills current, remain relevant, and build new business and career opportunities around Microsoft s product direction.What You Will LearnInstall and configure PolyBase as a stand-alone service, or unlock its capabilities with a scale-out clusterUnderstand how PolyBase interacts with outside data sources while presenting their data as regular SQL Server tablesWrite queries combining data from SQL Server, Apache Hadoop, Oracle, Cosmos DB, Apache Spark, and moreTroubleshoot PolyBase queries using SQL Server Dynamic Management ViewsTune PolyBase queries using statistics and execution plansSolve common business problems, including "e;cold storage"e; of infrequentlyaccessed data and simplifying ETL jobsWho This Book Is ForSQL Server developers working in multi-platform environments who want one easy way of communicating with, and collecting data from, all of these sources
Erscheint lt. Verlag | 20.12.2019 |
---|---|
Zusatzinfo | XIX, 311 p. 192 illus. |
Sprache | englisch |
Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
Mathematik / Informatik ► Informatik ► Software Entwicklung | |
Schlagworte | Apache Spark • Azure Blob Storage • Azure SQL Data Warehouse • Big Data • CosmosDB • Data Virtualization • Dynamic Management Views • External File Formats • External Pushdown • External Tables • Hadoop • Massively Parallel Processing (MPP) • MongoDB • Oracle • PolyBase • Polyglot Data • Predicate Pushdown • SQL Server 2019 • Teradata • T-SQL |
ISBN-10 | 1-4842-5461-9 / 1484254619 |
ISBN-13 | 978-1-4842-5461-5 / 9781484254615 |
Haben Sie eine Frage zum Produkt? |
![PDF](/img/icon_pdf_big.jpg)
Größe: 12,4 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich