Monday Coffee: Long hours worked
Last week I asked the following question on twitter: –
I had a load of responses from a lot of DBAs...
2017-10-02
275 reads
The DBA Who Came In From The Cold
Friday Reading 2017-09-29
Another busy week almost over and today I’m heading to Utrecht for SQL Saturday Holland! Never been to Utrecht before...
2017-09-29
498 reads
The docker kill command
When running demos and experimenting with containers I always clear down my environment. It’s good practice to leave a clean...
2017-10-06 (first published: 2017-09-28)
1,565 reads
An analytical mind
Last week I was reading this article in which a Professor argues that students should be allowed to take smartphones...
2017-09-25
365 reads
Monday Coffee: Should I learn powershell?
This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH
It had a massive...
2017-09-18
810 reads
Friday Reading 2017-09-15
Excited for next week as I’m heading down to Cork to speak at the User Group there. Over 3 years...
2017-09-15
364 reads
Creating Hyper-V VMs with Powershell
This month’s T-SQL Tuesday is hosted by Rob Sewell (b|t) and surprise, surprise, it focuses on Powershell so I thought...
2017-09-12
395 reads
Friday Reading 2017-09-08
It’s going to be a fun weekend as it’s SQLSaturday Cambridge tomorrow! Haven’t been to this event before, it looks...
2017-09-08
388 reads
Exploring the Kubernetes dashboard in Azure Container Services
Last week I went through how to run SQL Server in Kubernetes on Azure Container Services (ACS)
This week I want...
2017-09-06
833 reads
Upcoming speaking events
Back in March I did my first “feature length” presentation at SQL Saturday Iceland
At that point I’d done a few...
2017-09-04
274 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