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)
332 reads
Blog Posts
Friend of Redgate 2022
I am honored and humbled to be chosen to be part of the Friend of RedGate program for another year. This program is near and dear to my heart, and I look forward...
2022-05-09
39 reads
Microsoft Graph API in Power Automate: Adding Guest Users to your Tenant
This is video three in a four-part series walking you through how to leverage the Microsoft Graph API within Power Automate. In this video, you
2022-05-09 (first published: 2022-05-03)
291 reads
Updated Pluralsight Course – Configuring and Managing Kubernetes Security
My updated course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here, or if...
2022-05-09
4 reads
Updated Pluralsight Course – Configuring and Managing Kubernetes Security
My updated course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here, or if...
2022-05-09
25 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,186 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)
594 reads
Azure Redis Cache and Geo-replication
The concept of a geo-replicated partnership between a primary and secondary node is very similar to that of something you may have seen with Azure SQL DB, where the...
2022-05-06
76 reads
Daily Coping 6 May 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-05-06
12 reads
DEN to LAX Views
I wrote about this trip for an editorial, and here are a few views from the airplane. I love the flight from Denver to LA, though I wish I...
2022-05-06
61 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
Forums
Alamat kantor resmi BCA KCU CIANJUR Telp:0817629933
WhatsApp:0817629933 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers