Author Archives: admin

PowerShell Open Source Alpha14 and SQL Server for Linux CTP 1.1 are out!

This is Great! Microsoft keep delivering updates before Christmas just to keep us busy and excited. To download the latest PowerShell Open Source just go to the link below: https://github.com/PowerShell/PowerShell Just remember to remove the previous version, and any existing … Continue reading

Posted in PowerShell, SQL Server, Ubuntu, Windows 10 | Comments Off on PowerShell Open Source Alpha14 and SQL Server for Linux CTP 1.1 are out!

PowerShell Open Source – Windows PSRemoting to Linux with OpenSSH

I have to admit that I was waiting for this for some time. Finally, PowerShell 6.0.0-Alpha_13 can do remoting between Windows to Linux. This is Awesome! I’m going to give you the top-to-bottom scope in order to avoid going back-and-forth … Continue reading

Posted in Bash, PowerShell, Ubuntu | Comments Off on PowerShell Open Source – Windows PSRemoting to Linux with OpenSSH

PowerShell – Working with Python and SQL Server

As you all know with the release of PowerShell Open Source and SQL Server on Linux are open doors to cross-platform developments. But is has been going on for awhile as Linux languages like Python, Ruby, Java and PHP has … Continue reading

Posted in PowerShell | Comments Off on PowerShell – Working with Python and SQL Server

PowerShell Open Source – Looking into Windows 10 Bash Linux subsystem and PowerShell

This is an FLPSUG October 27th Online meeting that, due to a Windows 10 update issue, had to be rescheduled to November 3rd. Topic: Looking into Windows 10 Bash Linux subsystem and PowerShell We’ll be taking a tour into Windows 10 … Continue reading

Posted in PowerShell | Comments Off on PowerShell Open Source – Looking into Windows 10 Bash Linux subsystem and PowerShell

PowerShell Open Source – Take advantage of ‘#Requires -Version’ and new variables

Now that PowerShell Open Source is evolving, we need taking advantage of some if it features to build cross-platform scripts. Also, a good way to test the script functionality is to use either Linux or Windows 10 Bash environments. Just … Continue reading

Posted in PowerShell | Comments Off on PowerShell Open Source – Take advantage of ‘#Requires -Version’ and new variables

SAPIEN PowerShell Studio – Simple sample using ComboBox in forms

The Form This is a simple form showing the ComboBox component using PowerShell Studio. For this sample I’m using a Simple Form in order to add components to it. In this case a ComboBox Component. At the same time we … Continue reading

Posted in PowerShell | Comments Off on SAPIEN PowerShell Studio – Simple sample using ComboBox in forms

PowerShell – OneDrive Script Editing Available

In case you didn’t know, you can edit PowerShell scripts in your OneDrive folder. This makes it ideal for saving your code in the cloud and then access the scripts when needed from anywhere. You can be very creative, and specially if … Continue reading

Posted in PowerShell | Comments Off on PowerShell – OneDrive Script Editing Available

PowerShell – SSMS v17 RC1 changes in SMO support for SQL Server vNext

Download available now. Get it here: https://msdn.microsoft.com/en-us/library/mt238290.aspx Yes! The SQL Server Management Studio v17 RC1 is the one updated for SQL Server vNext on Linux. This version brings new properties in SMO object to properly identify SQL Server vNext. So, … Continue reading

Posted in PowerShell | Comments Off on PowerShell – SSMS v17 RC1 changes in SMO support for SQL Server vNext

SQL Server for Linux Cross-Platform Database Restore

Now that SQL Server vNext for Linux CTP1 is available, you want jump in and test you installing existing databases. You may want to use databases with compatibility to SQL Server 2012 and greater. As I’m not a full Linux … Continue reading

Posted in PowerShell | Comments Off on SQL Server for Linux Cross-Platform Database Restore

SQL Server vNext for Linux CTP1 is available now.

Yes! The doors are finally open for all interested in trying SQL Server for Linux. This is the first preview version and there are more to come. This was announced at the Microsoft Connect() event today. Go to this Link … Continue reading

Posted in PowerShell | Comments Off on SQL Server vNext for Linux CTP1 is available now.