Monday Coffee 2017-01-16
I’ve been a scribbler for as long as I can remember, in fact I’m not sure that I write everything...
2017-01-16
338 reads
The DBA Who Came In From The Cold
Friday Reading 2017-01-13
Ahh, is it really Friday the 13th?!! So before Jason gets me, I’ll be reading…
A whole day of PowerShell & SQL
Join...
2017-01-13
339 reads
Killing databases in SQL Server on Linux
Bit of fun this week with something that a colleague of mine noticed when playing around with SQL Server on...
2017-01-11
1,008 reads
Monday Coffee 2017-01-09
I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left...
2017-01-09
384 reads
Friday Reading 2017-01-06
Happy New Year to all of you out there! I know, I know it’s a week late but hey I’ve...
2017-01-06
337 reads
Saturday Reading 2016-12-17
It was my office Xmas party last night so whilst recovering on my settee, I’ll be reading:-
The Most Important Role...
2016-12-17
343 reads
Presenting with SQL Server Management Studio
Short one this week as it’s the usual madness on the lead up to Xmas!
One of the cool things that...
2016-12-14
720 reads
Monday Coffee 2016-12-12
Speaking and presenting
One of my biggest fears is public speaking and judging by this article, I’m not alone.
However it’s something...
2016-12-12
290 reads
Friday Reading 2016-12-09
One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to...
2016-12-09
363 reads
SQL Server & Containers – Part Four
In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of...
2016-12-26 (first published: 2016-12-07)
2,052 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