PolyBase RevealedPolyBase Revealed

PolyBase Revealed
Author : Kevin Feasel
Publisher : Apress
Total Pages : 320
Release : 2019-12-20
ISBN 10 : 9781484254615
ISBN 13 : 1484254619
Language : EN, FR, DE, ES & NL


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. What You Will LearnInstall 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 Who This Book Is For SQL Server developers working in multi-platform environments who want one easy way of communicating with, and collecting data from, all of these sources

More Books:

PolyBase Revealed
Language: en
Pages: 320
Authors: Kevin Feasel
Categories: Computers
Type: BOOK - Published: 2019-12-20 - Publisher: Apress

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 sk
SQL Server 2019 Revealed
Language: en
Pages: 435
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2019-10-18 - Publisher: Apress

Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine
Azure Internet of Things Revealed
Language: en
Pages: 214
Authors: Robert Stackowiak
Categories: Computers
Type: BOOK - Published: 2019-11-09 - Publisher: Apress

Design, build, and justify an optimal Microsoft IoT footprint to meet your project needs. This book describes common Internet of Things components and architect
Smart Trajectories
Language: en
Pages: 402
Authors: Azedine Boulmakoul
Categories: Computers
Type: BOOK - Published: 2022-12-30 - Publisher: CRC Press

This book highlights the developments, discoveries, and practical and advanced experiences related to responsive distributed computing and how it can support th
Biophysics and Other Topics
Language: en
Pages: 608
Authors: Aharon Katzir-Katchalsky
Categories: Science
Type: BOOK - Published: 2013-10-22 - Publisher: Academic Press

Biophysics and Other Topics: Selected Papers by Aharon Katzir-Katchalsky covers papers on polyelectrolytes, mechanochemistry, irreversible thermodynamics, membr
SQL Server 2019 Revealed
Language: en
Pages: 422
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2019-10-19 - Publisher: Apress

Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine
Handbook of Pressure-Sensitive Adhesives and Products
Language: en
Pages: 1100
Authors: Istvan Benedek
Categories: Technology & Engineering
Type: BOOK - Published: 2019-07-05 - Publisher: CRC Press

Divided into three sections that are also available as individual volumes, this is the first reference to offer a complete guide to the fundamentals, manufactur
Scientific Programme and Abstracts of Papers
Language: en
Pages: 168
Authors:
Categories: Macromolecules
Type: BOOK - Published: 1956 - Publisher:

Laboratory Methodology in Biochemistry
Language: en
Pages: 276
Authors: Carlo Fini
Categories: Medical
Type: BOOK - Published: 2019-08-08 - Publisher: CRC Press

Provides information on methodologies and techniques concerning the biochemical laboratory, as well as improvements or advancements made on existing methodologi
The Proteins Composition, Structure, and Function
Language: en
Pages: 856
Authors: Hans Neurath
Categories: Science
Type: BOOK - Published: 2012-12-02 - Publisher: Elsevier

The Proteins: Composition, Structure, and Function, Second Edition, Volume II deals with fundamental properties of proteins, both in solution and in the solid s