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.)

Practical DataOps: Delivering Agile Data Science at Scale
Practical DataOps: Delivering Agile Data Science at Scale
Gain a practical introduction to DataOps, a new discipline for delivering data science at scale inspired by practices at companies such as Facebook, Uber, LinkedIn, Twitter, and eBay. Organizations need more than the latest AI algorithms, hottest tools, and best people to turn data into insight-driven action and useful...
Encyclopedia of Big Data Technologies
Encyclopedia of Big Data Technologies

The Encyclopedia of Big Data Technologies provides researchers, educators, students and industry professionals with a comprehensive authority over the most relevant Big Data Technology concepts. With over 300 articles written by worldwide subject matter experts from both industry and academia, the encyclopedia covers topics...

The Brain from Inside Out
The Brain from Inside Out
Is there a right way to study how the brain works? Following the empiricist's tradition, the most common approach involves the study of neural reactions to stimuli presented by an experimenter. This 'outside-in' method fueled a generation of brain research and now must confront hidden
assumptions about causation and
...

Physics Part 1 Class - 9
Physics Part 1 Class - 9

Physics can be tough for many students. But when there is clarity of concept and the explanations are neatly presented, Physics can become an interesting subject too.

Physics Part 1 for class 9 is written as per the prescribed and updated syllabus of NCERT and CBSE board. The book has many easy to understand explanations...

Numerical Methods (De Gruyter Reference)
Numerical Methods (De Gruyter Reference)
This multi-volume handbook is the most up-to-date and comprehensive reference work in the field of fractional calculus and its numerous applications. This third volume collects authoritative chapters covering several numerical aspects of fractional calculus, including time and space fractional derivatives, finite differences and finite elements,...
Think Like Amazon: 50 1/2 Ideas to Become a Digital Leader
Think Like Amazon: 50 1/2 Ideas to Become a Digital Leader

“Reading this book is like having Jeff Bezos advise me.” ?Eric Martinez, Founder and CEO of Modjoul

...

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