Monday Coffee 2016-12-05
You are the DBA your company makes you. Aren’t you?
SQL Server has such a wide range of features that no...
2016-12-05
303 reads
The DBA Who Came In From The Cold
Friday Reading 2016-12-02
Another week almost over so here’s a random selection of articles that I’ve been reading…
Changing the SQL Server port on...
2016-12-02
364 reads
SQL Server & Containers – Part Three
This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing...
2016-12-14 (first published: 2016-11-30)
2,020 reads
Monday Coffee 2016-11-28
MCSA SQL Server 2016
The new SQL 2016 MCSA exams are out and joy of joys, the DBA path no longer...
2016-11-28
432 reads
Friday Reading 2016-11-25
Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-
Virtue in the Virtual
Tony Davies discusses containerisation...
2016-11-25
478 reads
SQL Server & Containers – Part Two
This post follows on from SQL Server & Containers – Part 1 and will go through how to build custom container images.
Since...
2016-11-23
675 reads
Monday Coffee 2016-11-21
Well there were quite a few announcements in the SQL Server world last week.
SQL Server vNext CTP was made...
2016-11-21
351 reads
Friday Reading 2016-11-18
Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
SQL Server 2016 SP1 has been released....
2016-11-18
415 reads
SQL Server & Containers – Part One
Containers are a hot topic at the moment, there seems to be a new article about them on Hacker News...
2016-11-16
642 reads
Monday Coffee 2016-11-14
Communication in the workplace.
With the release of Microsoft Teams we now have a dazzlingly array of software designed to increase...
2016-11-14
327 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