Category Archives: Windows 2012

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”

Show-PSDemo function – Simple way to demo scripts.

While working on my PowerShell demo scripts today, I decided to create a simple function to display my scripts during my presentations.  Here’s my new and simple Show-PSDemo function: It has one parameter “-FileLocation” which is you full folder and … Continue reading

Posted in PowerShell, Windows 2012, Windows 8 | Comments Off on Show-PSDemo function – Simple way to demo scripts.

PowerShell – Start getting your Computer Last BootUp Time

The PowerShell community has done an Excellent job in providing LOTs of sample codes. But sometime can be very intimidating for a beginner to understand. Well, PowerShell can be both simple, and complicated but not impossible to learn. Is good … Continue reading

Posted in PowerShell, Windows 2012, Windows 8 | Comments Off on PowerShell – Start getting your Computer Last BootUp Time

Create PowerShell SMO scripts without installing SQL Server

There’s no need to install SQL Server to create PowerShell SMO scripts.  So, how I do this?  You need three stand-alone packages from the “Microsoft® SQL Server® 20xx Feature Pack”.  Notice the “xx” in the SQL Server version.  This is … Continue reading

Posted in PowerShell, SQL Server, Windows 2012, Windows 8 | Comments Off on Create PowerShell SMO scripts without installing SQL Server