One of the newer features in Data Masker for SQL Server is the ability to read column classifications and suggest rules to clean the data. I decided to give...
2019-12-02 (first published: 2019-11-22)
271 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was testing some security change, and...
2019-11-20
119 reads
This week we released SQL Prompt 10, which is an exciting milestone for us. I remember when I discovered this little gem for Database Weekly and sent it over...
2019-11-15
130 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wouldn’t do this anymore, but I ran...
2019-11-22 (first published: 2019-11-13)
422 reads
Microsoft announced recently that they were changing the way licensing works for HA and DR situations. I think this is a great change, and the summary is: You can...
2019-11-11
34 reads
This was a fun talk with David Atkinson at Redgate. We talk satellites, finance, and more. Including some early history of the company. We are talking about how to...
2019-11-14 (first published: 2019-11-08)
238 reads
Voting is open for the PASS Board, as of yesterday (Nov 6). The candidate page is up, and there are 6 amazing candidates for 3 slots. They are: Chris...
2019-11-07
72 reads
I heard about the addition of PoSh as a kernel for notebooks in Azure Data Studio. This is in the November 2019 release, and you can download/upgrade today to...
2019-11-06
41 reads
SQL Clone v4 is out, and the big change is the addition of the Teams feature. I guess technically this is just for SQL Clone, which is included in...
2019-11-04
48 reads
I talk about resumes, enhancing your career, and finding your dream job at various events. This might be one of my most popular talks, and I’ve been lucky enough...
2019-11-01
334 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Hey all. I understand if this gets taken down due to the subject matter...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
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