I Am Grateful For
A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my...
2015-01-09
692 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Execution Plans, Performance Tuning and Rum
This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...
2015-01-06
1,083 reads
Speaker of the Month: January 2015
I love it that my first post of the new year is going to be Speaker of the Month. I’m...
2015-01-02
423 reads
“Pretty Plans vs. Performance” or “Grant Gets Pwned”
If you get an execution plan that looks like this:
I wouldn’t blame you for immediately thinking about query tuning. Especially...
2014-12-29 (first published: 2014-12-19)
6,158 reads
Speaker of the Month: December 2014
For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new...
2014-12-08
551 reads
Speaker of the Month: November 2014
I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...
2014-12-05
505 reads
PASS Summit 2014 Speaker Idol
For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015...
2014-11-13
779 reads
I’m Still Not on the Board
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
693 reads
PASS Summit 2014: WIT Luncheon
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
621 reads
Database Lifecycle Management
There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every...
2014-10-31 (first published: 2014-10-20)
6,979 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
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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