Friday Reading 2018-07-20
Haven’t posted one of these for a while! It’s good to have some time back to be able to read/write.
I’ve...
2018-07-20
334 reads
The DBA Who Came In From The Cold
Creating SQL images in Azure with ACR Build – Part One
Whenever I’ve pushed images up to an Azure Container Registry I’ve been building them locally (using Docker for Windows) and...
2018-07-18
349 reads
Downtime
I was speaking at a conference recently and when I bumped into a friend, the first thing she said to...
2018-07-16
234 reads
SQL Saturday Cork 2018
This coming weekend (9th of June) is SQL Saturday Cork!
I’ve been really looking forward to this SQL Sat as there’s...
2018-06-04
291 reads
Deploying Azure Container Instances
In a previous post I went through how to Push an image to the Azure Container Registry
Now let’s look at...
2018-06-04 (first published: 2018-05-23)
2,063 reads
Pushing SQL Server images to the Azure Container Registry
The Azure Container Registry is an online repository for storing Docker images (think the Docker Hub).
What’s cool about this is...
2018-05-23 (first published: 2018-05-09)
1,431 reads
Loopback available for Windows Containers
The April 2018 update for Windows brought a few cool things but the best one (imho) is that now we...
2018-05-16 (first published: 2018-05-07)
1,728 reads
Friday Reading 2018-05-04
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
340 reads
Changing the location of docker named volumes
A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...
2018-05-09 (first published: 2018-05-02)
1,802 reads
Shiny Tech Syndrome
This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing...
2018-04-30
368 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers