Half a Year
We're halfway through the 2015 year and Steve Jones has a few thoughts for you this holiday weekend.
2015-07-03
81 reads
Editorial
SSMS Maturity
Announcements recently for changes in SSMS mean that the tool many of us rely on is growing up.
2015-07-02
218 reads
Training Computer Scientists
What's the best way to enter this business? Steve Jones has a few thoughts on the traditional CS degree.
2015-07-01
249 reads
The Importance of Our Work
Work is important, and it's a large part of our lives, but Steve Jones notes we need to keep things in perspective.
2015-06-30
135 reads
Not a cloud to be seen
Phil factor find much to admire in the StackOverflow architecture. It is built on SQL Server, doesn't use microservices or the cloud. It all seems a bit retro, but it manages manage 440 million queries a day, peaking at 8500 queries per second, and never even breaks into a sweat.
2015-06-29
132 reads
2015-06-29
318 reads
2023-01-16 (first published: 2015-06-26)
439 reads
#SQLNewBlogger
Steve Jones talks about blogging today, how it can help your career, and how easy it can be to get started.
2015-06-25
141 reads
2015-06-24
610 reads
Skill Supply and Demand
Finding staff with the proper skills can be a challenge, and it might be a reason why you choose, or remain with, a particular technology.
2015-06-23
200 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
BCA KCP Gajah Mada Tegal Telp/wa 085169998765
Telp/wa 085169998765 Jl. Gajah Mada. 41A & 41B, Mintaragen, Kec. Tegal Tim., Kota Tegal,...
Kantor BCA KCP Gajah Mada Tegal Telp/wa 085169998803
Telp/wa 085169998803 Jl. Gajah Mada. 41A & 41B, Mintaragen, Kec. Tegal Tim., Kota Tegal,...
BCA KCP Senayan City Hubungi:0851•8812•0691
BCA KCP Senayan City Hubungi:0851•8812•0691 Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot...
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