Posts

Showing posts with the label Azure

How to install Microsoft Azure Data Studio so you can manage SQL Server straight from your Mac!

Image
Microsoft Azure Data Studio (formerly called SQL Operations Studio) is a lightweight management tool for managing SQL Server. Azure Data Studio is free, and it's available for macOS, Linux, and Windows. Here are instructions for installing it on a Mac. I also demonstrate how to connect to SQL Server once you've installed it. Download Azure Data Studio Go to the  Azure Data Studio download page  and click the .zip file for macOS (there are also options for Windows and Linux if you need them). Install Azure Data Studio Once the .zip file has downloaded, double-click it to expand its contents. Then drag the .app file to your Application folder (it will probably be called  Azure Data Studio.app ). Launch Azure Data Studio Launch Azure Data Studio (by clicking on its icon in your Launchpad or the Applications folder). Connect to SQL Server Enter the SQL Server connection details. Here are the details I used on the  SQL Server installation tutorial Server Name : localhost ...

How to install SQL Server on MacOS

  Install SQL Server directly to your Mac — no virtual machine required! Microsoft has made SQL Server available for macOS and Linux systems. This is made possible by running SQL Server from a Docker container. Therefore, there's no need to install a virtual machine with Windows (which was the only way to run SQL Server on a Mac prior to SQL Server 2017). Install and Configure Docker This is a prerequisite for installing SQL Server on your Mac. Because the Mac runs SQL Server inside a Docker container, the first thing we need to do is download and install Docker (unless it's already installed). Once installed, we'll increase its memory allocation to a more suitable level for running SQL Server. Download Docker from the  download page , extract it, and drag it into your Application folder. Launch Docker, and go to  Preferences > Advanced  and increase its memory allocation to 4GB OK, we're now ready to install SQL Server on your Mac. Now the Actual SQL Server Insta...