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

PolyBase Revealed: Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond, 9781484254608 (1484254600), Apress, 2019

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 Learn

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

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

Comments

Amazing Books

Digital Control in Power Electronics (Synthesis Lectures on Power Electronics)

Morgan and Claypool Publishers, 2006

This book presents the reader, whether an electrical engineering student in power electronics or a design engineer, some typical power converter control problems and their basic digital solutions, based on the most widespread digital control techniques. The presentation is focused on different applications of the same power converter...

iPhone Forensics: Recovering Evidence, Personal Data, and Corporate Assets

O'Reilly, 2008

"This book is a must for anyone attempting to examine the iPhone. The level of forensic detail is excellent. If only all guides to forensics were written with this clarity!" -Andrew Sheldon, Director of Evidence Talks, computer forensics experts With iPhone use increasing in business networks, IT and security professionals face a serious...

ASIC and FPGA Verification : A Guide to Component Modeling (The Morgan Kaufmann Series in Systems on Silicon)

Morgan Kaufmann, 2004

Today it is still very difficult to verify board or larger system designs through simulation or any other technique. This important book addresses the largest ingredient needed to make simulation possiblethe availability of integrated circuit component models. Addressed inside is how to use VITAL extensions and other conventions with VHDL to...

Managing and Mining Multimedia Databases

CRC Press, 2001

Reading Data Mining by Bhavani Thuraisingham is a poignant experience masterful and readable summary of her field...a profound overview of an important domain of human knowledge a memorable opus.
-Dr. Dobb's Journal

There is now so much data on the Web that managing it with conventional tools is becoming almost...

Excel 2013 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

John Wiley & Sons, 2013

Maximize your Excel 2013 experience using VBA application development

The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to...

An Introduction to Programming with IDL: Interactive Data Language

Academic Press, 2005

Students in undergraduate science and engineering programs typically take one semester of computer programming, often using Fortran or C or, more recently, Java or C++. Although these languages are all used to write scientific software, in one or two semesters it is difficult for students to develop the skills needed to write useful programs....