PowerShell basics and try-out samples.  Understanding PowerShell in its basic form can help you to overcome the hurdle.  I will post tools, tips and tricks.

This blog section will be describing my work with Microsoft Virtual Server application technologies, Such as:
1. Microsoft System Center Virtual Machine Manager
2. Hyper-V
3. Virtual Server 2005
4. Virtual PC 2007

Also, PowerShell will be covered in this section.

In this blog section I will provide some valid samples currently use at my workplace.  I'll be covering SQL Server version: 2000, 2005, and 2008.  Also, I will post some information on SQLPS.exe.

Take a look at the three part series on:
1. Connecting to SQL Server
2. Executing a SQL Command (using "Delete from...")
3. Read/Display Data from SQL Server

l be posting more thing in the near future such as using SMO and doing some SQL admin operations.  

 

Due to the fact that I have to also work with our IBM i5Series (aka AS/400), I needed to build a solution push data into the system.  So, using the "IBM iSeries Access for Windows" .NET provider, I was able to connect and use our DB2 databses in our i5 system.

It was hard for me to find information on How-to use the 'IBM iSeries Access to Windows" .NET provider to get my PowerShell script to work. I found one link (that I lost again) and a iSeries .NET presentation (C# code), help me complete these samples.

This blog section will provider with the necessary samples to:
1. Get connected to the i5 System
2. Do a SQL Query to a DB2 table
3. Executing a i5 Command

Please, make sure the your "security Office" provide you with the properly configured user ID and Password.

In this blog section I intend to post all of my PowerShell meetings content both Powerpoint presentations and Scripts samples.

As the new Windows 7 Beta is out, and with it comes PowerShell V2...