Category Archives: SQL Server

About SQL Server.

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 – 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

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

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

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!

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!

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!