Category Archives: Windows 10

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!

IDERA Geek Synch Webinar – Wednesday February 22nd, 2017

Topic: Using PowerShell with Python and SQL Server Description: Just as PowerShell is argued as the main technology for automation in Windows Datacenters Infrastructure, it is equally important in other non-Windows Operating Systems. According to Maximo Trinidad, Windows Administrators have … Continue reading

Posted in Bash, Linux Bash, PowerShell, SQL Server, Ubuntu, Windows 10 | Comments Off on IDERA Geek Synch Webinar – Wednesday February 22nd, 2017

Florida PowerShell User Group Online Meeting – Thursday February 23rd, 2017

Topic:  Understanding Bash On Windows 10 Description: Come and learn how to setup and use Bash On Windows 10. Learn the tips and tricks to use PowerShell and Python together. At the same time, there are some differences in working … Continue reading

Posted in Bash, Linux Bash, PowerShell, SQL Server, Ubuntu, Windows 10 | Comments Off on Florida PowerShell User Group Online Meeting – Thursday February 23rd, 2017

Windows 10 Bash and PowerShell Redux

In my previous blog “http://www.maxtblog.com/2016/10/running-powershell-in-windows-10-bash-workaround/“, I was able to find a workaround to how work with PowerShell Open Source in Windows Bash subsystem.  But now, I found a better way using the Ubuntu Desktop component. It’s a known fact, if you install … Continue reading

Posted in Bash, PowerShell, Ubuntu, Windows 10 | Comments Off on Windows 10 Bash and PowerShell Redux

PowerShell Open Source Alpha14 and SQL Server for Linux CTP 1.1 are out!

This is Great! Microsoft keep delivering updates before Christmas just to keep us busy and excited. To download the latest PowerShell Open Source just go to the link below: https://github.com/PowerShell/PowerShell Just remember to remove the previous version, and any existing … Continue reading

Posted in PowerShell, SQL Server, Ubuntu, Windows 10 | Comments Off on PowerShell Open Source Alpha14 and SQL Server for Linux CTP 1.1 are out!

Running PowerShell In Windows 10 BASH (workaround)

Yes! It’s possible. There’s a workaround make PowerShell to work in Bash for Windows. The only drawback, you still can’t do a Clear-Host (or clear or cls), at the PowerShell prompt.(yet) (Updated 11/03/2016):  You can use Ctrl-L to clear the … Continue reading

Posted in Bash, Linux Bash, PowerShell, Ubuntu, Windows 10 | Comments Off on Running PowerShell In Windows 10 BASH (workaround)

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

VS Code running PowerShell – Terminal session 3/3

Here’s the final blog. I’m going to show the third way to execute PowerShell: 1. VS Code – PowerShell Extension and Debug feature. 2. VS Code – Code Runner Extensions for PowerShell. 3. VS Code – Terminal session.   VS … Continue reading

Posted in PowerShell, Ubuntu, Windows 10 | Comments Off on VS Code running PowerShell – Terminal session 3/3

Create PowerShell Top-Down ETL Process III

On previous blog we have collect some data and built our .NET PowerShell object which is going to be loaded into our SQL Server. In this final section we are completing the process of loading the data into SQL Server. … Continue reading

Posted in PowerShell, SQL Server, Windows 10 | Comments Off on Create PowerShell Top-Down ETL Process III