Automating installation of Docker & SQL command line tools on Linux
I’ve been getting to grips with Docker SQL Containers on Linux (specifically Ubuntu 16.04) and have found that I’ve been...
2017-08-03
454 reads
The DBA Who Came In From The Cold
SELECT…INTO in SQL Server 2017
One of the new options available in SQL Server 2017 is the ability to specify a filegroup when using SELECT..INTO...
2017-08-22 (first published: 2017-08-02)
3,278 reads
Monday Coffee: The evolving DBA
Over the weekend I saw a few tweets about the role of the DBA. These tweets (and corresponding blog posts)...
2017-07-31
564 reads
Friday Reading 2017-07-28
Hope you all had a good week. Been pretty chilled out here so I’ve been reading…
Announcing Azure Container Instances
Microsoft blog...
2017-07-28
384 reads
Automatically restarting Docker containers
One of the problems that I’ve encountered since moving my Dev/QA departments to using SQL Server within containers is that...
2017-08-10 (first published: 2017-07-26)
2,484 reads
Monday Coffee: SQL Services in Containers
I had an interesting question on twitter last week when I published my post on Running Linux Container on Windows:...
2017-07-24
368 reads
Friday Reading 2017-07-21
Fun week! I moderated a couple of great sessions for 24 Hours of PASS: Summit Preview. As someone getting into...
2017-07-21
330 reads
Running Linux Containers on Windows
Microsoft have announced the availability of SQL Server 2017 RC1 and I wanted to check it out in a container...
2017-08-02 (first published: 2017-07-18)
2,214 reads
Monday Coffee: 24 Hours of Pass – Summit Preview
Starting at 12pm (UTC) this Wednesday is the online event 24 Hours of PASS – Summit Preview
For anyone out there who...
2017-07-17
282 reads
Friday Reading 2017-07-14
Fun week, and what a Lions final test last weekend. Still can’t believe it!
Here’s what I’ve been reading…
STOPAT And Date...
2017-07-14
291 reads
Blogs
Agentic Architect – Future IT Roles (comparison)
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
Cara koreksi Nama Tiket di BookCabin
Koreksi nama tiket di BookCabin dapat dilakukan melalui Call Center BookCabin di +62 821...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
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