Setting up SQL Server replication in containers
Last week I saw a thread on twitter about how to get replication setup for SQL Server running in a...
2018-12-13
840 reads
The DBA Who Came In From The Cold
Attaching databases via a dockerfile – UPDATE
This has been bugging me for a while but I just haven’t had a chance to get around to revisiting...
2018-12-11
180 reads
Running a SQL Server Azure Container Instance in a virtual network
Up until now Azure Container Instances only had one option to allow us to connect. That was assigning a public...
2018-10-04
346 reads
Running SQL Server 2019 CTP in a Docker container
If you’ve been anywhere near social media this week you may have seen that Microsoft has announced SQL Server 2019.
I...
2018-10-04 (first published: 2018-09-25)
4,423 reads
Taking the Linux plunge – Update
It’s been a couple of weeks now since I took the plunge and bought myself a Dell XPS 13 running...
2018-08-10
302 reads
SSL Provider error 31 when connecting to SQL in a docker container
I recently bought a Dell XPS 13 running Ubuntu 16.04 and ran into an issue when connecting SQL Operations Studio...
2018-08-06
711 reads
Evening or morning poll results!
And the results of the poll are in!
Evening just scraping it! So there’s a pretty even mix out there, interesting....
2018-08-03
235 reads
Are you a morning or evening person?
I am not a morning person. I’ve really tried but there’s something in me that just stops me from getting...
2018-07-30
311 reads
Friday Reading 2018-07-27
Phew, I’m not going to complain about the hot weather…I’ll miss it when it’s gone.
Linux Load Averages: Solving the Mystery
Good...
2018-07-27
331 reads
Creating SQL images in Azure with ACR Build – Part Two
EDIT – 2018-10 – ACR Build is now known as ACR Tasks
In Part One I detailed how we can use ACR Build...
2018-08-09 (first published: 2018-07-25)
1,518 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
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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