The Way0utwest Joker #SeattleSummitMoments
I work for Redgate, who has been a great sponsor of the Summit in the past and now is charged with stewarding the event into the future. This post...
2022-11-04
13 reads
Blog Posts
Validating Backups: PGSQL Phriday #002
It’s time again for the another PGSQL Phriday, this time, the question has been asked: How do you do PostgreSQL backups? Honesty up front. I’m very much just beginning...
2022-11-04
14 reads
Daily Coping 3 Nov 2022
Today’s coping tip is to ask yourself, will this matter a year from now? It’s easy to get caught up in short term things. I’m behind on a few...
2022-11-03
10 reads
The PASS Data Community Summit
I’m looking forward to attending the PASS Data Community Summit this year in Seattle, Washington. I’m also glad to have the opportunity to speak with fellow Microsoft MVPs Josh...
2022-11-03
16 reads
The PASS Summit 2022 DevOps Devour Hour from Redgate
At the Data Community Summit this year, Redgate is hosting a couple of lunchtime sessions, the Summit 2022 DevOps Devour Hour. A creative name, for sure. These are Thursday...
2022-11-03
16 reads
Create a Community Event at the Summit
There are a few community events at the Summit this year, but fewer than in the past. I know we’re all rebooting our conference experiences, and that can make...
2022-11-02
9 reads
Daily Coping 2 Nov 2022
Today’s coping tip is to be kind to yourself today. Remember, progress takes time. I am usually good at this. I work on many things that take time, so...
2022-11-02
8 reads
Getting Help Online
I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...
2022-11-02 (first published: 2022-10-24)
149 reads
Organize Your Tabs in SQL Server Management Studio
I blogged about this in August, but wanted to do this video as well: Thanks for reading and/or watching! Kevin3NF Follow @Dallas_DBAs
The post Organize Your Tabs in SQL Server...
2022-11-02
139 reads
Tales From The Field Weekly Wrap Up for the Week of 10-17-2022
Hello Dear Reader! I hope you had a fantastic weekend. This weekend we celebrated my parents 50th wedding anniversary, my oldest daughter flew into town for an early birthday,...
2022-11-02 (first published: 2022-10-24)
115 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 Hubungi Call Center Flip Indonesia
?????????????? ???????? ???????????? (????) ????????.???? +?????????????????????? ???????? ????????????????????????, ?????????????? ?????????????? ?????????? ???????????????? ?????????????? ??????????????...
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...
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