Aggregate Functions in Power BI including Running Total, Running Average and Max
This article explains how to aggregate data for Power BI reports and provides examples of running totals, running averages, min, max, and more.
The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner
Every SQL Server developer has heard it: "Don't use NOLOCK in production!" But this common rule isn't as simple as it seems. Sometimes, what seems like a bad practice can actually be the right choice. Let's explain what NOLOCK really does in simple terms. When you use NOLOCK, you're telling SQL Server "just show me […]
Why Would You Do That?
We look at problems in different ways and Steve notes this can help or hinder us in software development.
3 Legit Signs It’s Time for Enterprise Edition
Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re wondering what you’re missing, and whether you should be on SQL Server Enterprise Edition. Here are 3 warning signs to watch out for.
The Pervasive Nature of Open Source
This week there was a headline that said "Open Source Software Powers 96% of Modern Applications, New Study Finds" and if you stopped reading there, you might think, hey, it's not in the apps I work on. Or you might think that because you use OSS software, most of the world also does. Microsoft, Oracle, […]
Distributed Monoliths
What is a distributed monolith vs. a microservice architecture? Steve has a few thoughts today.
Using Fivetran (HVR) to Replicate Data From PostgreSQL to an Azure Databricks Warehouse: Data Engineering with Azure
Learn how to use Fivetran HVR software to ETL data into your One Lake Storage from a PostgreSQL database.
Calculate a Moving Average with T-SQL Windowing Functions
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
Reducing the Cycle Time
Building software can be hard and lots of people have tried various methodologies to improve the way their teams work. Steve notes a lot of the process is the same, but he has a preference.
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?