Press "Enter" to skip to content

Curated SQL Posts

Working with the Power BI Gantt Chart

Published 2026-10-20 by Kevin Feasel

Valerie Junk tries out a new built-in visual:

Almost every company runs projects or has some kind of timeline, and most of the time that planning is tracked somewhere else, for example, in an Excel file or in another tool. But at the same time, most of our data is already in Power BI. Until now you basically had two options:

  • A custom visual which might need a paid license.
  • A workaround you build yourself, like a stacked bar chart or a matrix with conditional formatting, which works, but every change means fixing your own workaround.

It looks fairly reasonable, though I do hope the Power BI team is able to relax some of those restrictions before it goes GA. Because I’m only so much of a masochist, I didn’t look up whether Power BI Report Server will include this visual. Maybe it will three years from now.

Leave a Comment

Full-Text Indexing and Power BI Semantic Model Refresh Times

Published 2026-10-20 by Kevin Feasel

Chris Webb runs a test:

The September release of Power BI saw the introduction of a powerful new feature: full text indexing, which makes searching and filtering on text columns much faster and enables the use of the new TextContains() and TextSimilarity() DAX functions. You need to enable it on a per-column basis and when you do that you have the option to rebuild the full-text index for those columns when you do a Full refresh or when you do a refresh of the type Indexes. So the big question is: how long does it take to build a full-text index on a column and what impact will it have on your overall refresh times?

Read on for that answer in a reasonably-sized dataset containing street addresses.

Leave a Comment

Building an Isolated Hyper-V Network for Azure Communications

Published 2026-10-20 by Kevin Feasel

Jordan Boich continues a series on networking for the DBA:

Before I even touched anything related to Azure, I needed to make sure that nothing I did could impact my Wi-Fi at home. The whole reason why I love home lab environments so much is because it is contained end to end. If I break something in my lab, it’s comforting to know that nothing important will ever be in that blast radius. This post is all about hitting the prerequisites that don’t touch anything important like setting up an isolated lab network, save points for my existing VMs, license checks, and creating an Azure subscription that doesn’t touch anything else.

Read on to see what Jordan did.

Leave a Comment

Connecting Azure Databricks to a Microsoft Foundry AI Gateway

Published 2026-10-20 by Kevin Feasel

Drew Furgiuele connects the dots:

While some people might look at the different capabilities and think this is an “either/or” scenario, the reality is that most Azure customers are going use (or even need to use) both: developers building apps and agents in Databricks, for example, may want to leverage a model or other agent deployed in Foundry. Meanwhile, developers in Foundry may need to call a Databricks managed MCP service.

These types of calls aren’t all that difficult; in fact, both platforms provide built-in connectors or UI solutions to make this happen: simply provide the service endpoint, pick your authentication method, and you’re pretty much done. However, the introduction of the respective gateways, especially on the Foundry side, can make this just a little more complicated. Let’s look at one example.

Click through for that issue and how Drew was able to work around it.

Leave a Comment

Creating an Azure DevOps Deployment

Published 2026-10-20 by Kevin Feasel

Reitse Eskens deploys some Microsoft Fabric assets:

Let me generalise first: you can essentially choose two options to promote your hand-crafted and superior code compared to anyone else from development to production. The first way is to use the Fabric deployment pipelines. These are essentially copy actions that move the development state to production. Option two is to use either GitHub Actions or Azure DevOps pipelines.

The main issue I’ve seen with the Fabric deployment pipelines is that the deployed code still references the development environment. This results in your notebook running in production and happily writing the results in the development lakehouse. To mitigate this, you can add actions to the Fabric pipeline, check out the newly announced Fabric deployment plans, or remember to update all references.

Click through for a high-level depiction of the process.

Leave a Comment

Testing Immutable SQL Server Backups

Published 2026-10-20 by Kevin Feasel

Warwick Rudd tries to make a change:

In Part 1 we built an immutable container. In Part 2 we gave the SQL Server 2025 VM a Managed Identity and Microsoft Entra authentication. This is where it comes together. We’ll keep the traffic between SQL Server and storage on the private network, lock down who can reach the storage account, give the VM permission to write, and then take a backup and try to delete it.

Read on for those steps.

Leave a Comment

Skipping Incompatible Objects in Bacpac Restoration

Published 2026-10-19 by Kevin Feasel

Erik Ejlskov Jensen shares some good news:

If you have ever tried to export a SQL Server database to a .bacpac file with sqlpackage, you have most likely run into the dreaded SQL71627 error, complaining about a Windows user or login. I ran into it myself a few years ago, and the only workaround was to drop the offending users from the database (or a copy of it) before running the export.

With sqlpackage 170.6.28-preview, that workaround is no longer needed. The Export action has two new properties that let you remove objects that are not compatible with Azure SQL Database while exporting, and write a report of what was removed.

Click through for a demonstration.

Leave a Comment

What’s the Time Again?

Published 2026-10-19 by Kevin Feasel

Umachandar Jayachandran checks a watch:

Affected locations in British Columbia, Alberta, and Manitoba will not turn their clocks back at 02:00 local time on November 1, 2026. They will remain at UTC−07:00, UTC−06:00, and UTC−05:00, respectively. 

Microsoft’s interim guidance for British Columbia, Alberta, and Manitoba describes the new Windows time zones and temporary workarounds. 

SQL Server on Windows requires the applicable Windows update—not a separate SQL Server product update. For SQL Server on Linux, Azure SQL Database, and Azure SQL Managed Instance, the following guidance applies when the new regional time zones are not yet available in your deployment. 

Click through if you have anything in that latter bucket.

Leave a Comment

Disabling FileStream and FileTable on a SQL Server Instance

Published 2026-10-19 by Kevin Feasel

Stephane Haby turns off a feature:

A customer recently asked me to disable FileTable/FileStream on their instance because the databases no longer use it, and to ensure that this is indeed the case.
The aim is to migrate to a new architecture without FileTable/FileStream in a second time.

The tricky bit is that the relevant database is also inside of an Availability Group. Click through for the process.

Leave a Comment