Database Design for Tracking Solar Production
We had a solar system installed at our house this year. I’m excited to see how this performs, as our estimates and research shows this ought to be a...
2022-05-09 (first published: 2022-04-27)
338 reads
Winding down
Normally I write these posts on a Friday evening. Sometimes it’s later than that, but always before Monday so that my editor can give it some attention before I...
2022-04-27
30 reads
Daily Coping 27 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-27
21 reads
Add Disk Performance Counters to Windows Task Manager
Have you ever wondered why Windows Server doesn’t show disk performance metrics in Task Manager, but your Windows 10/11 OS does? It’s a really silly difference. Let’s fix that....
2022-05-06 (first published: 2022-04-26)
8,323 reads
Daily Coping 26 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-26
16 reads
Microsoft Graph API in Power Automate: Using the Microsoft Graph Explorer
This is video two in a four-part series walking you through how to leverage the Microsoft Graph API within Power Automate. In this video, I
2022-04-26
128 reads
Azure Function with PowerShell and the Power BI REST API
In this blog post I’m going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as...
2022-05-06 (first published: 2022-04-26)
603 reads
Power BI Performance Features
It’s hard to believe but Power BI has now been available for over 10 years (see history)! Over the last few years there have been a number of new...
2022-05-04 (first published: 2022-04-25)
471 reads
Storage Field Day 23 – Fungible
I live my life in the field of information technology. Most of the topics that I work with are making databases speedy and more readily available. As such, most...
2022-05-04 (first published: 2022-04-25)
199 reads
Daily Coping 25 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-25
26 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers