If You Aren’t Measuring It, You Can’t Manage It
It sounds simple and logical doesn’t it. One could say it is common sense right? How many of us are...
2011-08-08
526 reads
Blog Posts
Money, Transparency, and Community Events
I’m going to ramble today. This is a complex topic and I think you’ll see by the end that I...
2011-08-08
910 reads
PowerPivot – Creating KPIs
Probably one of the most anticipated additions to the latest version of PowerPivot is the ability to create KPIs. PowerPivot...
2011-08-08
2,812 reads
Putting a Database into Single User Mode
I was recently discussing with a group of budding DBA’s how you go about performing a restore of database. They...
2011-08-08
1,349 reads
Replication Agent Failure
I recently spent several days investigating a replication failure. Finding the answer specific to my problem was difficult, so I...
2011-08-08
7,955 reads
S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to...
2011-08-08
577 reads
S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to the post. It is quite important that a more...
2011-08-08
7 reads
Security Is Your Responsibility
My primary responsibility at my organization is no longer to be the security architect and incident response team lead. I...
2011-08-08
952 reads
SQL MCM Training – Day 0
For the next 3 weeks I'm in Bellevue/WA for the SQL MCM training provided by Paul
Randal, Kimberly Tripp, and Bob...
2011-08-08
646 reads
SSRS Export En Masse
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found...
2011-08-08
2,540 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