How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a...
2022-10-14 (first published: 2022-09-29)
306 reads
Query Tuning At PASS Data Community Summit
The all new, in-person, PASS Data Community Summit is in just a few weeks. Since I’m shortly going to be publishing a 100% rewritten book on query tuning, I...
2022-10-12 (first published: 2022-09-28)
216 reads
Daily Coping 28 Sep 2022
Today’s coping tip is let go of other people’s expectations of you. I think in general I’m not too concerned about what other people think of me, or expect...
2022-09-28
16 reads
SQL Server In Place Upgrades
Good morning dear blog reader. Today’s episode is fresh from a great weekend with the family. It is always fun to go on a road trip with my wife...
2022-09-27
2,721 reads
Daily Coping 27 Sep 2022
Today’s coping tip is take your time. Make space to just breathe and be still. An easy one today. I’m relaxing in Venice with my wife, and likely no...
2022-09-27
19 reads
Running SQL Server in Windows Subsystem for Linux (WSL)
I previously wrote a post on how to convert a SQL Server Docker image to a Windows Subsystem for Linux distribution. I did this because if you tried to...
2022-10-05 (first published: 2022-09-27)
5,352 reads
Viewing errors with extended events
A little while back I came across this post: Identifying failed queries with extended events. It has a script to ... Continue reading
2022-10-10 (first published: 2022-09-27)
378 reads
My Toolbox - Everything
Foreword
Not everything in the general sense, but a tool called Everything by voidtools (Download link). Usually, I have to make this distinction when googling.
No matter how great is my...
2022-09-27
58 reads
Understanding Microsoft Purview Pricing
Ever since its official launch around October 2021, Microsoft Purview has been one of the more popular services in Azure, with a steady stream of new features expanding the...
2022-10-07 (first published: 2022-09-27)
859 reads
Why I tweet about work and personal topics from the same account
Over the last few years, I’ve had a few people ask me why I don’t create two Twitter accounts so I can separate work and personal things. I choose...
2022-10-07 (first published: 2022-09-26)
231 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Inventory Snapshot for missing Period
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers