Category Archives: Ubuntu

SSMS Version 17.4 no more SQLPS Module

It was just a matter of time, as it was already mention in previous SSMS (SQL Server Management Studio) documentation that SQLPS module was going to be deprecated and replace with the new SQLServer module. See SSMS download information at: … Continue reading

Posted in Azure, Bash, PowerShell, PowerShell Core, SQL Azure, SQL Server, Ubuntu, Windows 10, Windows 2012, Windows Server 2016 | Comments Off on SSMS Version 17.4 no more SQLPS Module

PSCore6 – Version 6.0.1 is out of the oven!

Yes! Go and get while it still hot.  The Microsoft PowerShell Team is making it happen and they are not stopping. Need to know more about the PSCore Roadmap, the check this link: https://blogs.msdn.microsoft.com/powershell/2018/01/24/powershell-core-6-1-roadmap/ Keep mind, that it always take few … Continue reading

Posted in Azure, Bash, PowerShell, PowerShell Core, Ubuntu, Windows 10, Windows Server 2016 | Comments Off on PSCore6 – Version 6.0.1 is out of the oven!

PSCore6 – Nuget Microsoft.SqlServer.SqlManagementObjects latest Package (v140.17218.0) Broken

This is the SMO (SqlServer Management Objects) package use to create PSCore6 scripts to connect and manage SQL Server on Windows, Linux, and Azure. But today, I found out the latest version “140.17218.0″ is broken. I had to rolled back … Continue reading

Posted in Azure, Bash, PowerShell, PowerShell Core, SQL Azure, SQL Server, Ubuntu, Windows 10, Windows Server 2016 | Comments Off on PSCore6 – Nuget Microsoft.SqlServer.SqlManagementObjects latest Package (v140.17218.0) Broken

PSCore 6.0.0 – Upgrading/Uninstalling OpenSSH in Windows

This is all done with Chocolatey Package Manager for Windows. The following commands are important to know: 1. Information about the package: choco info OpenSSH 2. Upgrade installed package: choco upgrade OpenSSH 3. Remove installed package: choco uninstall OpenSSH 4. … Continue reading

Posted in Bash, Linux Bash, PowerShell, PowerShell Core, Ubuntu, Windows 10, Windows 2012, Windows Server 2016 | Comments Off on PSCore 6.0.0 – Upgrading/Uninstalling OpenSSH in Windows

Welcome PowerShell Core 6.0.0 GA

Yes! Today the Microsoft PowerShell Team with the help of the community has made PowerShell Core “Generally Available” and “Supported“. Feel free to read their blog post at: https://blogs.msdn.microsoft.com/powershell/2018/01/10/powershell-core-6-0-generally-available-ga-and-supported/ Get It Now Of course, there are little housekeeping to do, … Continue reading

Posted in Bash, PowerShell, PowerShell Core, Ubuntu, Windows 10, Windows 2012 | Comments Off on Welcome PowerShell Core 6.0.0 GA

PowerShell Core–Updated setup OpenSSH in Windows and Linux

It’s been over a year since my last post on “PowerShell Open Source – Windows PSRemoting to Linux with OpenSSH”. A lot has change, so here’s the updated version. Linux OpenSSH installation In Linux (Ubuntu), open a terminal (Bash) session. … Continue reading

Posted in Azure, Bash, Linux Bash, PowerShell, Ubuntu, Windows 10 | Comments Off on PowerShell Core–Updated setup OpenSSH in Windows and Linux

Streamlining SQL Server Management Objects (SMO) in PowerShell Core

I’ve been recently posting about getting SQL Server Management Objects (SMO) Framework to work in PowerShell Core in both Windows and Linux Systems. So, here’s the revised blog post as the method has kept improving. This way you can start … Continue reading

Posted in Bash, Linux Bash, PowerShell, SQL Server, Ubuntu, Windows 10 | Comments Off on Streamlining SQL Server Management Objects (SMO) in PowerShell Core

PowerShell Core useful cross-platform variables

In PowerShell Core, there are three useful variable you can use in a cross-platform scripts. Then, the script can have the necessary logic to response based on the environment it is running. Use the cmdlet Get-Variable to find them, and … Continue reading

Posted in Bash, PowerShell, Ubuntu, Windows 10 | Comments Off on PowerShell Core useful cross-platform variables

SAPIEN PowerShell Tools at Orlando Microsoft Ignite Conference 2017

As I started a new role working for SAPIEN Technologies as their Technology Evangelist in September, I had the opportunity to be working with them a the Microsoft Ignite Conference in Orlando. Greatly appreciate this opportunity and the chance the … Continue reading

Posted in Bash, Linux Bash, PowerShell, Ubuntu, Windows 10 | Comments Off on SAPIEN PowerShell Tools at Orlando Microsoft Ignite Conference 2017

PowerShell Core Stable SQL Server SMO Assemblies and DataRow objects

Yes! Just recently I downloaded the latest SQL Server SMO assemblies that can be use with PowerShell Core in both Linux and Windows. You can find them in Github under Microsoft SqlToolsService. But, you’ll need to extract only the necessary … Continue reading

Posted in Bash, Linux Bash, PowerShell, Ubuntu, Windows 10 | Comments Off on PowerShell Core Stable SQL Server SMO Assemblies and DataRow objects