Connect SQL Operations Studio For Mac to a SQL Server in Parallels VM


I’m slowly moving away from Windows. However, being a Microsoft Dynamics GP consultant, that’s not entirely possible. I’ve been working hard to overcome every single roadblock since the last couple of years.

One major gripe, among several others, was the inability to connect the SQL Server instance on my Windows 10 virtual machine, mounted using Parallels. Until now.

Microsoft released SQL Server Operations Studio, which is still under preview, for us to connect to a SQL Server from Windows, Mac OS or Linux. I now have the choice to work from either my Mac OS or my Windows 10 VM.

However, there are some steps we must follow to successfully connect to a SQL Server instance on a virtual machine. This post, from Anton Sizikov, is probably the easiest one to follow. Following the steps explained on this post, Connecting SQL Operations Studio to SQL Express Server in Parallels VM, I was able to successfully use my SQL Server Operations Studio to connect to my VM SQL Server. Below is the SQL Ops Studio in all its “dark theme” glory:

Screen Shot 2018-05-16 at 16.18.41

I couldn’t use my Mac more than pretty much for just browsing, emailing and other daily digital chores. This is one huge step forward to start utilising it well.

Vaidy

 

Advertisements

Off-Topic: Mac OS High Sierra Push Notification Banners Issue


I’m blogging after a painfully long time. And, I’d like to share something really interesting that happened on my MacBook Pro this week.

I reset my Mac with Mac OS High Sierra (10.13.4) and all of a sudden, all my notifications stopped working. The Dock labels would show, sound would be there, yet mysteriously, banners wouldn’t come. Upon checking the notification area, there wasn’t any recent notifications listed at all. Baffling, to say the least.

Screen Shot 2018-04-19 at 11.00.36 am.png

Then I chanced upon this apple support forum discussion, Mail notifications | Official Apple Support Communities.

Despite the discussion being for Mail App, the solution given on this discussion worked for me for all apps’ notifications.

Solution is quite simple; change the alert notification from “Alerts” or “Banners” to “None” and change it back. Easy, isn’t it? Not exactly. I had to do this for all of my apps, using the notification centre.

Screen Shot 2018-04-19 at 11.04.49 am.png

I can’t complain though. It’s working now, that’s all I need.

If someone’s having same issue and is looking for a solution, look no further. Check out the discussion on Apple Support Forum (link provided above).

Vaidy