Docker Desktop is a great product imho. The ability to run Windows and Linux containers locally is great for development and has allowed me to really dig into SQL...
2019-07-03 (first published: 2019-06-19)
6,698 reads
In a previous post I went through how to deploy SQL Server running in an Azure Container Instance using Terraform. In that post, I used hardcoded variables in the...
2019-05-28 (first published: 2019-05-15)
307 reads
A couple of weeks ago I attended John Martin’s (t) Terraform pre-con at Data in Devon. I’ve been hearing about Terraform recently so was excited to check it out....
2019-05-08
133 reads
I’ve previously talked about using named volumes to persist SQL Server databases but in that post I only used one...
2019-03-21
424 reads
In a previous post I ran through how to create a custom SQL Server Helm chart.
Now that the chart has...
2019-02-27
419 reads
A while back Microsoft moved all their SQL images to their new registry mcr.microsoft.com which means that we can no...
2019-02-22
170 reads
In my previous post I went through how to deploy SQL Server to Kubernetes using Helm in which I used...
2019-03-07 (first published: 2019-02-20)
3,028 reads
Last week I was working on my Azure Kubernetes Service cluster when I ran into a rather odd issue. I’d...
2019-01-30
342 reads
In previous posts I’ve run through how to deploy sql server to Kubernetes using yaml files. That’s a great way...
2019-01-29 (first published: 2019-01-16)
2,670 reads
I’m always a fan of tools that can make my life easier.
One tool that I’ve recently come across is...
2019-01-09
172 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...
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