In this article, we will learn how to ingest data into Azure Synapse Analytics with a focus on using PolyBase to load the data.
Read more »
PolyBase
SQL Server PolyBase external tables with Azure Blob Storage
January 15, 2021In this article, we will explore SQL Server PolyBase external tables with Azure Blob Storage.
Read more »
Data Virtualization with MongoDB using PolyBase in SQL Server 2019
October 9, 2020In this article, you’ll learn the approach to integrate MongoDB data source using data virtualization technique in SQL Server 2019. In this article, you can see how SQL Server 2019 provides a platform to create a modern enterprise data hub using data virtualization technology and the PolyBase technique.
Read more »
Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups
September 29, 2020In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.
Read more »
Enhanced PolyBase SQL 2019 – MongoDB and external table
December 14, 2018In this 5th part of the ongoing series of SQL Server 2019 Enhanced PolyBase, we will learn how to install and configure MongoDB and create an external table.
Read more »
Enhanced PolyBase SQL 2019 – External tables SQL Server, Catalog view and PushDown
November 6, 2018This article is part 4 of the series for SQL Server 2019 Enhanced PolyBase. Let quickly recap the previous articles.
Read more »
Enhanced PolyBase SQL 2019 – External tables using t-SQL
October 31, 2018In this article on PolyBase, we will explore more use case scenarios for external tables using T-SQL.
Read more »
Enhanced PolyBase SQL 2019 – External tables for Oracle DB
October 24, 2018In the previous article of the series, we took an overview of PolyBase in SQL Server 2017. We also learned about the Azure Data Studio and SQL Server 2019 preview extension to explore SQL Server 2019 features.
Read more »
Enhanced PolyBase SQL 2019 – Installation and basic overview
October 24, 2018SQL Server 2019 is recently launched in the ignite 2018 event by Microsoft. We can get an overview of SQL 2019 preview version and learn how to install it on Windows environment by following up the article SQL Server 2019 overview and installation.
Read more »
SQL Server 2016 – PolyBase tutorial
October 21, 2016Introduction
This article will teach you how to install PolyBase and will show you a simple example to start.
PolyBase is a new feature in SQL Server 2016. It is used to query relational and non-relational databases (NoSQL). You can use PolyBase to query tables and files in Hadoop or in Azure Blob Storage. You can also import or export data to/from Hadoop.
Read more »