Connecting via Microsoft Remote Desktop Client to a Windows server or workstation hosting SSMS. Zero local resource usage; works on any Mac. Cons: Requires network connectivity; possible latency; external Windows machine needed.
This is a fully native macOS app that many users find outperforms SSMS in daily tasks due to its efficient interface and speed. sql server management studio macos