dataMinds Connect 2023 – Raiders of the Lost ADX slides
You can find the slides for the session that I gave with Johan at dataMinds Connect 2023 at GitHub. As usual, the event was amazing. A lot of great...
2023-10-12
25 reads
You can find the slides for the session that I gave with Johan at dataMinds Connect 2023 at GitHub. As usual, the event was amazing. A lot of great...
2023-10-12
25 reads
How To Gain Access To SQL Server When No DBA
When I showed a draft of this article to a friend of mine, to...
2023-10-11 (first published: 2023-09-22)
905 reads
Database professionals of the world – I have a question. Has your organization defined service level agreements (SLAs) for your data estate? I’m talking specifically the Recovery Point Objective...
2023-10-11 (first published: 2023-09-18)
240 reads
Microsoft Fabric is an awesome product that has now been in public preview for five months. If you are not familiar with it, check out my recent video where...
2023-10-11
229 reads
I left home last Tuesday for work, heading to New Jersey for work. Over the weekend, I took a side trip to see my daughter play volleyball at university,...
2023-10-09
28 reads
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...
2023-10-09
15 reads
As many of you know, I was diagnosed with ALS or Lou Gehrig’s disease a couple of years ago. Since then, I have 9 made it a personal mission...
2023-10-09
23 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking quite a bit about security. Do we really know how secure our SQL Servers are?...
2023-10-09 (first published: 2023-09-26)
867 reads
If you happen to be using C# there is a very easy way to set your application up to take advantage of Read-Only replicas.
Using this connection string: (Some portions...
2023-10-09 (first published: 2023-09-18)
1,544 reads
ringlorn – adj. the wish that the modern world felt as epic as one depicted in old stories and folktales – a place of tragedy and transcendence, of oaths...
2023-10-06
127 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
BCA KCP Buaran Raya Telpon/WA:0821•3111•185 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA KCU THAMRIN Telpon/wa:0813.7887.595.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng,...
Komplek Balikpapan Super, Jl. Jenderal Sudirman Blok, Blok F23 & 25, Gn. Bahagia, Kecamatan...
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