Daily Coping 10 Aug 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-08-10
16 reads
Blog Posts
Power BI: Dynamically Removing Errors From Columns in M
If you have excel data, or user-entered data, you have likely experienced frustration from repeatedly seeing the error message below upon hitting “Close & Apply” or refreshing your data...
2022-08-10 (first published: 2022-07-19)
238 reads
Storing sp_BlitzIndex to a Table Between Reboots
I mentioned in my New Database Job – The 90 Day Plan blog how I have a trick for storing index usage stats up until close to the next reboot...
2022-08-10 (first published: 2022-07-19)
441 reads
T-SQL Tuesday 153: The Conference Changed Everything For Me
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Kevin Kline (blog | twitter) asks us to talk about an...
2022-08-10
7 reads
Daily Coping 9 Aug 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-08-09
20 reads
The Conference of the Year–T-SQL Tuesday #153
It’s the second Tuesday of the month and it’s time for T-SQL Tuesday. This one is hosted at my request by a good friend, Kevin Kline. Kevin has been...
2022-08-09
21 reads
Visiting with DBAs at midnight : T-SQL Tuesday #153
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our host for this month’s episode of ... Continue reading
2022-08-09
18 reads
[How-To] SSRS migration
Good evening. Today’s episode is coming to you from my home office, where I feel motivated to write a blog in the comfort of my home. Today we will...
2022-08-08 (first published: 2022-07-26)
1,043 reads
Common Issues with SQL Server Backups
I absolutely love talking about SQL Server backup and restores. It is one of my favorite sessions to give at user groups and conferences all over the world. I’ve...
2022-08-08
26 reads
Daily Coping 8 Aug 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-08-08
31 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...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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...
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