If you absolutely require the official SSMS interface (e.g., for specific Windows-only features like maintenance plans), you must use a virtualization tool:
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. sql server management studio macos