Creating SQL Containers from a Dockerfile
I’ve been playing around with SQL containers on Windows Sever 2016 a lot recently and well, building empty SQL containers...
2017-02-14 (first published: 2017-02-08)
3,329 reads
The DBA Who Came In From The Cold
Monday Coffee 2017-02-06
A lot’s been said about last week’s Gitlab outage so I’m not going to go over the details here but...
2017-02-06
502 reads
Friday Reading 2017-02-03
2017 is trundling along now, this week I’ve been reading…
The GitLab incident report
We’ve all had that moment of “what did...
2017-02-03
321 reads
SQL Containers and Networking
I recently talked with the guys over at SQL Data Partners on their podcast about SQL Server and containers. It...
2017-02-10 (first published: 2017-02-01)
1,908 reads
Monday Coffee 2017-01-30
Wow, what a week last week was.
The biggest thing that happened was that I got a session at SQL Saturday...
2017-01-30
567 reads
Friday Reading 2017-01-26
Is it really still January? It seems like this month is dragging on a bit. Anyway, this week I’ve been...
2017-01-27
394 reads
Transaction log shipping in SQL Server on Linux
SQL Server on Linux has been out for a bit now and I’ve played around a little (see here) but...
2017-01-30 (first published: 2017-01-25)
2,096 reads
Monday Coffee 2017-01-23
I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets...
2017-01-23
304 reads
Friday Reading 2017-01-20
Been an interesting week! My site has had the most views ever (so chuffed) and during all that I’ve been...
2017-01-20
519 reads
The two types of IT worker
Last week I published this post about something a colleague noticed when playing around with a SQL Server instance running...
2017-01-20 (first published: 2017-01-17)
2,869 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
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...
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