Category Archives: PowerShell

About PowerShell.

PowerShell Core – Getting SQL Server using ADO.NET Data provider

If you’re interested in using PowerShell Core in Linux, as well in Windows, to connect and execute T-SQL queries then the “System.Data” namespace is available. This contains .NET classes necessary to help you access and manage data from SQL Server, … Continue reading

Posted in PowerShell | Comments Off on PowerShell Core – Getting SQL Server using ADO.NET Data provider

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

Issues with VS Code “PowerShell Integrated” feature

As VS Code continues to evolve, we need to keep in mind that technology keep changing fast. Some of us on Windows Insider Fast Ring get the opportunity to test drive the latest build of Windows 10. But there are … Continue reading

Posted in PowerShell, VS Code, Windows 10 | Comments Off on Issues with VS Code “PowerShell Integrated” feature

PowerShell, and SQL Server Working with Anaconda

On my previous blog “PowerShell – Working with Python and SQL Server“, I show how to install Python 3.5 so we can be build python scripts to connecting to SQL Server and use them with PowerShell. Now, since the release … Continue reading

Posted in Bash, Linux Bash, PowerShell, SQL Server, Ubuntu, Windows 10 | Comments Off on PowerShell, and SQL Server Working with Anaconda

PowerShell – SQL Server Management Studio v17 is Ready!

Yes! The SQL Server Management Studio¬† Version 17 is available for download for the purpose of managing the new SQL Server 2017, Azure SQL Databases and Azure SQL Data Warehouse. At the same time this version won’t prevent you from … Continue reading

Posted in PowerShell, SQL Azure, SQL Server, Windows 10 | Comments Off on PowerShell – SQL Server Management Studio v17 is Ready!

Drawback PowerShell Open Source Alpha18 on Bash on Windows 10

As we all know that PowerShell Open Source is a “work-in-progess” as it still in the alpha stage. So, previous version Alpha17 was a breakthru as it finally clear some bug in the Bash console. But, unfortunately it fell back … Continue reading

Posted in Bash, PowerShell, Ubuntu, Windows 10 | Comments Off on Drawback PowerShell Open Source Alpha18 on Bash on Windows 10

PowerShell Open Source on Bash on Windows 10 Breakthru

Finally, the fix we all been waiting for has arrived with the newest release of PowerShell version v6.0.0-alpha.17. Now, when you installed the Ubuntu 16.04.1 version of PowerShell 6 in Bash on Windows 10, it works this time. Thanks God! … Continue reading

Posted in PowerShell | Comments Off on PowerShell Open Source on Bash on Windows 10 Breakthru

PowerShell, SQL Server, and Linux Oh My!

The South Florida Code Camp 2017 is ON! Come and join me in this event on Saturday, March 11th 2017 all day event. Check out the event speaking agenda: http://www.fladotnet.com/codecamp/Agenda.aspx I will be presenting the following 3 sessions: 1. 09:50am … Continue reading

Posted in Bash, Linux Bash, PowerShell, SQL Server, Ubuntu, Windows 10 | Comments Off on PowerShell, SQL Server, and Linux Oh My!