Category Archives: Windows 2012

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?

Trap missing IP Address for SQL Database Server Firewall Rule

As I work on my second blog piece for the “Getting Ready with Windows Azure SQL Database Server PowerShell and SMO Part – 2/2“, I came up with a way to trap the current IP Address with PowerShell scripting.  When … Continue reading

Posted in Azure, PowerShell, SQL Azure, SQL Server, Windows 2012, Windows 8 | Leave a comment

QuickBlog – PowerShell function to get system last bootup time.

Here’s a simple function that will get your system last bootup time.  Also, notice that I’m using the ‘-ErrorVariable ‘ parameter wth a given variable name ‘MyError‘ to trap any error messages during the execution of the ‘Get-WMIobject’ command.  That … Continue reading

Posted in PowerShell, Windows 2012, Windows 8 | Comments Off on QuickBlog – PowerShell function to get system last bootup time.

South Florida IT Pro Camp presentation and demo scripts

Thanks to all South Florida IT Pro Camp organizers for having present at their event. Here’s the PowerShell presentation and demo scripts all consolidated into zipped file. Feel free to contact me via email if you have any questions. Thanks … Continue reading

Posted in PowerShell, Windows 2012, Windows 8 | Comments Off on South Florida IT Pro Camp presentation and demo scripts

Palm Beach IT User Group – “PowerShell for the Administrator – All About The Language”

Thank once again to the Palm Beach IT User Group for having my presenting live my session “PowerShell for the Administrator – All About The Language” on May 14th evening.   http://itportalregulus.blogspot.com/ The group had the opportunity to see the evolution from a … Continue reading

Posted in PowerShell, Windows 2012, Windows 8 | Comments Off on Palm Beach IT User Group – “PowerShell for the Administrator – All About The Language”