Friday Reading 2017-05-26
The weather in Dublin is absolutely gorgeous at the moment so I’m not planning on spending much time inside this...
2017-05-26
406 reads
The DBA Who Came In From The Cold
Disabling the identity cache in SQL Server 2017
One of the changes that’s been brought into the database engine in SQL Server 2017 is the ability to disable...
2017-06-07 (first published: 2017-05-24)
4,667 reads
Monday Coffee 2017-05-22
I hope everyone had a good weekend. I spent mine watching probably the most dismal performance of rugby I’ve seen...
2017-05-22
487 reads
Friday Reading 2017-05-19
Everyone finished patching all their servers? In-between patching this week I’ve been reading…
Why VS Code Increases my Productivity
Rob talks about...
2017-05-19
368 reads
Update to DBCC LOGINFO in SQL Server 2017
One of the new features included in SQL Server 2017 that Microsoft has detailed here is a new DMF called...
2017-05-17
1,231 reads
Monday Coffee 2017-05-15
After the latest cyber attack I’ve had a fun weekend making sure all my devices are fully up-to-date with the...
2017-05-15
373 reads
Friday Reading 2017-05-12
The weather this week in Dublin has been absolutely fantastic, please hold out for the weekend. Anyway, whilst I’ve been...
2017-05-12
366 reads
Copying files from/to a container
Last week I was having an issue with a SQL install within a container and to fix I needed to...
2017-05-10
2,097 reads
Monday Coffee 2017-05-08
Asking stupid questions
Oh boy have I asked some stupid questions in my time. Most recent was this question that I...
2017-05-08
326 reads
Friday Reading 2017-05-05
Into May and a big couple of events this week in SQL Nexus and the Powershell Conference EU 2017, looking...
2017-05-05
473 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
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
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?
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