More Private Clouds
Steve thinks that the growth of private clouds make sense, especially as more companies turn to platform engineering.
2024-02-03
101 reads
Steve thinks that the growth of private clouds make sense, especially as more companies turn to platform engineering.
2024-02-03
101 reads
tarrion – n. an odd interval of blankness you feel after something big happens to you bt before you feel the resulting emotional reaction – stunned by a sudden...
2024-02-02
83 reads
SQL Server Central is changing their policy to respond to the increased use of AI technologies.
2024-02-02
347 reads
Recently I was doing a demo and a customer asked how I had linked my commit in Azure DevOps to the work item that existed. It’s easy, and tldr;...
2024-02-02 (first published: 2024-01-19)
143 reads
2024-02-02
375 reads
I got a message recently that SSM S19.3 is out. I am wary of major versions, especially with a few add-in tools, but I have tended to try and update SSMS regularly when it patches, which is about once a quarter. As I checked my desktop, I saw I was still on 19.1 (my laptop […]
2024-02-02
421 reads
This week I attended THAT Conference in Round Rock, just outside Austin, Texas. This was my second time attending the conference, which is a very unique. The conference runs...
2024-02-01
36 reads
2024-01-31
412 reads
You mind can influence your body. Maybe. A study Steve found says that could be true, but he certainly thinks it can influence your attitude and how you respond to situations at work.
2024-01-31
137 reads
Thanks to everyone that came to my talk at THAT Conference. The deck is here, if you want to download it and use it as a resource, or to...
2024-01-29
27 reads
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
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