Review: Gamma Seal Lids
Last weekend I needed to go to Home Depot to get a five gallon bucket and a lid so we...
2011-11-22
709 reads
SQLAndy
Book Review: Highest Duty, My Search For What Really Matters
Highest Duty, My Search For What Really Matters by Chesley Sullenberger is the autobiography of the pilot who landed Flight...
2011-11-21
894 reads
Managing By Walking Around
For a long time a core piece of my ‘style’ has been to wander the halls a couple times a...
2011-11-18
608 reads
Culture Cubes
A while back I posted about Culture Posters, a technique for trying to build your culture by writing down the...
2011-11-17
817 reads
Distance Decreases Stress
When I’m managing I tend to absorb the stress that my teams feel. It’s my job to help them be...
2011-11-17
635 reads
Identify Risk Early
One of the mistakes I see a lot is teams failing to identify risks early and failing to leave time...
2011-11-16
482 reads
The Calendar Driven Organization
I’ve had jobs where I might have one meeting a week, I’ve had a few with some type of daily...
2011-11-15
741 reads
A Plug for IT Pro Camps
Here is something else that started in Florida (doesn’t everything?), a series of events along the lines of Code Camp...
2011-11-14
581 reads
Lists of Words You May Not Know
The Merriam-Webster site has an interesting list of Top 10 Lists, ranging from commonly confused words to things you didn’t...
2011-11-14
643 reads
Culture Shock
The work I’m doing right now has nothing to do with SQL Server, and while it deals with technology, it’s...
2011-11-14
693 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
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...
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