Installing SQL Server on Windows

THE VIDEO https://youtu.be/RzB7An6nDgg THE SYNOPSIS In this video, we will show how to install SQL Server on a machine running Windows. You'll get a walkthrough of the installation process as well as some tips and tricks to make administering this server easier in the future. Along the way, we'll briefly cover editions of SQL Server.…

Advertisement

Getting Started WITHOUT SQL Server

A New Series One of the things I've been working on behind the scenes lately is creating short-form YouTube content. The first video launched this morning, and I have plans to do this every Tuesday for now, and once I build up a few videos in the buffer, will up that to every Tuesday and…

The Next Journey

Today marks a big day for me: this is my last day at ChannelAdvisor, where I've been for the past nine years. I didn't expect that I'd stick around that long. I also didn't expect that my departure wouldn't be of my own accord. One Team Down Late in Q3, CommerceHub acquired ChannelAdvisor. We weren't…

Finding Ghosts in Your Data: Official Release

Release day has arrived: Finding Ghosts in Your Data is now officially available in softcover and as an e-book. You can get it wherever fine books are sold, assuming they also sell less-fine books as well. I had intended to blog more about the book but ended up getting really busy and writing the thing…

SQL Server 2022 Data Virtualization: ADLS

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,…

PolyBase 2022 and Cosmos DB (Core API)

Getting Back to Basics To date, I've always used the MongoDB API for Cosmos DB when demonstrating PolyBase. This is true in PolyBase Revealed, as well as blog posts here. Today, that changes: we are going to use PolyBase to get data from a Cosmos DB using the Core API, also known as the SQL…