Need a Blogging Nudge? Try Plinky
If you want to blog you need ideas, something to write about, and sometimes that leads to the blank stare...
2012-04-09
716 reads
SQLAndy
Steady State vs Tempo
It’s helpful at work to understand things at work change from time to time and to consider the impact on you...
2012-04-06
999 reads
Stress Thoughts-Part 7
I’m going to finish up my thoughts on stress by talking about the philosophy I’ve evolved, some of the tricks...
2012-04-04
826 reads
Stress Thoughts-Part 5
Stress affects everyone, but it’s easy to forget that. Once you get sensitized to it, it’s amazing to pick up...
2012-04-02
725 reads
Announcing SQLSaturday #175–In Flight Edition
One of the things I like about SQLSaturday is that it’s a place to try new ideas. This year on...
2012-04-01
688 reads
Presenting at SQLSaturday #107 in Houston in April 2012
I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012....
2012-03-31
1,520 reads
Stress Thoughts-Part 4
Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes...
2012-03-30
1,612 reads
Stress Thoughts-Part 3
It’s not fair. I hear it a couple times a day. Sometimes they are right, sometimes not, but it’s how...
2012-03-28
688 reads
Stress Thoughts–Part 2
One thing I’ve learned is that even losing one hour of sleep or just not sleeping well degrades my ability...
2012-03-27
718 reads
Stress Thoughts–Part 1
If I had to tell you that one thing I’ve gotten better at in the past 5 years it would...
2012-03-26
719 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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