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
The DBA Who Came In From The Cold
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
Creating SQL Server containers with docker compose
Up until now my posts about containers have been talking about working with one container only. In the real world...
2017-07-26 (first published: 2017-07-12)
7,818 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