My 800th post!

It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading

Azure Databricks to Power BI

A very common approach is to query data straight from Databricks via Power BI. For this you need Databricks token and the JDBC address URL. This is found within...

SQLSaturday #1000! Join Oregon Virtually this Saturday

Honored to be a part of not just SQLSaturday #1000, but the long proud history of the free community series of SQLSaturdays celebrating their 1000th+ event. (I spoke at...

Azure DevOps–Reconfiguring an Agent

This post looks at how to re-configure a local Azure DevOps agent when you need to change to a new pool or organization. PAT Expired I got a note...

Daily Coping 19 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Daily Coping 16 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Write It Down!

Recently I set up a new process to pull data out of a MySQL database and into SQL Server. Pretty standard ETL stuff, but it’s the organization’s first time...

Configure Windows Server 2019 Multi-Subnet Cluster - Part 11

Install SQL Server 2019 - Part 10

Synapse and federated queries

As I was finishing up a demo script for my presentation at the SQL PASS Virtual Summit on 11/13 (details on my session here), I wanted to blog about...