In such cases you'll need to install SQL Server for Windows. Or you might need a feature that isn't included in the Linux edition of SQL Server. For example, you might want to connect to your local instance of SQL Server using a local copy of SSMS (which is only available for Windows). However, while that's an excellent option, there may be times where you want (or need) to install the Windows edition of SQL Server on your Mac.
This allows you to run SQL Server on the Mac without having to install Windows. You can install SQL Server for Linux on a Mac (with the help of Docker). Yes! Starting with SQL Server 2017, you no longer need Windows to run SQL Server. You'll be able to have Windows and Mac running simultaneously, which means you can switch back and forth between Windows and macOS as often as you like. Once you've completed that, you're done! You'll have SQL Server for Windows running on your Mac. This is a GUI management tool that allows you to work with SQL Server. Again using Windows (in the virtual machine you just created), download SQL Server Management Studio (SSMS) from the SSMS download page and install it, following the prompts.create a few sample databases and run some practice queries. Victoria Silversmith, Technical Design Authority Data, Hiscox. Whichever is better for creating relational databases. With the Secure Enclaves enhancement of Always Encrypted in SQL Server 2019, we can now enforce highly restricted, client-application-based access to our customers’ most sensitive data without inhibiting our real-world data handling and analysis requirements. Using Windows (in the virtual machine you just created), download SQL Server from the SQL Server download page and install it, following the prompts. I'm just messing around with sql for now to see what it can do, but essentially what I would like to do is this: Get sql running and connect it with excel or some sort of database server.Once you've installed Windows in the previous step, you can go ahead and install SQL Server to that Windows operating system (inside your virtual machine).