Released with SQL Server 2016, Query Data Store was a game changer for performance tuning. Right from Microsoft’s website: The SQL Server Query Store feature provides you with...
2020-10-20 (first published: 2020-10-13)
544 reads
Thank you all for your service!
I was fortunate to have attended PASS Summit again this year. As an added bonus...
2018-11-11
171 reads
I was at SQL Saturday 723 in Rochester, NY last weekend. I was selected to deliver 2 sessions, and I...
2018-03-27
202 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2018-03-02
274 reads
This month’s topic: Folks Who Have Made a Difference
T-SQL Tuesday is a monthly blog party for the SQL Server community...
2017-11-14
297 reads
This month’s topic: Let’s get all Posh – What are you going to automate today?
T-SQL Tuesday is a monthly blog party...
2017-09-11
291 reads
Today I learned that you can configure tempdb in RDS!
One of the things we DBA’s do is configure tempdb to...
2017-08-28
1,040 reads
Beware the automated backup window when running native SQL Server backups in RDS
If you’ve ever fired up an RDS instance...
2017-08-04
2,290 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2017-06-13
326 reads
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-05-25 (first published: 2017-05-09)
1,663 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...
Jl. Samanhudi No.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah Khusus Ibukota...
Rukan Ekslusif Bukit Golf Mediterania, Pantai Indah Kapuk St No.17 Blok C, RT.7/RW.2, Kamal...
Blok A VI No, Jl. Parang Tritis Raya 3B-3C, Ancol, Kec. Pademangan, Jkt Utara,...
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