Category Archives: Windows 2012

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

Installing PowerShell Core in Server Core

In the following Virtual machine scenario, I got one Server Core with Active Directory (Build 16299) and Windows 10 (Build 16299) joined to my new domain. Both Build 16299. On my Windows client I create a shared folder named “SharedFiles”, … Continue reading

Posted in PowerShell, Resources, Windows 2012, Windows Server 2016 | Comments Off on Installing PowerShell Core in Server Core

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

FLPSUG – Next Online meeting July 26th 2017

I’m working on getting a meeting with Keiser University to allow me to host my Florida PowerShell User Group Monthly meetings at their Port St. Lucie Campus location.¬† But, in the meantime, I setup July’s Online meeting for Wednesday 26th … Continue reading

Posted in Azure, Bash, Linux Bash, PowerShell, SQL Server, Ubuntu, VS Code, Windows 10, Windows 2012 | Comments Off on FLPSUG – Next Online meeting July 26th 2017

South Florida SQLSaturday – Working with SQL Server in Linux session

First! Thanks to the organizers, and specially the attendees as they waited patiently to the attend my last session of the day “Working with SQL Server for Linux Cross-Platform”. It proves to be good. Love their interaction and the will … Continue reading

Posted in Azure, Bash, PowerShell, SQL Server, Ubuntu, VS Code, Windows 10, Windows 2012 | Comments Off on South Florida SQLSaturday – Working with SQL Server in Linux session

Using Linux SQL Server SMO in PowerShell Core

Yes! It’s possible. Here’s the information in how to set it up and start doing some PowerShell scripting. But, first understand that everything posted here is still a Work-In-Progress. And, the good news, it’s all Open Source. I hope you … Continue reading

Posted in Azure, Bash, Linux Bash, PowerShell, SQL Server, Ubuntu, Windows 10, Windows 2012 | Comments Off on Using Linux SQL Server SMO in PowerShell Core

Can you run PowerShell in SQL Server Management Studio? YES!

Just to be clear!! You can run PowerShell in SQL Server Management Studio. Not only you can run PowerShell, but you can create scheduled jobs in SQL Agent to run PowerShell scripts. This has been available since SQL Server 2008 … Continue reading

Posted in PowerShell, SQL Server, SSIS, Windows 10, Windows 2012 | Comments Off on Can you run PowerShell in SQL Server Management Studio? YES!

PowerShell – SQL Server 2014 SMO TruncateData() Workaround

As I was still puzzle why the SMO *.TruncateData() was missing in SQL Server 2014, I needed to find a quick workaround to continue with my data migration. Of course, here comes T-SQL scripting to the rescue: Basically, subtitute the … Continue reading

Posted in PowerShell, SQL Azure, SQL Server, Windows 10, Windows 2012 | Comments Off on PowerShell – SQL Server 2014 SMO TruncateData() Workaround

More Discover PowerShell – How about Help with PowerShell Variables?

Finally got this last function working in order¬†and created a new module: “DiscoverPowershell” with all three Show-Help* functions: 1. Show-HelpPowerShellCommand – Meant to select one module at the time and then multiple commands. 2. Show-HelpAboutPowerShellTopic – Multi-select can be applied. … Continue reading

Posted in PowerShell, Windows 2012, Windows 8 | Comments Off on More Discover PowerShell – How about Help with PowerShell Variables?