Call for Speakers - SQL Saturday Pittsburgh
SQL Saturday #315 in Pittsburgh (Oct 4th) is looking for speakers - if you've got a SQL topic you want to talk about, submit it and you may get to share with your peers.
2014-08-05
8,910 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
Call for Speakers in Sunny San Diego
If you're in Southern California, you should come to SQL Saturday #340 and speak at their event. If you want a late summer vacation, submit and come enjoy the event.
2014-08-04
8,341 reads
Using Views
Views can be a great way to abstract away details for clients, but they can also make development much more flexible.
2014-08-01
333 reads
Quick Tips–SQL Prompt Custom Aliases
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-30 (first published: 2014-07-24)
8,039 reads
2014-07-29
174 reads
Frustration with Bad Design
It can be very easy for technology experts to get frustrated when they see bad design and practices, but you must be careful with how you go about trying to influence change.
2014-07-28
23 reads
Frustration with Bad Design
It can be frustrating to deal with poorly implemented systems, but Steve Jones notes that you can't take things into your own hands.
2014-07-28
301 reads
Summer, Summer, Summertime
This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?
2014-07-25
107 reads
Quick Tips–SQL Prompt Aliases for Every Table
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-24 (first published: 2014-07-17)
9,803 reads
T-SQL–Converting Seconds to Time
I was working on a small piece of code the other day that was calculating the seconds for an event....
2014-07-23
1,487 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 Grogol Muwardi HUB/WA 08218573837
Jl. Dr. Muwardi I No.44, Grogol, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Tanjung Duren Hub/Wa 08218573837
Jl. Tanjung Duren Dalam III, Tj. Duren Utara, Kec. Grogol petamburan, Kota Jakarta Barat,...
BCA KCP Ruko Swadaya HUB/WA 08218573837
Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23, Kec. Grogol...
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