One of the options that I completely missed with the new go-sqlcmd CLI tool is the ability to spin up a container running SQL Server. Let’s have a look...
2023-06-02 (first published: 2023-05-19)
502 reads
The second VMUG Ireland event of the year is taking place on the 15th of June in Belfast! When: Thursday 15th of June @ 2pm until 5pm Where: Ormeau...
2023-05-16
23 reads
The schedule for EightKB 2023 Edition has been announced! We’re kicking off at 1pm UTC on May the 24th…here’s the schedule: – N.B. – If you click on the...
2023-04-26
47 reads
A while back I posted a blog on how to recover data with crash consistent snapshots. Snapshots are pretty handy in certain situations so I thought I’d show you...
2023-04-26 (first published: 2023-04-11)
143 reads
Hello all, I’ve been speaking to various people about EightKB and there does seem to be a misunderstanding out there about the topics of submissions that we are looking...
2023-04-05
24 reads
Today we have announced the schedule for Data Céilí 2023 and have opened registration! We have two days of great sessions for you, the 8th of June will have...
2023-04-03
25 reads
A while back I wrote a post on how to retrieve the SQL Server images in the Microsoft Container Registry (MCR). It’s pretty simple to check the MCR but...
2023-02-27 (first published: 2023-02-17)
406 reads
When we talk about snapshots of SQL Server there are two types, application consistent snapshots and crash consistent snapshots. Application consistent snapshots require freezing IO on a database allowing...
2023-02-08 (first published: 2023-01-25)
466 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2023…happening on May 24th. We’ve open our call for speakers, you can submit here: – https://sessionize.com/eightkb-may-2023/...
2023-01-30 (first published: 2023-01-23)
162 reads
Today we have launched Data Céilí (pronounced kay-lee) Dublin 2023, Ireland’s free, community led, Microsoft Data Platform event. We tried in 2020 but certain global events prevented us from...
2023-01-16 (first published: 2023-01-09)
227 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...
Jl. Ruko Cendrawasih Square No.8, Sambung Jawa, Kec. Mamajang, Kota Makassar, Sulawesi Selatan 90134
BCA KCP Percetakan Negara Telpon/wa:0813.7887.595.Jl. Percetakan Negara No.223 C, Rawasari, Kec. Cemp. Putih, Kota...
BCA KCP Pasar Kenari Telpon/wa:0813.7887.595.Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, Kenari, Kec....
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