Press "Enter" to skip to content

Author: Kevin Feasel

Security and High Availability Checklist for Database Application Vendors

Published 2026-01-16 by Kevin Feasel

Andreas Wolter has a new version of a checklist:

As a database application vendor, the security and reliability of your software are key competitive differentiators. As a Database Administrator, your priority is ensuring that hosted databases do not expose data or the environment to risk. To support this, we have developed a checklist designed as a blueprint for building secure-by-default, resilient data applications. Following this guidance not only helps you align with ISO 27001 controls but also ensures that your customers can trust your product against the backdrop of a demanding enterprise environment and an evolving threat landscape.

Click through for the list, as well as a PDF version of it. I had a couple of quibbles in my immediate reaction (especially avoiding CLR and triggers), but in fairness, as I thought about whether I’d trust rando vendor XYZ to get it right, I decided that this is good advice.

Leave a Comment

Defining Applications in Power BI and Microsoft Fabric

Published 2026-01-15 by Kevin Feasel

Andy Brownsword deploys an app:

When using Power BI or Fabric workspaces to browse reports, we’re greeted with a list of items and their attributes. While attention is given to report visuals such as bars, pies, candles, and RAG highlights, the surrounding experience is neglected. When it comes to consumption, the standard interface falls short.

Apps fill this gap. They’ve been around in Power BI for a while, but with the additional layers that come with Fabric, the need for a clean way to present content is increasingly valuable.

Read on to learn about more functionality around apps and how you can set them up in Fabric/Power BI.

Leave a Comment

Thoughts on the Death of the DBA

Published 2026-01-15 by Kevin Feasel

Rebecca Lewis presses X to doubt:

Every few years, something comes along that’s definitively, no-questions-asked going to replace us.

Let’s review the historical record.

Rebecca points out a half-dozen instances in which people have decried the end of the DBA role, and yet it’s still there somehow… And honestly, you could probably find a half-dozen more examples without searching too hard, like how SQL Server 2000 was going to render DBAs obsolete because of its self-management capabilities. Which, admittedly, is very similar to the 1996 Oracle announcement.

Leave a Comment

MinIO Alternatives

Published 2026-01-15 by Kevin Feasel

Robin Moffatt looks for alternatives:

In late 2025 the company behind MinIO decided to abandon it to pursue other commercial interests. As well as upsetting a bunch of folk, it also put the cat amongst the pigeons of many software demos that relied on MinIO to emulate S3 storage locally, not to mention build pipelines that used it for validating S3 compatibility.

In this blog post I’m going to look at some alternatives to MinIO.

Read on for Robin’s analysis of a half-dozen alternatives.

1 Comment

Lessons Learned in a SQL Server 2025 Upgrade

Published 2026-01-15 by Kevin Feasel

Aaron Bertrand shares some lessons learned:

We recently upgraded multiple systems to SQL Server 2025. The engine upgrade itself was smooth, but three unexpected issues surfaced in our lower environments as we planned out production. None of these issues prevented the upgrade from completing, but all three could easily derail an otherwise smooth in-place upgrade to SQL Server 2025. What were these issues, and how can you avoid hitting them?

My biggest surprise out of this is that full-text search actually got upgraded.

Leave a Comment

Indexes and COUNT() in SQL Server

Published 2026-01-15 by Kevin Feasel

Louis Davidson does some testing:

A few weeks ago, there was a LinkedIn post (I can’t find it anymore) that covered something about how indexes were used by COUNT in SQL. I think it may have been based on SQL Server, but I am not sure (it is rare that one of the SQL posts on LinkedIn mentions a platform). At the time, I went and tried a few of the mentioned cases and realized this was an interesting question: how does the COUNT aggregate use indexes when you use various different expressions.

Louis has a series of test cases and I got most of them right, though I wasn’t sure about one particular optimization.

Leave a Comment

SQL ConstantCare Population Report for Q4 2025

Published 2026-01-15 by Kevin Feasel

Brent Ozar has an update:

It’s time for our quarterly update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server. In short, people are replacing SQL Server 2016 and 2017 with 2022!

I do think that 2025 will pick up steam. The marginal change was mostly into 2022, but 2025 wasn’t officially released until November and I’m guessing not many companies upgraded in December. I do think we’ll see some pickup of SQL Server 2025 in this quarter.

As always, this is my throat-clearing reminder that what Brent has is a biased sample of the SQL Server population and is not necessarily reflective of the population as a whole. It’s a very interesting sample upon which to reflect, but its specific bias is that it necessarily only includes customers of Brent Ozar’s service, which will be a specific subset of organizations.

Leave a Comment

Cloud Storage Archival via Parquet Files

Published 2026-01-14 by Kevin Feasel

Joey D’Antoni builds a tool:

What I’m writing about today has nothing to do with analytics, per se. It has everything to do with cloud storage, and the way operations there are priced. Specifically, metadata operations–in the demo code I’ve shared we’re going from five files to one, but you can imagine going from a much larger number of files to much smaller number of files. You may ask–“Joey that sounds dumb, why are you reinventing zip and iso files”. Well, the main reason is that many cloud operations are priced on the number of objects–for example if you had to calculate a checksum across a number of files on S3. (For files/objects that were created before S3 automatically did checksums).

Click through for more information on how it works, as well as a link to the GitHub repo.

Leave a Comment