2014-09-02
257 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
Crosstabs over Pivots
I wrote about a basic PIVOT query recently. It’s an interesting way to write a query and turn row data...
2014-09-02
2,053 reads
I did my part – Helping others
Let’s raise some money, people.
TL;DR Donate to Doctors Without Borders, the Argenis Without Borders campaign.
What started out as a joke...
2014-09-02 (first published: 2014-08-28)
5,401 reads
2014-09-02
2,063 reads
Better Presentations–Hide those Windows
This is part of a series of tips for speakers to make your presentations better.
I wanted to give some specific SQL...
2014-09-01 (first published: 2014-08-26)
7,294 reads
2014-09-01
78 reads
2014-09-01
2,419 reads
Hooks
Building hooks from your software into enterprise monitoring systems is prudent, and might save you from a few late night phone calls.
2014-08-29
182 reads
2014-08-29
1,537 reads
Reverse Engineering Disasters
Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.
2014-08-28
197 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
Cara buka blokir bank jago yang terkunci
dapat dilakukan dengan menghubungi layanan pelanggan Tanya Jago di 1500 746, WhatsApp resmi (+62813_2244_602...
Cara membuka blokir bank jago yang terkunci
Anda dapat menghubungi layanan Tanya Jago melalui WhatsApp resmi (08132244602 / 08217142959), atau call...
Cara membuka blokir bank jago
Cara membuka blokir Bank Jago dapat dilakukan dengan menghubungi Tanya Jago via WhatsApp resmi...
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