The Red Gate Way…
As companies go, Red Gate is a little different. That is readily apparent in our tools and the philosophy behind...
2014-08-20
751 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
Getting the Word Out
A discussion that I’ve frequently had with organizers of SQL Saturday events, our own people here at Red Gate, authors,...
2014-08-19
561 reads
A Full Day of Query Tuning
I’m excited to able to say that I’ve been given the opportunity to put on a full day workshop at...
2014-08-14
805 reads
Say Thank You
I was approached by a man at SQL Bits who only wanted to thank me for blogging. He said, “I...
2014-08-13 (first published: 2014-08-06)
8,114 reads
Speaker of the Month: August 2014
Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...
2014-08-08 (first published: 2014-08-01)
7,050 reads
Challenge Accepted
There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these:
Oh...
2014-07-23
706 reads
Victims of Success
I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how...
2014-07-21
670 reads
Execution Plan Details
I wouldn’t say it’s common knowledge that you should look at execution plans when tuning queries, but it’s not exactly...
2014-07-17 (first published: 2014-07-15)
10,306 reads
Speaker of the Month, July 2014
Another month another bunch of great presentations. I almost don’t want to do this any more. It’s hard. I sit...
2014-07-11
565 reads
Worst Day of a DBAs Life
Red Gate Software is running a campaign around coping with the worst day of a DBAs life. We’ve been posting...
2014-07-08
867 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