Memories from SQL Saturday Orlando 2021
A few memories from this past weekend, during the first live SQL Saturday event in the US this year. I’ve had plenty of plane flights this year, actually this...
2021-11-02
31 reads
Blog Posts
#PowershellBasics: Get a list of files from a directory.
I’ve got a project I’m working on at the moment and it includes a number of elements from my recent ... Continue reading
2021-11-01 (first published: 2021-10-21)
8,702 reads
A Live Conference Experience at Data Minds Connect 2021
Last week I was privileged to attend a live conference in Belgium. dataMinds Connect 2021 took place in Mechelen, just outside of Brussels. I had submitted months ago, was...
2021-11-01 (first published: 2021-10-25)
128 reads
Azure SQL Managed Instance CPU and RAM
With SQL Managed Instance you will need to consider your configuration requirements in terms of core count for the CPU and memory, which we all know that the MIN/MAX...
2021-11-01
105 reads
Daily Coping 1 Nov 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-01
11 reads
Log Analytics with Azure Synapse Analytics
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-01
31 reads
Log Analytics with Azure Synapse Analytics
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-01
22 reads
Log Analytics with Azure Synapse Analytics
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-01
78 reads
Log Analytics with Dedicated SQL Pools (Formerly SQL DW)
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-01
15 reads
Log Analytics with Dedicated SQL Pools (Formerly SQL DW)
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-01
49 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
Berikut ini cara mengatasi masalah lupa username( permata bank )
Cara buka blokir Bank Permata (rekening/ATM/mobile) dapat dilakukan melalui PermataTel di 1500-111, whatsapp, 0821"...
BCA KCP Pettarani Hub/Wa (08218573837)
Kompleks Perkantoran Pettarani, Jl. AP. Pettarani No.18, Tamamaung, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan...
BCA KCP Senen Telpon/wa:0813.7887.595
BCA KCP Senen Telpon/wa:0813.7887.595.Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....
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