Alas, Poor Snapshot, I Knew Him Well (Question Of the Day)
My latest question of the day is up, this one called Alas, Poor Snapshot, I Knew Him Well. If you’ve...
2014-03-20
498 reads
SQLAndy
Submitting PASS Summit Sessions
I’ve been thinking for a while about what to submit for this year. I knew I wanted to have one...
2014-03-19
634 reads
Why Am I Here? You’re On Retainer
That’s just one of about a hundred great lines from episode 1 of Farmed and Dangerous. A company with the...
2014-03-19
609 reads
A Nicely Made Smoke Detector
This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a...
2014-03-19
663 reads
Reminder: Orlando Code Camp Is This Weekend (March 22, 2014) and It’s Not Just For Developers!
I’ll be attending the Orlando Code Camp this weekend. I know it says “code”, but there is a SQL Server...
2014-03-18
528 reads
A Minute About Minute Key
You may have seen these minuteKey boxes at your local home supply store (Lowes has it near me) that let...
2014-03-18
718 reads
Rodney Landrum Presenting at oPASS on March 20, 2014
Almost time for another meeting! This month Rodney Landrum is presenting Data Analytics and the DBA – Using PowerView to Uncover...
2014-03-17
511 reads
Some Notes On Writing A Question Of The Day
I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest...
2014-03-13
465 reads
You Broke My Tail Light
That’s the first thing I heard when I answered the phone recently. I was working on an change I needed...
2014-03-13
732 reads
Webinar Today at 3pm
I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s...
2014-03-13
388 reads
Blogs
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...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
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