Tag Archive for SharePoint 2010

CiNPA April 4, 2012


I am very excited to be selected as a presenter for CiNPA.

The topic I chose for the evening, “How to use the out-of-the-box tools to create workflows that works for you!”

When: April 4, 2012 starting at 7:00 p.m.

Where: Cincinnati State Technical & Community College

Why:  Why not!

Who: CiNPA members and anybody wanting to know about technology.

How: That is the whole purpose of my presentation.  Smile

My current activity in the HeartLand Information Technology Community

What a great year!  I have been very active in the region getting to watch/learn from fellow professionals in my industry.  I seen various topics such as systems administration, development, database administration, networking engineering, and proven project management.

I have gotten to meet first hand with a lot of people that I have read about on the Internet or read their published books.  The social aspect of the these types of events are what I cherish the most.

Below is my list of past presentation schedules:

[box type=”info”]Presenter: November 3, 2011 – Cincy SPUG, Cincinnati, Ohio – Topic: SPDiag 3.0 toolset and all the possible uses with it.

Presenter: October 29, 2011 – SharePoint Saturday, Cincinnati, Ohio – Topic: How to Landscape, Baseline, and Performance Tune a SharePoint 2010 environment.

Presenter: October 6, 2011 – DANPA, , Dayton, Ohio – Topic: SharePoint 2010 Overview – How small business can leverage the SharePoint 2010 platform to meet small business needs.

Presenter: August 20, 2011 – SharePoint Saturday, Columbus, Ohio – Topic: SharePoint Diagnostic Studio 3.0 in action.

Presenter, January 11, 2011 – Dayton SharePoint User Group – Topic: Using PowerShell to create a SharePoint environment.

Presenter, June 3, 2010 Cincinnati SharePoint User Group. Topic: SharePoint 2007 Disaster Recovery Proven Tests[/box]

I cannot wait for the 2012 year to meet new IT professionals in the community and continue hanging out with the ones I have now established with in these groups.

SharePoint 2010 Service Pack 1 Finally Released!

Finally, finally, and finally!  SharePoint 2010 SP1 has now been officially released to the public.  Why does this excite me?  You know the length and process of getting SharePoint systems up-t0-speed with patches?  Believe me; they take time.   The good news is that all the cumulative updates are now including so now I can clear off 2.5 gigabytes of drive space to keep the other patches around. 

But please review these white papers located in the list below.   There is a required SQL Server patch associated to the Service Pack.


SharePoint 2010 In Plain English Video

Another must have SharePoint admin tool – ULS Viewer

As many of you are aware, reviewing log files are a necessary practice in our information technology industry.  But your standard NotePad on a Windows Server just cannot keep up when it comes to reviewing log files.

This tool has been around since 2009.   However, I when diagnosing a SharePoint 2010 farm, it was the tool of choice to help find the problem.  Here is the link.

Overcome Test-SPContentDatabase “Database too old error message”

Ok, I was thinking that I could quickly take a SharePoint 2007 content database, apply the minimum Service Pack 2 for WSS 3.0 and MOSS 2007, and then perform a database attachment within SharePoint 2010 in minutes while basking in the glory of the easy process.   I should have known this is SharePoint and everything is earned in this world.  🙂

I rebooted all the web front end servers and application servers just to make sure my little SharePoint 2007 world had the right build number of within Central Admin.   So I did a backup of the database and then moved the BAK file to the SharePoint 2010 Database instance and performed a simple restore.  For extra incentive and I was the DBO in the environment, I placed the SP Farm Account DBO to make sure the attachment goes ok.

I ran the PowerShell commandlet Test-SPContentDatabase to verify the database.  Then I got the error.

[box type=”warning”]Category: DatabaseValidation Error: True UpgradeBlocking: False Message: This database [SSPBeta] is too old and cannot be upgraded. Remedy: Upgrade this database to Windows SharePoint Services Version 3, SP2 or later. [/box]

[box type=”info”]So after I read multiple blogs, forums, etc.; I wanted to think outside-of-the-box. I tried an idea. “Maybe the commandlet needed a build number newer than”

So I got the April/2009 Cumulative update for WSS 3.0 and MOSS 2007. So I applied these two CU’s to the SharePoint 2007 Environment.

I verified I was on build number [/box]

Just like washing your hair.  Rinse and Repeat. 

So I did a backup of the database and then moved the BAK file to the SharePoint 2010 Database instance and performed a simple restore.  For extra incentive and I was the DBO in the environment, I placed the SP Farm Account DBO to make sure the attachment goes ok.

I ran the PowerShell commandlet Test-SPContentDatabase to verify the database.

 [box type=”shadow”]Then Poof!!!   The Test-SPContentDatabase command liked this minor build update.[/box] 

 Resources for review:

I welcome any feedback.

SharePoint 2010 Attach Content Database – Alerts not working now FIXED

So I took a SharePoint 2007 SP2 compliant and tested content database and placed it into a SharePoint 2010 enviornment.  All the content was there.  The permissions were fine.  However, by database attachment went to a new SharePoint 2010 web application that had a different URL name.

Example:  intranet.company.com SP 2007 content database was attached to sp2010dev.company.com

This URL change throws off alerts.  You can delete the alerts and add them back in but that is just crazy to think about that scenario.  And guess what…..there is a PowerShell commandlet to fix this issue. But unfortately, this answer is buried on search engines.

Anyway, there is the PowerShell commandlet.

[box]Invoke-AlertFixup -site <NewURL> -oldurl <OldURL> [/box]

Here is the exact Technet article to reference.

How to connect Access to SharePoint 2010 if the feature within a view and/or list is missing.

Anyway, when I went to list view; the button to “Open with Access” was greyed out. I went into my settings and tried to create a new view with Access. It wasn’t there either.

Steps below:

  • So I opened up Access 2010.
  • Then chose the OPEN feature.
  • What is cool is in the drop down area; there was a item called, “SharePoint Foundation Services.”
  • I copied and pasted the URL to the SharePoint calendar that I needed to update…….

And then *POOF!* *MAGIC!* I can then update data via Access.

Happy SharePoint-ing!


How to add Content Type to a SharePoint 2010 Wiki Library

 I wanted to use content types to drive navigation to a Wiki Library in SharePoint 2010.  I thought this would be the same thing just like any plain ole’ Document Library.  But no its not.  🙂  It’s buried and I happen to find it by trial and error.

[box type=”info”]

Go to the default home page of the wiki site. It is usually named, “Home.aspx” Edit the page.

Add a web part.

I used the Wiki Library I created as the item to add to the page.

In SharePoint 2010 in the ribbon, you will see new areas. Editing Tools, Library Tools, and Web Part Tools.

In the Library Tools area, you can now get to the proper Document Library Property page.

Now you can modify the Wiki Library as a Document Library have the content types in the library.


Contact me if you have questions about this information.

Here is the Microsoft Forum that I placed my information to help out the user community. 

Believe me, I rely on this community all the time.  It feels good when I can give back.

Cincinnati SharePoint User Group – September 2, 2010

I will be talking at the September 2010 Cincinnati SharePoint user group.

Topic:  SharePoint 2010 and incorporating video.

SharePoint Saturday – Columbus, Ohio

I have my ticket and plan to be in attendance to SharePoint Saturday on August 14th in Columbus, Ohio.

Here is the official link.