DP» All these systems are put together with the best and honourable intentions.
Are they? Really?
Or could it be that an order has come down from on high in Microsoft that metadata is the new gold rush and that whatever can be collected must be collected.
What I don't really understand is why so many SQL Servers have Internet access. These servers should only be accessed internally or by their application servers. The idea that so many SQL Server installations are exposed to the Internet sends a shiver down my spine. Are you who is charged with the well-being of your DB-server up to speed with cybersecurity or do you hope that a virus-scanner and a religious devotion to updates and patches will keep it safe?
I agree. I don't know why our SQL Servers have internet access. My thought is that the OPS team has it that way to make monthly Windows Updates easier.