T-SQL Tuesday #90 Shipping Database Changes – Wrap Up
I’d like to say a huge thank you to everyone who read or published a post for T-SQL Tuesday #90....
2017-05-16
417 reads
Blog Posts
What Do You Do When Performance Sucks?
So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time....
2017-05-16
567 reads
XML vs JSON Shootout: Which is Superior in SQL Server 2016?
Watch this week's video on YouTube
Additional performance comparisons available in an updated post.
Starting with the 2016 release, SQL Server offers native JSON support. Although the implementation is not perfect,...
2017-05-16
26 reads
A (mostly) Unwired Week at #MSBuild
Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.
Last week I...
2017-05-15
668 reads
Building a container running SQL Server 2014 SP2 Developer
One of the things about working with SQL in Docker is that you kinda have to use the images that...
2017-05-15 (first published: 2017-05-02)
2,413 reads
Creating Azure Database for MySQL and using Azure Cloud Shell
After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...
2017-05-15
388 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
SQL Saturday Atlanta Precon – The Complete Primer to SQL Server Virtualization & Cloud
If you are attending this year’s SQL Saturday in Atlanta, GA, on July 15, I urge you to attend my preconference training session...
2017-05-15
380 reads
SQL Server 2017 – The operating system returned the error 21
Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was...
2017-05-15
4,636 reads
SQL Server 2017 sys.dm_os_enumerate_fixed_drives
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...
2017-05-15
1,535 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