Category Archives: SQL Server

About SQL Server.

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

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!

My IDERA’s PowerShell Webcast not only for DBA’s

I decided to compiled all of the webcast I did for IDERA Geek Synch from the last two years(2015 – 2016). Free registration and view the webcast: https://www.idera.com/events/geeksync 08/10/2016 – Geek Sync Webcast : Learn the PowerShell Essentials on Error … Continue reading

Posted in PowerShell, Resources, SQL Server | Comments Off on My IDERA’s PowerShell Webcast not only for DBA’s

VS Code working with SQL Server

VS Code editor works great and specially when using it in cross-platform environment. So, I decided to try using it connect to one of my SQL Server instance. To configure VS Code editor is simple. Make sure to check my previous … Continue reading

Posted in PowerShell, SQL Server | Comments Off on VS Code working with SQL Server

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

Important PowerShell Links To Remember

Just a reminder!  Here are some PowerShell resource link to save. Microsoft just recently announce the PowerShell “Windows Management Framework 5.1 Preview“. Check the PowerShell Team Blog: Announcing Windows Management Framework (WMF) 5.1 Preview In addition, if you encounter any … Continue reading

Posted in PowerShell, SQL Server | Comments Off on Important PowerShell Links To Remember

Microsoft SSMS July 2016 Hotfix is Available now

Go and get it.  Of course, No SQLServer PowerShell update on this hotfix. But you’ll need this update. Read more on this link for more information: https://msdn.microsoft.com/en-us/library/mt238290.aspx If you are still interested of see what’s new in this July Edition of … Continue reading

Posted in PowerShell, SQL Server | Comments Off on Microsoft SSMS July 2016 Hotfix is Available now

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