I just can’t believe I’ve been hooked to PowerShell since 2006. And, that I can’t stop using it.  This product change my life and it will be with us for a long time.

Here’s an image I showed on my first PowerShell presentation back in 2007 and I even build a CD with free resource information.

What a accomplishment from Microsoft PowerShell father Mr. Jeffrey Snover! He created PowerShell and nowaday is mostly available in most Operating Systems: Windows, Linux, and Mac OS. Here are a few slide from one of Jeffrey Snover PowerShell webcast back in April 2007.

I totally got it and I couldn’t stop learning about PowerShell. It did made my work easy thanks to this new .NET Scripting Automation Technology.

Now, let us not forget about all of our existing PowerShell Communities that throughout the years has done an excellent jobs to provide guidance adn direction to everyone wanting to learn PowerShell.

Big KUDOS!!

Join Microsoft PowerShell 10 Years Anniversary Celebration

Date: November 14th 2016 (A lond day event)
Where: MSDN Channel 9 – https://channel9.msdn.com/Events/PowerShell-Team/PowerShell-10-Year-Anniversary

Keep Learning about PowerShell!

If you missed our online meeting, then here’s the recording.  We’ll be taking a tour into Windows 10 Bash Linux subsystem. I’ll be sharing some tips on how to work with Bash, and the workaround to make PowerShell in side BASH. This is the perfect environment to start learning about Linux while you work in windows. We’ll be take advantage of how-to use cross-platform Open source product(s).

Topic: Looking into Windows 10 Bash Linux subsystem and PowerShell

Presentation and demo info: https://1drv.ms/f/s!Akqg632FQ1xUl091qQvhMIYw9Isq

I took the time to put in a blog all available recorded meeting for this year. All of these videos are loaded in YouTube site for viewing.

Florida PowerShell User Group Monthly Thursday, April 28, 2016
Topic: “Open PowerShell V5 recap and PowerShell Studio 2016”
Speaker: Maximo Trinidad

This is an open session review the latest new of PowerShell v5 and a look at the new SAPIEN Technology “PowerShell Studio 2016”. I will demo some script sample using SQL Server SMO and creating .NET Windows GUI.
PowerShell, Sapien PowerShell Studio

Florida PowerShell User Group Monthly Thursday, May 26, 2016
Topic: “The Essential PowerShell on Error Trapping”
Speaker: Maximo Trinidad

Do you to learn how to trap and document error while running PowerShell scripts? This session will cover the use and how to trap errors in your PowerShell script. We’ll be creating simple script providing some scenarios in trapping errors. At the same time, we are going to end up creating an error report.
PowerShell, Sapien PowerShell Studio

Florida PowerShell User Group Monthly Thursday, September 29, 2016
Topic: “Taking a look at PowerShell Cross-Platform”
Speaker: Maximo Trinidad

PowerShell is Open Source now! Come and see how you could use PowerShell in cross-platform between Windows and Linux sharing scripts to assist in admin task automation.  We’ll spend some time in Linux, and working with some of the editor(s) available for scripting.  Also, I’ll be providing information on how to contribute to  PowerShell Open Source.  This is a demo intensive presentation you don’t want to miss.
Linux PowerShell

In one of my previous blog, I mention about issue I found with SQL Server 2014 SMO not supporting the *.TruncateData() method. So, while working on one of my company SQL Server migration I need my script to cleanup some tables and I ended up doing a quick script to drop a selected list of tables.

Before we have the script, we need to create the list of tables. Basically, I had previously create two PowerShell objects and use the compare-object cmdlet to identify only the same tables found in both objects.

Then I can proceed to drop tables from the list object labeled $ToDelete:

[sourcecode language=”powershell”]
## – Create compare results of list of tables:
$list = compare-object -ReferenceObject $newSAP -DifferenceObject $oldSAP -IncludeEqual;

## – Save list for future reference:
$list | Where{ $_.sideindicator -eq ‘==’ } | out-file c:\temp\SAP_tablesToDelete.csv;
$list | Where{ $_.sideindicator -eq ‘=>’ } | out-file c:\temp\SAP_tablesMissing.csv;

## – Only get the list of tables to be deleted:
$toDelete = $list | Where{ $_.sideindicator -eq ‘==’ } | Select-Object InputObject;

## – Using SMO steps to work with tables:
$SQLServerInstanceName = ‘TSQLDSP01’; $SQLServerDatabasename = ‘dgSAP’;

## – Connect to SQLServer instance and get table name list:
[system.reflection.assembly]::LoadWithPartialName(“Microsoft.SQLServer.Smo”) | Out-Null;
$SQLSrvObj = new-object(‘Microsoft.SqlServer.Management.Smo.Server’) $SQLServerInstanceName;
$tables = $SQLSrvObj.Databases[$SQLServerDatabaseName].tables;

## – Step to go through tables list and the drop tables:
$global:cnt = 1; [array]$results = $null;
$results = foreach ($t in $tables)
{
## – Loop through tables to be drop:
foreach ($i in $toDelete)
{
## – Chekc each table $t in the $i selected list:
if ($t.name -eq $i.InputObject)
{
## – Drop table process:
## -> $t.Drop();
$r = “[$($global:cnt.ToString(‘000’))] – Sql $($t.name) = Object $($i.InputObject) removed”
Write-Verbose $r -Verbose;
$r; $global:cnt++
};
};

## – Refresh tables object without dropped tablename:
$tables.Refresh();
};
[/sourcecode]

This *script will assist in the third-party application to recreate the tables meeting for our migration.

*Note: Just in case, I commented out the line having the $t.Drop() method.