As a product, MSSQL is surprisingly solid. That said, unless you're being forced to use it, I'd concur with avoiding it. And if you are going to use it, then why Go? Why not just stick with C#/C++ or any other language with established libraries for MSSQL.
Picking what language to use based on your database seems silly.
You should pick a language based on project and customer requirements, not what you like to use.
Since MSSQL is mostly used in Windows shops, nothing more natural than using a language directly supported by Microsoft.
Same reason golang apps need to run on windows. Golang needs good library support for MSSQL.