December 2010 – Max Trinidad – The PowerShell Front

Just to let you all know that we have something cooking in Tampa in March 19th. We are organizing our first event by the community, for the community.

Event: ITCamp for IT Professionals

Location: KForce – Tampa FL

Event Date: March 19th, 2011

Time: 8am-5pm

Sessions: Four Different Tracks – Including multi-sessions.

Session Times: 40 mins with 10 mins Q and A (50 mins total)

4 Tracks are:

– Windows 7 Deployment, Systems Management

– Office, SharePoint and Office WebApps

– Windows 7 Mobile, Cloud Sessions

– SQL Server Administration

We planning to cover PowerShell in most of the tracks.

This event is been spearheaded with the help of our Microsoft Senior IT Pro Evangelist for the Southeast (FL, AL, and MS) Mr. Blain Barton (http://blogs.technet.com/blainbar ). We want to spread this concept throughout the Southeast and possibly many more areas… just like SQLSaturday if possible.

I’ll keep you all posted.

Although, this is not PowerShell, I do work with SQL Server and SSIS packages. I shouldn’t be surprise to find problems because I installed a CTP (Community Technology Preview). I do expect to have some issue so I can figure out the answers, find the workaround to fix it, and then blog about it.

Well, here’s one issue I found after installing the new SQL Server ‘Denali’ CTP1 on my Windows 7 along with my RTM version of SQL Server 2008 R2. I needed to develop a new SSIS solution using SQL Server 2008 R2 BIDS and I ended up with the following error:

So, my first thought was, Oh-Oh!! Machine rebuild!

But, after having good experience with the recent release of SQL Server uninstall process, then I decided to do the following steps: ( and it did work for me )

1. Under your Windows 7, Control Panel | Programs | Uninstall Programs, go to and right-click on “SQL Server Denali CTP1 Setup” or “SQL Server Denali CTP1 Setup (64bit)” and select “uninstall”. You may need to media in order to proceed with the uninstall.

2. Go through the SQL Denali uninstall setup steps, until you reach to the “Select Instance” where you pick to “<<Remove shared features only>>”.

3. Now, you only going to “Select Feature” you really want to uninstall, which is “Business Intelligence Development Studio”. Click Next to continue.

4. At the “Removal Rules” click Next, and at the “Ready to Remove”, Click Remove to start the uninstall process.

5. You will get the following screen, click Close to finish, and you will need to restart your machine.

Are we done yet? No!!

I want to make sure I uninstall all BIDS versions starting with SQL Server Denali and then SQL Server 2008 R2. So, we need to repeat all previous steps but for SQL Server 2008 R2:

After, you’ve done repeating the steps and everything completed successfully, now we can install SQL Server 2008 R2 in order to recover this BIDS version.