Press "Enter" to skip to content

Day: December 31, 2025

Python Libraries for Advanced Time Series Forecasting

Published 2025-12-31 by Kevin Feasel

Ivan Palomares Carrascosa has a list:

Fortunately, Python’s ecosystem has evolved to meet this demand. The landscape has shifted from purely statistical packages to a rich array of libraries that integrate deep learning, machine learning pipelines, and classical econometrics. But with so many options, choosing the right framework can be overwhelming.

This article cuts through the noise to focus on 5 powerhouse Python libraries designed specifically for advanced time series forecasting. We move beyond the basics to explore tools capable of handling high-dimensional data, complex seasonality, and exogenous variables. For each library, we provide a high-level overview of its standout features and a concise “Hello World” code snippet to familiarize yourself immediately.

Click through for an explanation of each of the five libraries.

Leave a Comment

Diagnosing DirectQuery Connection Limit Issues

Published 2025-12-31 by Kevin Feasel

Chris Webb goes troubleshooting:

To kick off my series on diagnosing Power BI performance problems with Performance Analyzer in the browser (which I introduced last week with my post on vide-coding a custom visual to visualise Performance Analyzer data), I want to revisit a subject I blogged about two years ago: how hitting the limit on the maximum number of connections to a DirectQuery data source can lead to queries queuing for an available connection and performance problems. In my original post on this topic I showed how you can use the Execution Metrics event in Profiler/Log Analytics/Workspace Monitoring to see when this queuing happens. In this post I will show how you can do exactly the same thing with Performance Analyzer.

Read on to learn how.

Leave a Comment

Object-Level Security in Power BI

Published 2025-12-31 by Kevin Feasel

Vin Mai Quang lays out an explanation:

For a POC project, my team lead asked me to practice and build a demo Power BI report that applied OLS (Object Level Security). Although it sounded simple at first, I was surprised by how OLS actually behaves in Power BI. In this blog, I would like to share my findings with you.

Click through for a demonstration of how it all works, including how to deal with scenarios in which customers shouldn’t get access to specific columns but should still be able to see others.

Leave a Comment

The Year in DAX 2025

Published 2025-12-31 by Kevin Feasel

Marco Russo lays out a list:

This was a big year for DAX, with the public preview that started in September for two new features: user-defined functions (UDFs) and calendar-based time intelligence.

The user-defined functions are the most significant update to the DAX language since 2015, when Microsoft introduced variables. Can you believe that for more than five years we had to write DAX code without variables? Well, the user-defined functions we just mentioned will have an even bigger impact in the long term.

Read on for more information on key additions, new DAX functions, and all of the neat stuff that the SQLBI team put together this year.

Leave a Comment

Tracking Database File Sizes via Powershell

Published 2025-12-31 by Kevin Feasel

Kyle Burwell wants to know how big the databases are:

Database files (mdf, nds, ldfs, etc.) can get out of hand quickly and easily, leading to issues down the road. This can be due to improper planning, large data loads, and bad code run in production, just to list a few. As unglamorous as disk space monitoring is, we need to do our part as DBAs. This post is a quick guide on how to track database file sizes with PowerShell.

Read on for a few scripts to perform the task.

Leave a Comment

Creating a SQL Server 2025 Practice Environment

Published 2025-12-31 by Kevin Feasel

John Deardurff installs SQL Server 2025:

Microsoft SQL Server 2025 introduces major advancements in performance, security, and built‑in AI capabilities. Before you can start exploring its new features, you need to install it correctly. This guide walks you through the full installation process of SQL Server 2025, SQL Server Management Studio 22, and restoring the AdventureWorks2025 database to create a practice environment to test the new features and enhancements of this new release.

I was going to joke, “But John, what about your loyal Linux-using readers? How can we do this?” But instead, I’ll say that I’m glad that AdventureWorks is still alive and kicking. It is, on the whole, a nice demo database.

Leave a Comment