Hi guys, I'm going to be starting a new DBA job soon and thre's one aspect of it that I've never seen before. My employer will be a cloud hosting outfit and every customer apparently has their own instances on a separate VLAN i.e. they wont be able to see eachother.
I've never managed a SQL estate laid out like this before. My question is what will I need in order for me to setup a central management server so i can see all these instances as one group in SSMS and run DBA queries against the whole etc?
WHen I Googled SQL Server and VLAN there was not much coming back which made me wonder if every customer in its own VLAN was a common configuration for SQL Server.
Anyway any pointer / tips would be very welcome!!