Press "Enter" to skip to content

Day: June 20, 2025

Leaving out an Element in R

Published 2025-06-20 by Kevin Feasel

Kieran Healy shows how to get all but one element from a vector in R:

Sometimes we want to repeatedly do things with all but one row of a data frame, where we systematically drop each row in turn and do the thing. For example, jacknife cross-validation is a kind of very basic bootstrap technique. (It is computationally simpler than and predates the bootstrap.) Or in some areas “leave-one-out” summary statistics are often calculated as a quick robustness check. Sometimes we want to do this within groups, perhaps especially when the groups may be small.

Read on to see how, including several examples. H/T R-Bloggers.

Leave a Comment

Farewell, SSRS

Published 2025-06-20 by Kevin Feasel

SQL Server Reporting Services is done-zo:

Starting with SQL Server 2025, Microsoft is consolidating all on-premises reporting services under Power BI Report Server (PBIRS). No new versions of SQL Server Reporting Services (SSRS) will be released. PBIRS becomes the default on-premises reporting solution for SQL Server.

You can expect more information about specific editions when SQL Server 2025 is in General Availability (GA).

This article outlines the implications of these changes for you as a customer, and addresses any questions you might have.

The article claims that Power BI Report Server is a superset of SSRS. That might actually be so, but there’s a nagging part in the back of my brain saying that there are things we can do in SSRS that we can’t in PBIRS and that this won’t be the smooth transition that the article claims. But it’s been long enough since I’ve worked on SSRS in earnest to be able to say with certainty whether it’s the case.

H/T Blake McNeill.

1 Comment

Changes to Accelerated Database Recovery in 2025

Published 2025-06-20 by Kevin Feasel

Jordan Boich points out something interesting coming in SQL Server 2025:

Accelerated Database Recovery (ADR) was introduced in SQL Server 2019. Its main purpose is to allow for faster database recovery in the event of a crash or unexpected shutdown. Traditionally, the database engine handles crash recovery through a series of phases—analysis, redo, and undo—which can be inefficient and slow, especially when dealing with long-running transactions.

To make a long story short, ADR “shortcutsˮ the recovery process by introducing a new approach to handling undo operations. Instead of relying heavily on scanning the transaction log—which can be painfully slow for uncommitted or long-running transactions—ADR maintains a version store within the user database to track row-level changes. This allows SQL Server to quickly roll back uncommitted transactions without scanning the entire log. The result is much faster crash recovery, quicker rollbacks, and improved overall database availability, particularly in high-transaction environments.

Read on to see what’s new, as well as some of the consequences of enabling this feature.

Leave a Comment

Changing a Busy Column’s Data Type in SQL Server

Published 2025-06-20 by Kevin Feasel

Matt Gantz makes a staggered change:

In a previous post I showed how to use a batching strategy to remove large amounts of data from a table while it is being used. Today I will apply the same technique to another common problem- changing the datatype of a column. A common use of this is to normalize a text column into an integer (that references another table), but could be used to transition to and from any datatype . Many of the considerations in the previous post apply, so I advise you to read it as well before using this technique.

Click through for the process.

Leave a Comment

Comparing OrioleDB and Neon

Published 2025-06-20 by Kevin Feasel

Alexander Korotkov reminds us that there are a lot of data platform products out there:

In a recent Hacker News discussion, there was some confusion about the differences between OrioleDB and Neon. Both look alike at first glance. Both promise a “next‑gen Postgres”. Both have support for cloud‑native storage.

This post explains how the two projects differ in practice. And importantly, OrioleDB is more than an undo log for PostgreSQL.

Alexander is the creator of OrioleDB, so price in any vendor bias you wish as you see the comparison of two up-and-coming technologies.

Leave a Comment