Working with People
One of the more important things that we can do as a professional is learn to work we well with others.
2019-07-30 (first published: 2015-09-09)
395 reads
Editorial
2015-09-08
162 reads
What Kind of DBA Are You?
Are you a do-it-all DBA, or do you specialize in one aspect of database work?
2015-09-07
316 reads
NoSQL inside SQL Server
This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.
2015-09-07
297 reads
Adjusting Model
This Friday Steve Jones looks at the topic of defaults and whether you use the model database to adjust yours.
2015-09-04
101 reads
The Case for Upgrading
When is it worth upgrading your SQL Server? It's a question Steve Jones explores today.
2015-09-03
228 reads
2015-09-02
755 reads
Software Estimates
It seems the software industry doesn't do a good job of planning and estimating software development efforts.
2015-09-01
191 reads
No More Foreign Keys?
Does it make sense to avoid FKs for use other architectures in software development? Steve Jones isn't sure a a general rule this is the case.
2015-08-31
337 reads
2015-08-31
296 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