A Fine Slice Of SQL Server
Greg Low lightens things up a bit:
As soon as I started working with a recent version of SSMS, I realized that I didn’t like how heavy the grid lines were in the output:
I really wanted the data to be the focus, not the lines. They seemed much darker than on the previous versions. Note that this is a personal preference. I can imagine some people preferring them as they now are. Fortunately, though, you can now change the color of the lines.
Click through to see how.
Leave a CommentThis is post two in my series about the Data API Builder (dab), the first post, Data API Builder, covers what dab is and how to test it locally against SQL Server in running in a container. This was great for testing, but now we want to start to productionise this, and the first step is to get it running somewhere other than my laptop.
There are several deployment options available, I recommend you review the Microsoft docs here: Deployment guidance for Data API builder.
ACI wouldn’t necessarily be my first choice for, well, much of anything. However, it is cheap and easy, so it has that going for it.
Leave a CommentExponential moving averages (emas) are a powerful means of detecting changes in time series data. However, if you are new to this task, you may be wondering how to choose from conflicting advice about how to calculate emas. This tip reviews several of the most popular methods for calculating moving averages. Additionally, this tip presents T-SQL code samples with common table expressions and stored procedures for generating emas from an underlying time series dataset.
“Emas don’t just track trends—they reveal momentum in motion.” That’s why they’re favored when recent values matter most—and why this tip focuses on helping you calculate them with precision.
Read on for the formula and a couple of lengthy scripts to generate it.
Leave a CommentJimmy Angelakos announces a new version of the pg_statviz extension:
I’m happy to announce release 0.8 of
pg_statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics.This release adds support for PostgreSQL 18, adapting to significant catalog view changes introduced in this release:
Read on to see what’s new. pg_statviz is a lightweight extension for observing internal PostgreSQL performance data, such as wait stats and I/O time.
Leave a CommentKoen Verbeeck downloads a report:
Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have a report in a Power BI workspace (Pro, PPU, Fabric, it shouldn’t matter), and they’ve lost the original Power BI Desktop file. You try to download the report, but for some reason the GUI doesn’t let you:
Read on for reasons you might not be able to download the report, as well as what you can do if you do have access to the report but the download option is unavailable.
Leave a Comment