[harvey9]

You can connect to SQL databases from R, or almost any visualisation or GIS software. Not sure what you mean by 'best'?

[gleb]

I should have been more clear and said "using SQL only without R or python". This is for internal BI use, not for product development.

[harvey9]

There's a basic map display in ssms if I recall correctly. But otherwise you can generate a map with something like Tableau. Less of a learning curve than R.