2015-12-01
151 reads
Editorial
NoSQL Complaints
One NoSQL database is not necessarily like another. Steve Jones notes that some of the complaints out there will likely be easily overcome.
2015-11-30
195 reads
Giving Thanks
Phil Factor is gratified to see just how much many developers and DBAs give back to their technical communities as well as society in general.
2015-11-30
48 reads
2015-11-27
78 reads
Just Say No
Steve Jones reminds us that we must manage our time, and learn to do so despite the demands placed on us.
2015-11-25
545 reads
The Biggest Data Breach (For Now)
JP Morgan suffers the largest data breach for a financial institution, but Steve Jones doesn't think this record will stand for long.
2015-11-24
187 reads
2019-08-02 (first published: 2015-11-23)
531 reads
2015-11-23
131 reads
Early Adopters
Today we have a guest editorial from Andy Warren that looks at those that run software early in its lifecycle.
2015-11-20
93 reads
Shrinking the Budget
Most DBAs don't get involved with budgets at work, but we are affected by them. Steve notes you might want to understand how budgets work.
2015-11-19
138 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