My job managing a calling list. : T-SQL Tuesday #150
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-10
9 reads
Blog Posts
Daily Coping 9 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-09
38 reads
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
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
25 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
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,187 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
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
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...
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