Central management servers

Learn how to configure and use SQL Server Management Studio to do run the same query against many different SQL Servers and consolidate the results.

2021-03-29

Guide to Create a SQL Central Management Server

This post is going to walk you through the process of creating an SQL Management Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2017-09-28

9,014 reads

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

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?

Comments posted to this topic are about the item Designing Database Changes Before Deployment:...

I want to create a JSON document that contains data from this table:

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933

If I run this code, what is returned?

SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;