Sunday, 19 November 2017 10:03

Microsoft releases open source SQL Server DevOps tool for Linux, Mac

By

Microsoft’s SQL Server Management Studio is a Windows-only product, meaning developers and admins who preferred other operating systems had to find alternate tools until now, with the preview release of SQL Operations Studio.

Microsoft continues its trend of embracing alternate, non-Windows, platforms under chief executive Natya Sadella. While it’s not news Microsoft has been working to bring its database product SQL Server to Linux since early last year, developers who used Linux or Macintosh hardware running OS X had to resort to remote desktop connections into a Windows machine, or find alternate products such as JetBrain’s DataGrip, to execute database queries and manage databases directly from their own desktop.

This now changes with Microsoft’s release in preview of SQL Operations Studio. The name is an interesting choice, omitting “Server”, suggesting it may, in time, be useful for non-Microsoft database platforms also. For now, SQL Operations Studio exists for Windows, Linux and OS X and is available for download.

Or, if you’re keen, you can even build your own version straight from the GitHub repository because it’s also an open source product, built on top of Visual Studio Code. The licence says Microsoft Corporation (“Microsoft”) grants you a non-exclusive, perpetual,royalty-free right to use, copy, and modify the software code provided by us ("Software Code"). You may not sublicense the Software Code or any use of it (except to your affiliates and to vendors to perform work on your behalf)through distribution, network access, service agreement, lease, rental, or otherwise.

Once installed, it’s an easy task to connect to Microsoft SQL Server and Microsoft Azure SQL Server, using the regular connection details — server name, username and password, database name — and perform routine database operations.

Here’s where the ‘operations’ in the name comes in; this isn’t simply a query management tool for developers, it’s also intended for those in infrastructure teams who are not database professionals but yet must perform regular database server administration tasks, providing prescriptive features and version-controlled scripting support whether bash, PowerShell, or something else.

SQLOperationsStudio

BUSINESS WORKS BETTER WITH WINDOWS 1O. MAKE THE SHIFT

You cannot afford to miss this Dell Webinar.

With Windows 7 support ending 14th January 2020, its time to start looking at your options.

This can have significant impacts on your organisation but also presents organisations with an opportunity to fundamentally rethink the way users work.

The Details

When: Thursday, September 26, 2019
Presenter: Dell Technologies
Location: Your Computer

Timezones

QLD, VIC, NSW, ACT & TAS: 11:00 am
SA, NT: 10:30 am
WA: 9:00 am NZ: 1:00 pm

Register and find out all the details you need to know below.

REGISTER!

ADVERTISE ON ITWIRE NEWS SITE & NEWSLETTER

iTWire can help you promote your company, services, and products.

Get more LEADS & MORE SALES

Advertise on the iTWire News Site / Website

Advertise in the iTWire UPDATE / Newsletter

Promote your message via iTWire Sponsored Content/News

Guest Opinion for Home Page exposure

Contact Andrew on 0412 390 000 or email [email protected]

OR CLICK HERE!

David M Williams

David has been computing since 1984 where he instantly gravitated to the family Commodore 64. He completed a Bachelor of Computer Science degree from 1990 to 1992, commencing full-time employment as a systems analyst at the end of that year. David subsequently worked as a UNIX Systems Manager, Asia-Pacific technical specialist for an international software company, Business Analyst, IT Manager, and other roles. David has been the Chief Information Officer for national public companies since 2007, delivering IT knowledge and business acumen, seeking to transform the industries within which he works. David is also involved in the user group community, the Australian Computer Society technical advisory boards, and education.

VENDOR NEWS & EVENTS

REVIEWS

Recent Comments