You Can Still Vote for PASS
If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.
2014-10-03 (first published: 2014-09-29)
485 reads
If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.
2014-10-03 (first published: 2014-09-29)
485 reads
2014-10-03
2,046 reads
I think learning to better test our software, including the database objects, is one of the ways in which we’ll...
2014-10-02
786 reads
Microsoft has released a final service pack for SQL Server 2008 R2, which many of you might want to install.
2014-10-02
219 reads
2014-10-02
1,655 reads
This editorial was orignally published on Dec 8, 2009. It is being re-run as Steve is on vacation. Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.
2014-10-01 (first published: 2009-12-08)
154 reads
2014-10-01
2,037 reads
How do you grow your career? Steve Jones has a few ideas on what you can do to both improve your skills and build your brand.
2014-09-30
274 reads
I said that I’d write about some good things PASS does, and I’ll make it a point to do so....
2014-09-29 (first published: 2014-09-25)
6,897 reads
It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.
2014-09-29
219 reads
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...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Jl. Dr. Sam Ratulangi No. 7, Kompleks Ratulangi Office Park Blok A3-A4, Mangkura, Kec....
Telp/wa 085169998803 Jl. Moch. Toha No.197, Cigereleng, Kec. Regol, Kota Bandung, Jawa Barat 40253
Blk. A, Jl. Perintis Kemerdekaan, Daya, Kec. Biringkanaya, Kota Makassar, Sulawesi Selatan 90241
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