Description: PolyBase Revealed by Kevin Feasel Intermediate-Advanced user level FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description 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 coverageof 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 Microsofts product direction.What You Will LearnInstall and configure PolyBase as a stand-alone service, or unlock its capabilities with a scale-out clusterUnderstand how PolyBase interacts with outside data sources while presenting their data as regular SQL Server tablesWrite queries combining data from SQL Server, Apache Hadoop, Oracle, Cosmos DB, Apache Spark, and moreTroubleshoot PolyBase queries using SQL Server Dynamic Management ViewsTune PolyBase queries using statistics and execution plansSolve common business problems, including "cold storage" of infrequentlyaccessed data and simplifying ETL jobsWho This Book Is ForSQL Server developers working in multi-platform environments who want one easy way of communicating with, and collecting data from, all of these sources Back Cover 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 Microsofts product direction. You will: 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 Author Biography Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage where he specializes in T-SQL and R development, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead curator at Curated SQL (curatedsql.com). A resident of Durham, North Carolina, USA, Kevin can be found cycling the trails along the Triangle whenever the weather is nice enough. Table of Contents 1. Installing and Configuring PolyBase.- 2. Connecting to Azure Blob Storage.- 3. Connecting to Hadoop.- 4. Using Predicate Pushdown to Enhance Query Performance.- 5. Common Hadoop and Blob Storage Integration Errors.- 6. Integrating with SQL Server.- 7. Built-In Integrations: Cosmos DB, Oracle, and More.- 8. Integrating via ODBC.- 9. PolyBase in Azure SQL Data Warehouse.- 10. Examining PolyBase via Dynamic Management Views.- 11. Query Tuning with Statistics and Execution Plans.- 12. PolyBase in Practice. Feature Helps you remain relevant through your existing T-SQL skills Aids in mastering an important new product line from Microsoft Covers data sources such as Apache Hadoop, Azure Blob Storage, Apache Spark, Cosmos DB, and more Details ISBN1484254600 Author Kevin Feasel Publisher APress Edition 1st ISBN-10 1484254600 ISBN-13 9781484254608 Format Paperback Imprint APress Subtitle Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond Place of Publication Berkley Country of Publication United States DEWEY 004.165 Pages 311 Year 2019 Publication Date 2019-12-21 Short Title PolyBase Revealed Language English DOI 10.1007/978-1-4842-5461-5 UK Release Date 2019-12-21 AU Release Date 2019-12-21 NZ Release Date 2019-12-21 US Release Date 2019-12-21 Illustrations 192 Illustrations, black and white; XIX, 311 p. 192 illus. Edition Description 1st ed. Audience Professional & Vocational We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:126513986;
Price: 60.48 AUD
Location: Melbourne
End Time: 2025-01-17T06:01:11.000Z
Shipping Cost: 12.07 AUD
Product Images
Item Specifics
Restocking fee: No
Return shipping will be paid by: Buyer
Returns Accepted: Returns Accepted
Item must be returned within: 30 Days
ISBN-13: 9781484254608
Book Title: PolyBase Revealed
Number of Pages: 311 Pages
Language: English
Publication Name: Polybase Revealed: Data Virtualization with Sql Server, Hadoop, Apache Spark, and Beyond
Publisher: Apress
Publication Year: 2019
Subject: Computer Science
Item Height: 254 mm
Item Weight: 633 g
Type: Textbook
Author: Kevin Feasel
Item Width: 178 mm
Format: Paperback
