Daily Coping 3 Mar 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-03-04
12 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Daily Coping 4 Mar 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-03-04
32 reads
DP-900: What’s a Region and an Availability Zone
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-04 (first published: 2022-02-16)
268 reads
Is the Time of the DBA Ending?
The DBA role might be changing, but Steve thinks this creates opportunities.
2022-03-04
421 reads
2022-03-04
361 reads
Redgate at SQLBits
Redgate and the Advocates are attending SQL Bits next week in London. I’m excited to see Grant and Kathi in person, as it’s been far too long since I...
2022-03-03
57 reads
Daily Coping 2 Mar 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-03-02
14 reads
Data Analysis Techniques
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-02
107 reads
2022-03-02
322 reads
The Test Mistake
Many developers have made mistakes that in test and development environments that customers notice. Using DevOps should help reduce these issues.
2022-03-02
213 reads
Blogs
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...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU KEBAYORAN BARU WhatsApp:08388331786
Wa 08388331786.Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru, Kota Jakarta...
BCA KCU MENARA BCA WhatsApp 08388331786
Wa 08388331786.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5, Menteng, Kec....
BCA KCU GAJAH MADA WHATSAPP 08388331786
Wa 08388331786.Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta Barat,...
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