Attaching databases via a dockerfile – UPDATE
This has been bugging me for a while but I just haven’t had a chance to get around to revisiting...
2018-12-11
179 reads
The DBA Who Came In From The Cold
Running a SQL Server Azure Container Instance in a virtual network
Up until now Azure Container Instances only had one option to allow us to connect. That was assigning a public...
2018-10-04
346 reads
Running SQL Server 2019 CTP in a Docker container
If you’ve been anywhere near social media this week you may have seen that Microsoft has announced SQL Server 2019.
I...
2018-10-04 (first published: 2018-09-25)
4,423 reads
Taking the Linux plunge – Update
It’s been a couple of weeks now since I took the plunge and bought myself a Dell XPS 13 running...
2018-08-10
302 reads
SSL Provider error 31 when connecting to SQL in a docker container
I recently bought a Dell XPS 13 running Ubuntu 16.04 and ran into an issue when connecting SQL Operations Studio...
2018-08-06
711 reads
Evening or morning poll results!
And the results of the poll are in!
Evening just scraping it! So there’s a pretty even mix out there, interesting....
2018-08-03
235 reads
Are you a morning or evening person?
I am not a morning person. I’ve really tried but there’s something in me that just stops me from getting...
2018-07-30
311 reads
Friday Reading 2018-07-27
Phew, I’m not going to complain about the hot weather…I’ll miss it when it’s gone.
Linux Load Averages: Solving the Mystery
Good...
2018-07-27
331 reads
Creating SQL images in Azure with ACR Build – Part Two
EDIT – 2018-10 – ACR Build is now known as ACR Tasks
In Part One I detailed how we can use ACR Build...
2018-08-09 (first published: 2018-07-25)
1,517 reads
Taking the Linux plunge
I’m a Windows guy.
Kinda have had to be, given my profession as a SQL Server DBA. But recently I’ve become...
2018-07-23
307 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