Nothing Scheduled
As of right now, my United account has no flights booked. My Hilton Honors account has no hotel rooms reserved....
2014-04-16
622 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
2014-04-16
1,433 reads
2014-04-15
1,638 reads
An Open Letter to Brogrammers
It’s not in the language I would write it in and it’s not necessarily safe for work, but it gets...
2014-04-11
787 reads
If or When?
Are data breaches a question of if they will happen to you or when will they happen to you?
2014-04-10
172 reads
Problems with Big Data
Today Steve Jones notes that Big Data isn't a panacea. It's not going to just solve all problems.
2014-04-09
228 reads
Vote for me at SQLBits
SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted...
2014-04-09
820 reads
Lobbying for Change
The Connect system from Microsoft doesn't work that well, but that doesn't mean we shouldn't continue to press Microsoft for change.
2014-04-08
130 reads
One week to SQL Intersection
You still have time to grab the boss and convince him to invest in you. Show what you’ve learned in...
2014-04-08
742 reads
T-SQL Tuesday #53–Why So Serious?
It’s an interesting topic this month for T-SQL Tuesday #53. When I read Matt Velic’s invitation, I became intrigued. I...
2014-04-08
815 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
How Important Is a Google Knowledge Panel for Online Reputation?
I’ve been learning more about the google knowledge panel and it seems like one...
Which Wireless Credit Card Terminal Works Best for Small Businesses?
I’m currently researching the best wireless credit card terminal for a growing business and...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers