Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
PolyBase Revealed: Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond

Buy

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
(HTML tags aren't allowed.)

Selected Readings on Electronic Commerce Technologies: Contemporary Applications (Premier Reference Source)
Selected Readings on Electronic Commerce Technologies: Contemporary Applications (Premier Reference Source)

Education and research in the field of electronic commerce technology can prove problematic without the proper resources and tools on the most relevant issues, trends, and advancements.

Selected Readings on Electronic Commerce Technologies: Contemporary Applications supplements course instruction and student research with...

The Human Nervous System, Second Edition (Vol 1)
The Human Nervous System, Second Edition (Vol 1)
Neuroscience comprises increasingly diverse fields ranging from molecular genetics to neurophilosophy. The common thread between all these fields is the structure of the human nervous system. Knowledge on the structure, connections and function of the brain of experimental animals is readily available. On the other hand the structure of the human...
A Brief History of the Olympic Games
A Brief History of the Olympic Games

For more than a millennium, the ancient Olympics captured the imaginations of the Greeks, until a Christianized Rome terminated the competitions in the fourth century AD. But the Olympic ideal did not die and this book is a succinct history of the ancient Olympics and their modern resurgence.

Classics professor David Young, who
...


Emergencies in Urology
Emergencies in Urology

This is a comprehensive textbook covering one of the few remaining blind spots on the map of urological literature. To date only a small number of publications have been dedicated to the topic of urgent and emergent problems in urology, important though they are in everyday clinical medicine. The editors are both internationally recognized...

LÖVE for Lua Game Programming
LÖVE for Lua Game Programming

If you want to create 2D games for Windows, Linux, and OS X, this guide to the LÖVE framework is a must. Written for hobbyists and professionals, it will help you leverage Lua for fast and easy game development.

Overview

  • Discover the LÖVE framework and build games easily and efficiently
  • ...
Future Spacecraft Propulsion Systems: Enabling Technologies for Space Exploration (Springer Praxis Books / Astronautical Engineering)
Future Spacecraft Propulsion Systems: Enabling Technologies for Space Exploration (Springer Praxis Books / Astronautical Engineering)

In this second edition of Future Spacecraft Propulsion Systems, the authors demonstrate the need to break free from the old established concepts of expendable rockets, using chemical propulsion, and to develop new breeds of launch vehicle capable of both launching payloads into orbit at a dramatically reduced cost and for sustained operations in...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy