Today's post is a fairly short one. Let's say you want to connect to Azure Data Lake Storage Gen2 from SQL Server 2022. We saw in a recent post how to connect to Azure Blob Storage. When it comes to Azure Data Lake Storage, the story is almost the same, though there are a couple…
SQL Server 2022 Data Virtualization: Insert into Azure Blob Storage
Several years ago, I wrote a blog post on how to insert data into Azure Blob Storage from SQL Server using PolyBase. That technique used PolyBase V1: the Java connector for Hadoop. With SQL Server 2022 eliminating that connector, we're going to learn the new method. Starting out the Same Regardless of the version of…
PolyBase and Named Instances
One of the built-in connectors for PolyBase in SQL Server 2022, as well as SQL Server 2019, is to connect one SQL Server instance to another. In this post, we'll look at how to connect to a named instance of SQL Server. And then There Were Two We have two SQL Server instances running on…
PolyBase and Azure Blob Storage
A long, long time ago (I can still remember) PolyBase used to connect to Azure Blob Storage. Specifically, you could use the wasbs:// protocol and connect to Azure Blob Storage over WebHDFS. Here's an example of an external data source which would work for SQL Server 2016 through 2019: USE MyDB GO CREATE DATABASE SCOPED…
PolyBase and Windows Authentication in SQL Server 2022
Back in the SQL Server 2019 days, I laid out a post which covered a really annoying bug around Windows authentication and PolyBase. The upshot is that SQL Server 2019 CU2 broke Windows authentication, meaning that you could not create external objects on a SQL Server instance while using a Windows authenticated session. In CU2,…
36 Chambers - The Legendary Journeys: Execution to the max! 