How many environments?
This Friday Steve Jones looks at the setup for your software pipeline. He's wondering how complex it is with how many separated environments.
2015-08-14
149 reads
Editorial
The Tally Table
The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?
2025-12-26 (first published: 2015-08-13)
813 reads
Business Pressures
The business pressures can often change how we work, or even how we build our software. A few notes on Github from Steve Jones.
2019-09-10 (first published: 2015-08-12)
280 reads
Making Guesses
When working on a new database, Steve Jones hesitates to make too many guesses, or at least, too many exact guesses.
2021-03-05 (first published: 2015-08-11)
214 reads
Deploy from VCS
Are you brave enough to redeploy your applications from a VCS? Have you really captured all your code?
2015-08-10
89 reads
2015-08-10
124 reads
Teambuilding
This week Steve Jones wants to know about your efforts to create bonds with co-workers and build a team. Does your company do anything to help facilitate this?
2015-08-07
114 reads
2015-08-06
252 reads
Cloud Security Issues
The cloud is always going to be a challenge for security, but is it harder or easier than on premises? Steve Jones has a few comments.
2015-08-04
142 reads
2015-08-03
247 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
Kantor BCA KCP Ungaran Telp/wa 085169998803
Telp/wa 085169998803 Ungaran Square, Jl. Gatot Subroto Blok A3-A4, Banaran Barat, Bandarjo, Kec. Ungaran...
BCA KCP ITC Permata Hijau HUB/WA 08218573837
Grand Permata Hijau Tipe Zamrud No. 12 & 14, Jl. Arteri Permata Hijau, Daerah...
BCA KCU MANGGA DUA RAYA Hub/Wa 08216366654
Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol, Kec. Pademangan, Jkt...
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