Posts

Showing posts with the label macOS

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...

How to solve the java home showing as /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home in MacOS Big Sur?

If we install the Java in MacOs Big Sur after downloading the JDK from Oracle, i am unable to compile the java program using javac.   Install JDK 8:  https://www.oracle.com/java/technologies/javase/javase-jdk8-downloads.html          Java SE Development Kit 8u281 When i check the java -version , it is showing as below  java version "1.8.0_311" Java(TM) SE Runtime Environment (build 1.8.0_311-b11) Java HotSpot(TM) 64-Bit Server VM (build 25.311-b11, mixed mode) After that when i check the java home using  /usr/libexec/java_home -V  it is the showing it as  /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home Solution: Use the below commands to remove the folder sudo rm -fr /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin  sudo rm -fr /Library/PreferencePanes/JavaControlPanel.prefpane Then use this to check the java home /usr/libexec/java_home -V  jayabalan@Saravanakumars-MacBook-Air ~ % /usr/libexec/java_ho...

How to run Powershell script on mac?

Image
                 We need to install the stable version of power shell on mac using the below steps and run the script in terminal Installation of latest stable release via Homebrew on macOS 10.13 or higher There are several ways to install PowerShell on macOS. Choose one of the following methods: Install using  Homebrew . Homebrew is the preferred package manager for macOS. Install PowerShell via  Direct Download Install from  binary archives . After installing PowerShell, you should install  OpenSSL . OpenSSL is needed for PowerShell WSMan remoting. If the  brew  command is not found, you need to install Homebrew following  their instructions . Bash /bin/bash -c " $(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh) " Now, you can install PowerShell: sh  brew install --cask powershell Finally, verify that your install is working properly: sh  pwsh https://docs.microsoft...