We're building our new enterprise database and it will include SQL server spatial (native) data (moved from ArcSDE). This is great news for our SQL analysts who will now be able to consume our spatial data in their queries without having to break off data and use it in ArcGIS.
My question: is SQL Server Management Studio (SSMS) the only client that can connect to and use the SQL server spatial tables and functions? Or is there another lightweight client out there (SQLite, etc.) that can get the job done?
I'm also looking at how users can create their own local views of queries / spatial queries for use in charting in Excel, etc.