{"product_id":"polybase-revealed-data-virtualization-with-sql-server-hadoop-apache-spark-and-beyond-paperback","title":"Polybase Revealed: Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond - Paperback","description":"\u003cp\u003eby \u003cb\u003eKevin Feasel\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eHarness 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.\u003c\/p\u003e\u003cp\u003e\u003cb\u003e\u003ci\u003ePolyBase Revealed\u003c\/i\u003e\u003c\/b\u003e 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.\u003c\/p\u003e \u003cp\u003eWith 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.\u003cbr\u003e\u003c\/p\u003e \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cb\u003eWhat You Will Learn\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eInstall and configure PolyBase as a stand-alone service, or unlock its capabilities with a scale-out cluster\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eUnderstand how PolyBase interacts with outside data sources while presenting their data as regular SQL Server tables\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eWrite queries combining data from SQL Server, Apache Hadoop, Oracle, Cosmos DB, Apache Spark, and more\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eTroubleshoot PolyBase queries using SQL Server Dynamic Management Views\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eTune PolyBase queries using statistics and execution plans\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eSolve common business problems, including \"cold storage\" of infrequently accessed data and simplifying ETL jobs\u003c\/li\u003e\n\u003c\/ul\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003cbr\u003eSQL Server developers working in multi-platform environments who want one easy way of communicating with, and collecting data from, all of these sources\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003eHarness 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.\u003c\/p\u003e\u003cp\u003e\u003ci\u003ePolyBase Revealed\u003c\/i\u003e 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.\u003c\/p\u003e\u003cp\u003eWith 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.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eYou will: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eInstall and configure PolyBase as a stand-alone service, or unlock its capabilities with a scale-out cluster\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eUnderstand how PolyBase interacts with outside data sources while presenting their data as regular SQL Server tables\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eWrite queries combining data from SQL Server, Apache Hadoop, Oracle, Cosmos DB, Apache Spark, and more\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eTroubleshoot PolyBase queries using SQL Server Dynamic Management Views\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eTune PolyBase queries using statistics and execution plans\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eSolve common business problems, including \"cold storage\" of infrequently accessed data and simplifying ETL jobs\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003cb\u003eKevin Feasel \u003c\/b\u003eis 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.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e\u003cbr\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 311\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.69 x 10 x 7 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e December 21, 2019\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42104840978567,"sku":"9781484254608","price":35.62,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0601\/2623\/2711\/files\/e8db8ab9155cce7a5f250ca576fc7a45.webp?v=1732428632","url":"https:\/\/booksby.splitshops.com\/products\/polybase-revealed-data-virtualization-with-sql-server-hadoop-apache-spark-and-beyond-paperback","provider":"Books by splitShops","version":"1.0","type":"link"}