We’re a little delayed this month. Both the host and I forgot about this. So far in June, I’ve been in Fort Lauderdale, Las Vegas, Denver, and Cambridge for...
2023-07-10 (first published: 2023-06-20)
231 reads
My number one reason that you should test your backups is to make sure you know how to restore/recover. The absolute worst time to learn how to restore is...
2023-07-10
16 reads
The call for speakers is open! We’re always excited to have experienced and past speakers return (Rob Volk!), but if you’re a first time or relatively new speaker just...
2023-07-07
42 reads
This is documented, somewhat, but I wanted to put this down for myself, as the I don’t love the docs and they are hard to sort through. Flyway is...
2023-07-07 (first published: 2023-06-26)
138 reads
It’s time for our monthly blog party and thanks to Gethyn Ellis ( t | b) for hosting this month. Gethyn asks us for the best Career
The post T-SQL Tuesday #163...
2023-07-07 (first published: 2023-06-21)
249 reads
I blogged about Microsoft Fabric a few weeks ago, and wanted to follow up with an introduction video that covers the basics so hopefully you will understand the major...
2023-07-05 (first published: 2023-06-19)
500 reads
(for your reading pleasure, written by Jules. –ed) We have all had that sinking feeling of defeat: you’ve just finished explaining a very important and highly technical thing to...
2023-07-05 (first published: 2023-06-20)
409 reads
I was on the Data Exposed: MVP Edition show recently, talking about SQLCMD. I’ve written a few articles on the topics as well, and a blog post about setting...
2023-07-05
31 reads
This all started because I wanted to follow Tracy’s directions on setting up Ola for index maintenance in Runbooks. I couldn’t set up the automation account permissions unless I...
2023-07-03 (first published: 2023-06-15)
235 reads
I am super excited to announce that I have been selected to speak at SQL Server Live! in Orlando in November. I have selected to present two sessions, which...
2023-07-03
16 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Kompleks Perumahan, Jl. Raya Taman Kopo Indah 2 No.32 Blok I B No. 31,...
The City Tower, Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec....
Jl. Dulatip No.26 & 26A, Kb. Jeruk, Kec. Andir, Kota Bandung, Jawa Barat 40181
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