Friday Reading – Speaking Mentors
A new project underway is Speaking Mentors. I think this is an amazing idea and the response that it’s had...
2018-02-09
398 reads
The DBA Who Came In From The Cold
SQL Server in Kubernetes on Docker for Windows
Last week Docker announced a feature that I’ve been looking forward to for a while: –
And sure enough, when I...
2018-02-07
1,437 reads
Giving back – Speaking Mentors
I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who...
2018-02-05
327 reads
Friday Reading 2018-01-26
It’s moving weekend! Hopefully two hard days and then I’ll be all settled in my new place. Cannot wait.
Inbetween packing...
2018-01-26
257 reads
Configuring Persistent Storage for SQL Server in Azure Container Services
I’ve been playing around with SQL Server running in Kubernetes in Azure Container Services (AKS) for a while now and...
2018-02-01 (first published: 2018-01-24)
1,446 reads
Perfecting my presentations
After a considerable amount of “umming and ahhing” last year I decided to start presenting full hour long sessions. Well,...
2018-01-22
252 reads
Friday Reading 2018-01-19
It’s been absolutely freezing here in Dublin this week. Been spending pretty much all time wrapped up indoors reading…
Discussing PASS...
2018-01-19
300 reads
Using Windows stored credentials to connect to SQL in containers
I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears...
2018-01-17
1,103 reads
Time to find a new place to live
Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the...
2018-01-15
272 reads
Friday Reading 2018-01-11
Phew, what a week! Have been looking for a new flat to live so it’s been a bit mad. Have...
2018-01-12
315 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