Presenting at SQLSaturday #16
I’ll be attending SQLSaturday #16 in South Florida on August 8th and doing two presentations, one on statistics and one...
2009-07-13
331 reads
I’ll be attending SQLSaturday #16 in South Florida on August 8th and doing two presentations, one on statistics and one...
2009-07-13
331 reads
I finished up reading Traffic: Why We Drive the Way We Do by Tom Vanderbilt last week and enjoyed it....
2009-07-10
368 reads
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
2009-07-09
5,254 reads
I was having a discussion with Brian Knight yesterday about whitepapers and thought I’d share some of it – from my...
2009-07-09
436 reads
If you haven’t seen the news yet we’ve got something new on the schedule this year – a 2 hour seminar...
2009-07-08
563 reads
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
2009-07-07
7,525 reads
Russ Fustino from Microsoft just sent me the link to episode #3 that was filmed at SQLSaturday #14 in Pensacola....
2009-07-06
485 reads
Since the beginning of SQLSaturday I’ve covered most of the news here on my blog, beginning this week I’ll be...
2009-07-06
464 reads
Read the Declaration of Independence and then it’s time for fireworks and grilling, maybe some apple pie too!
2009-07-03
504 reads
Rolling Thunder ($7.99 @ Amazon) by John Varley is the third book in the series. I previously reviewed Red Thunder and...
2009-07-02
704 reads
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Jl. Letjen S. Parman No.135, Kestalan, Kec. Banjarsari, Kota Surakarta, Jawa Tengah 57133
Telp/WA.0821°3111°179 Jl. Tebet Raya No.25 B Blok CI, Tebet Tim., Kec. Tebet, Kota Jakarta...
Jl. Dr. Rajiman No.197, Jayengan, Kec. Serengan, Kota Surakarta, Jawa Tengah 57152
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