Work with SQL Server in Mac like in Windows

Hi all Mac and SQL Server lovers,

In this blog post I will explain you how to work with SQL Server in your mac like in a windows machine. Lets start.

Start SQL Server in Mac 

1. Install docker (https://hub.docker.com/editions/community/docker-ce-desktop-mac)
2. Increase the memory to 4 GB
You can do this by going to docker --> Preferences --> Advanced

 
3. Open the terminal and type bellow command 

docker run --name sql3 -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=sysAdmin@123' -p 1433:1433 mcr.microsoft.com/mssql/server:2017-latest-ubuntu

This will download and install SQL Server 2017 for linux
If you want different version of SQL Server, then you can find it from here: https://hub.docker.com/_/microsoft-mssql-server

NOTE: When providing a password for  sa (System Admin), it should meet the following criteria: 
  • At least 8 characters long
  • contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols

You can check the status of the container by running 'docker container ls' command. 
This will provide you the state as 'Up (x) minutes' (Ex: Up 25 minutes)

Use Azure Data Studio

4.  Download and install Azure Data Studio from https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017

5. Open Azure Data Studio and click on new connection to connect to created sql instance. 

6. Give sql connection details as bellow



7. Follow the Azure Data Studio Quick Start Guide from https://docs.microsoft.com/en-us/sql/azure-data-studio/quickstart-sql-server?view=sql-server-2017 to interact with SQL Server. 

Troubleshooting 

Sometimes Azure Data Studio (ADS) cannot connect to the SQL Server
  • Go to terminal and type 'docker ps -a' and check the status of the container. 
  • If the container has stopped type 'docker start [container id]'.
  • And try reconnecting in ADS.  


Happy quarrying... 










Comments

Post a Comment

Popular posts from this blog

Deploy Angular 8 app to Azure with Azure DevOps

Image
1. Create a Azure Web App. Use the following Configurations:      Runtime Stack: ASP.NET V4.7      Operating System: Windows You can select your own subscription plan, resource group and region.  2. Create a Git repository to hold the Angular app 2.1. Initialize your angular application 2.2. Commit and Push the code.  3. Create a Pipeline in Azure DevOps.  3.1. Login to the Azure DevOps. ( https://dev.azure.com/ ) 3.2. Create a project:          I'll select Private as visibility and Git as Version control.  NOTE: Azure DevOps provides different features.               For this task we are going to focus on Pipelines.  4. Pipeline Part 1: Integrate Git  From the Connect section select: Use the classic editor. 4.1. Select a Source as GitHub and authenticate with your GitHub account using OAuth.  ...
Read more

Apache ActiveMQ 5 with .Net Core 3.1 and C#

Image
Hi All..   In this post I'm going to explain how to use Apache ActiveMQ 5 (which is a popular Java based messaging server) for .Net Core 3.0+ with C#.  Let's get started. Prerequisites 1. Visual Studio (I'll be using 2019 Community)  2. .Net Core framework (I'll be using 3.1) 3. Java JDK or JRE Installed and Java Environment variable has been set (Since I'm doing in a Windows 10 computer)  Ok.. If you have the above requirements then let's get start the actual work. 1. Download and install ActiveMQ 5  Go to http://activemq.apache.org/components/classic/download/ and download according to your operating system.  I'll download .zip package for Windows 2. Copy the .zip file and put it inside a folder as you like or install with the installers if you download the installer.  If you got the .zip file like me; then extract it inside the folder that you paste the .zip file Then you will get a folder with the ActiveMQ package  3. Start the Active MQ...
Read more

Firebase with.Net Core and C#

Image
Hi folks, Are you developing web applications with .net ? Are you supporting mobile applications to communicate with your applications ? Are you thinking of providing realtime capabilities with your apps? Then I suggest you to read on Firebase Real-Time Dataabses by Google. " The Firebase Realtime Database is a cloud-hosted database. Data is stored as JSON and synchronized in realtime to every connected client. " - Google Firebase Team Read more:  https://firebase.google.com/docs/database/ In this post I'm going to discuss what is firebase but I'm going to discuss how to work with it with .Net C#. Firebase doesn't provide a separate library or a nugget to work with .Net, so you might find this bit tricky when you have to work with it from the backend. Senario To demonstrate the solution I will create a scenario. In my scenario we have created a video call function (which is implemented with OpenTok library) and it allows users to create sessions and i...
Read more