SSC Site Upgrade
I see they finally rolled out the new site. Lots of annoying quirks so far, the biggest for me is...
2007-09-23
1,351 reads
Blog Posts
Wayne Synder Elected President of PASS
Congratulations to Wayne on becoming President! I've known him for years and you couldn't ask for a guy with more...
2007-09-23
1,423 reads
SQLServerCentral.com - V3!
It's done, it's out, and check it out!!!
I guess if you got here, you've probably noticed π
This was a fairly...
2007-09-22
1,402 reads
Notes from PASS - Part 3
Today was interesting. I headed for breakfast and after a few stops to chat with friends, wound up sitting with...
2007-09-21
1,471 reads
Tips for Presenters
I haven't seen a lot of sessions at the 2007 Summit, but I did go through 4 or 5 across...
2007-09-21
1,396 reads
Day 1 at the Summit
I was late, not getting up quick enough and then fighting traffic into the city. From there I did a...
2007-09-19
630 reads
Notes from PASS 2007 - Part 2
Denver is a great location for a conference. The convention center is two blocks from the 16th street mall - must...
2007-09-19
530 reads
Technical Speaking - Again
One of the points mentioned in the volunteer meeting on Tuesday was that it makes a lot of sense to...
2007-09-19
546 reads
THE Reception
After the PASS opening, which I dropped in long enough to get a beer, we had the SQLServerCentral.com party.
It seemed...
2007-09-19
605 reads
Notes from PASS 2007
I attended the morning portion of the volunteer/chapter meeting today and got to put some names with faces for some...
2007-09-18
583 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan LaΕ‘, CIO at HOPI, about what deploying a data agent...
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...
Forums
BCA KCP Fatmawati Telpon/wa:0813.7887.595
BCA KCP Fatmawati Telpon/wa:0813.7887.595.Jl. Komp. Rs. Fatmawati No.1, Cilandak Bar., Kec. Cilandak, Kota Jakarta...
BCA KCU MOJOKERTO TLP/WA 083800209966
Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto, Jawa Timur 61313
BCA KCP Prapen TLP/WA 083800209966
Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
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