This week's episode of Data Exposed is another episode I am extremely excited about! With all of the great work being done on SQL Server, it is a pleasure to welcome Sanjay Nagamangalam to the show! Sanjay is a Principal PM in the SQL Server engineering group focusing on the tooling aspect for SQL Server, and today he is in the studio to talk about all the tooling being done for the different platforms.
Sanjay begins the show by laying the foundation as to why Microsoft is working on providing Multi-OS SQL client tools, including Linux and Mac, and helping us understand the tooling landscape given the different role aspects in the enterprise, such as AppDev and DBA.
Hi Are there plans for a SSMS to run on Mac OSX, since there is a Visual Studio for Mac? Thanks davej Hello, The SSMS team has no plan at this time to move SSMS to be cross-platform. They say they can consider such a project if there is a demand for that, if enough people vote for it. As a result I created the following Connect item to.
At the [06:55] mark it is DEMO TIME, and Sanjay spends the remaining 17 minutes of the show in demo awesomeness! First, he shows us using SQL Server Management Studio connecting to, and working with, SQL Server running on Linux, including exporting and importing between SQL Server on Windows and SQL Server on Linux, and more!
Then at the [11:30] mark he spends roughly 13 minutes showing the awesome SQL Server extensions in Visual Studio code for both Windows and Linux!
We close the show with a 'Call to Action' to try all these great tools and code samples!
Try SQL Server on Linus: www.sqlserveronlinux.com
MSSQL extensions: https://aka.ms/mssql-marketplace
Getting started code examples: https://aka.ms/sqldev
GitHub: https://github.com/Microsoft/vscode-mssql
Phenomenal show, and we cannot wait to have him back to show us more!
In my [previous blog] post of SQL Server 2016 RC0 availability, I mentioned regarding SQL Server Management Studio (SSMS) that it will no longer be installed from the main feature tree of SQL Server engine setup.
As per Microsoft, this is basically to support the move to make a universal version of SSMS that ships every month or so.
So, now on wards after installing SQL Server 2016 you need to install SSMS separately.
–> Till SQL Server 2014 you have an option of choosing SSMS in the Feature selection tree, but with SQL Server 2016 and on wards this option is taken out, can be seen in the pic below:
Sql Server Management Studio Os X
–> Now to download SSMS 2016 you can either visit the Microsoft [download page]
Or, try installing directly via the “Installation Center” as shown below. This will install SSMS directly online.
So, once you take appropriate action above to download SSMS 2016, the Installation kicks off like this:
And here is the version information of SSMS 2016 after successful installation:
Tech Tip: Move your SQL server onto the cloud with Hosted Citrix VDI available unbelievable citrix xendesktop pricing and get an easy remote access to it from anywhere on any device(PC/Mac/Linux/android/iOS) powered by one of the leading providers of cloud hosting – Apps4Rent.
Sql Server Management Studio
Check my blog posts on most of the new features released in SQL Server 2016