Logo Selected for SQLRally
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
384 reads
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
384 reads
The ‘Summit Preview’ edition, this time around it features speakers from the upcoming PASS Summit with each doing a one...
2010-08-11
341 reads
Consider this one a thinking out loud post more than most. We’ve had an explosion of speakers in the SQL...
2010-08-10
229 reads
MS just announced this publicly last week, it’s a Visual Studio product that seems to be geared towards the not-quite-developer...
2010-08-10
355 reads
Kendal Van Dyke blogged about it last week here, we ended up with 3 great designs to pick from for...
2010-08-09
333 reads
One of the things I think we don’t do well sometimes – in generally – is set fair expectations with regards to...
2010-08-09
658 reads
Over the course of my life I’ve lived in a few different places; small home, apartment, pup tent, large tent,...
2010-08-06
535 reads
Being a good mentor is hard, perhaps harder than being a parent, because with children it’s fair to share with...
2010-08-05
390 reads
In addition to being at at #40 as an attendee, I also had Don Gabor there to take a look...
2010-08-04
333 reads
Had a reasonably uneventful four drive to Miramar Friday, arriving in time to check in at the hotel and then...
2010-08-03
526 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...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
This week my BI Developer colleague proudly showed me a new Power BI report...
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