Declining Work for Mental Health
A busy year got a little too busy for Steve and he is taking steps to improve his work life balance.
2023-10-20
159 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
SQL Prompt Quick Access to Helper Code
We’ve been doing some events as part of the Redgate Roadshow, and at one of the events, we had a customer ask about something that we demo’d. This post...
2023-10-20 (first published: 2023-10-02)
244 reads
The Year in Travel
Here’s my year, which is pre-populated with a couple more trips coming up in November. Those should be all, as I’ve declined to go back to the UK in...
2023-10-20
18 reads
2023-10-20
462 reads
Practicing (Annoying) Better Security
Steve has had to change his security, which is good, but annoying.
2023-10-18
164 reads
2023-10-18
351 reads
2023-10-16
511 reads
The Code Review Checklist
Code reviews are a part of many software development processes, but not used that often with database work. Today Steve has a few thoughts and asks if you have any formal code review process.
2023-10-16
481 reads
2023-10-14
93 reads
SQL Saturday Boston 2023 Slide Decks
Thanks to everyone who came to my sessions at SQL Saturday Boston 2023. I’ve added the decks to the schedule, so you can click my session and will see...
2023-10-14
53 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 KCU BINTARO Hubungi.0821•3111•185
BCA KCU BINTARO Hub.0821•3111•185 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
BCA KCP Citra Towers HUB/WA ,08216977749
Citra Towers, North Tower Lt 01 No. Unit 01/GF, Jl. Benyamin Suaeb Kavling A6,...
BCA KCP Majenang Telp/wa 085169998765
Telp/wa 085169998765 Jl. Diponegoro No.318, Lebaksari, Sindangsari, Kec. Majenang, Kabupaten Cilacap, Jawa Tengah 53257
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