Author Archives: admin

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.

SAPIEN PowerShell Studio Deploying Your Application

In our previous blog we build a GUI application and created the executable file using either the “Build” or “Build & Run” option under the “Deploy | Packager” section. Although, this is optional, we could have created an MSI installer … Continue reading

Posted in PowerShell | Comments Off on SAPIEN PowerShell Studio Deploying Your Application

SAPIEN PowerShell Studio GUI Simplicity

In my last blog I show how easy it is to use a template to build a simple GUI application with a datagrid. Then, we enabled one of the sample code with the Script section of the “Load” button in … Continue reading

Posted in PowerShell | Comments Off on SAPIEN PowerShell Studio GUI Simplicity