PolyBase Revealed

Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond



Bookstore > Books > PolyBase Revealed

Price$21.73 - $27.80
Rating
AuthorKevin Feasel
PublisherApress
Published2020
Pages311
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484254600
ISBN-139781484254608
EBook Hardcover Paperback

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.




Similar Books


Platform Embedded Security Technology Revealed

Platform Embedded Security Technology Revealed

by Xiaoyu Ruan

Platform Embedded Security Technology Revealed is an in-depth introduction to Intel's platform embedded solution: the security and management engine. The engine is shipped inside most Intel platforms for servers, personal computers, tablets, and smartphones. The engine realizes advanced security and management functionalities and pro...

Price:  $39.99  |  Free ebook  |  Publisher:  Apress  |  Release:  2014

Metro Revealed: Building Windows 8 apps with HTML5 and JavaScript

Metro Revealed: Building Windows 8 apps with HTML5 and JavaScript

by Adam Freeman

This 88-page primer unveils the key features of Microsoft's eagerly anticipated Windows 8 operating system. Windows 8 contains Microsoft's revolutionary new application framework for building dynamic and responsive touch-enabled applications that target both desktops and mobile devices....

Price:  $3.98  |  Publisher:  Apress  |  Release:  2012

TypeScript Revealed

TypeScript Revealed

by Dan Maharry

TypeScript Revealed is a quick 100-page guide to Anders Hejlsberg's new take on JavaScript. With this brief, fast-paced introduction to TypeScript, .NET, Web and Windows 8 application developers who are already familiar with JavaScript will easily get up to speed with TypeScript and decide whether or not to start incorporating it int...

Price:  $29.10  |  Publisher:  Apress  |  Release:  2013

Windows PowerShell Desired State Configuration Revealed

Windows PowerShell Desired State Configuration Revealed

by Ravikanth Chaganti

Desired State Configuration (DSC) is a powerful new configuration management platform that makes it easier than ever to perform cross-platform configuration management of your infrastructure, whether on-premise or in the cloud. DSC provides the management platform and Application Programming Interface (API) that can be used with any progr...

Price:  $57.59  |  Publisher:  Apress  |  Release:  2014

Windows 10 Revealed

Windows 10 Revealed

by Kinnary Jangla

Windows 10 Revealed is your essential step-by-step guide to using a desktop, laptop, Surface or Windows Phone running Microsoft Windows 10, providing a complete resource for both the beginner and the enthusiast. Techniques are illustrated step-by-step using photography and screen shots throughout, together with concise, easy to follow tex...

Price:  $18.24  |  Publisher:  Apress  |  Release:  2015

Oracle Database Transactions and Locking Revealed

Oracle Database Transactions and Locking Revealed

by Thomas Kyte, Darl Kuhn

Oracle Database Transactions and Locking Revealed provides much-needed information for building scalable, high-concurrency applications and deploy them against the Oracle Database. Read this short, 150-page book that is adapted from Expert Oracle Database Architecture to gain a solid and accurate understanding of how locking and concurren...

Price:  $37.98  |  Publisher:  Apress  |  Release:  2014

Rails 5 Revealed

Rails 5 Revealed

by Alan Bradburne

This short early adopter book details both how you'll upgrade existing web and other applications from Rails 4.2 to 5 and how to create new applications in Rails 5. The headline features, Rails API and ActionCable, are each looked at in detail, building small example projects to demonstrate how to build a JSON API, add real-time noti...

Price:  $19.99  |  Publisher:  Apress  |  Release:  2016

SQL Server AlwaysOn Revealed

SQL Server AlwaysOn Revealed

by Peter Carter

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter's Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime.Begin with an introd...

Price:  $38.95  |  Publisher:  Apress  |  Release:  2015