Press "Enter" to skip to content

Day: September 23, 2025

Cross-Validation and Time Series Data

Published 2025-09-23 by Kevin Feasel

Vlad Johnson takes us through a technique to test time series results:

Time series modeling, compared to traditional nontemporal modeling, presents unique challenges in ensuring that models generalize well to future, unseen data. One key methodology to address these challenges is cross-validation.

Time series data inherently contains temporal dependencies — observations are ordered in time, and future values may depend on past trends. This structure makes it challenging to estimate how well a model will perform on new, unseen data.

Click through for an explanation of cross-validation, why this becomes challenging when you have time series data (or other serially correlated data), and tips to resolve this challenge.

Leave a Comment

Natural Language Querying in SQL Server

Published 2025-09-23 by Kevin Feasel

Hadi Fadlallah shells out to an API:

Data is usually the most important asset in organizations, but only SQL developers can frequently access that data. Technical teams often write queries for non-technical users. This restricts agility, slows decision-making, and creates a bottleneck in data accessibility. One possible remedy is natural language processing (NLP), which enables users to ask questions in simple English and receive answers without knowing any code. Still, the majority of NLP-to-SQL solutions are cloud-based, which raises issues with cost and privacy.

This particular solution has nothing to do with the embedding features in SQL Server 2025. Instead, it essentially shells out to an Ollama API and runs the resulting SQL query. It’s reasonably neat but I’d have so many qualms putting anything like this into production.

Leave a Comment

Microsoft Fabric Extension for VS Code now GA

Published 2025-09-23 by Kevin Feasel

Sunitha Muthukrishna announces an update to an extension:

Manage Fabric items programmatically: Use item definitions to unlock scripting and work with your items as files. You can update and deploy Fabric items to existing workspaces or new workspaces directly from VS Code—saving you time and effort. Fabric items, that have Item definitions API support, support this capability.

Read on to see what else made the cut.

Leave a Comment

Dynamic Landing Pages for Embedded Power Apps

Published 2025-09-23 by Kevin Feasel

Jon Vöge has one landing page to rule them all:

In either scenario, we would of course like to solve this using 1 app with multiple screens, and dynamically open up different screens depending on a parameter.

We would not want to develop two almost identical apps, with governance on each app, just to be able to present different landing pages for each scenario.

So how do you do it? Read on below for the answer…

Click through for the scenario depictions as well as the answer.

Leave a Comment