Archive for the ‘Commentary’ Category

Stale for a reason

Posted by sharepoinTony on December 12, 2011

The holidays are here and this blog has been neglected for long enough. The neglect is not without cause; I have simply been quite busy with SharePoint installations, upgrades, migrations , implementations and family matters. Everyone seems to experience the hectic feeling that seems to captivate us at the end of the calendar year. But the time has come for me to play a little “catch-up” with this blog.

I have a few things pending, so I won’t offer up much now, however I have started working on a few changes that I hope to have in place by New Years.

Until then,
Happy Holidays & thanks for browsing my blog!

Posted in Announcement, Commentary | Tagged: Announcement | Leave a Comment »

USPJ does a great job

Posted by sharepoinTony on September 26, 2010

I finally got to read through the latest Understanding SharePoint Journal and I have to say I was impressed.

The journal is clear and concise, it is very informative, and it is very easy to read. The level of detail is great for anyone learning about SharePoint and provides sufficient information to allow you to build something of value by the time you finish reading. In fact, the examples allow you to follow along and build something while you are reading.

The format of these journals focus on one topic at a time, allowing you to get more depth in the topic and learning more without feeling like you sat through a lecture. The coverage of the topic is excellent and fits the audience well. I highly recommending the Understanding SharePoint Journal to anyone trying to learn SharePoint or learn more about SharePoint. I certainly learned more about SharePoint 2010 Workflows than I expected after reading this issue.

Kudo’s to Bjorn and the USPJ team.

Posted in Commentary, SharePoint Tools, Workflow | Tagged: 2010, Learning | Leave a Comment »

What not to do – buying web parts

Posted by sharepoinTony on September 10, 2010

This is a message to business managers trying to solve problems using SharePoint.

First, good job using SharePoint!

Now, please DO look at the options available to you that will help you get things done or enrich your SharePoint environment.

Please DON’T puchase web parts without talking to your SharePoint Administrator, Specialist or whomever you have focused on SharePoint.

Why? Well, here is a short story (which I will call a fairy tale) that should make my point.

Once upon a time there was a department looking for a more robust solution than was available in their OOTB SharePoint 2007 environment. They happily danced around while looking for solutions and discovered a shiny web part package that was priced very well. The joyful department manager purchased the package and gleefully notified the SharePoint Administrator of the wonderful find. The glorious admin reviewed and installed the tool and went about configuring for the perfectly good solution for the happy department.

The happy department requested a meeting. Before they start using this new dandy they want a few changes. The excitement filled the air as the team listed requirements for their solution. What’s this? They want to change the columns used by the solution’s installed list. They want the solution to use existing InfoPath forms. Gee, that seems reasonable doesn’t it?

A cloud of darkness appeared over the happy crowd, evil seemed to rain over them, sadness ensued.

You see children, the solution is a good one only if it meets the requirements set forth in the beginning. Oops, no requirements had been written. That’s OK as long as the needs to enrich the environment and make the identified task easier for the joyous department members are met. Oops, the solution won’t allow those desired changes to the list. Oops, it will not allow the use of InfoPath forms.

Hmm, what went wrong?

Then End.

Posted in Best Practice, Commentary, SharePoint Tools | Tagged: Best Practice, SharePoint, Web Parts | Leave a Comment »

Daily Twitter Newspaper

Posted by sharepoinTony on September 8, 2010

I am really getting hooked on reading articles in the #sharepoint Daily and the SharePoinTony Daily !

Tweets containing links to articles, videos, and photos are captured and placed in an online newspaper format for you to review. I often miss many great tweets with excellent articles and reference material because of when they are tweeted and what I am doing (not watching twitter). Reviewing the Daily daily helps me find those gems.

The topics sometimes range from things like PowerShell cmdlets, SharePoint governance, and Microsoft announcements to new books, vendor announcements and wacky photos. This displays the breadth and depth of the SharePoint community. Recently there was an article on “Boss Management” and another with photographs of Pakistan’s deadly flood. These things are not gathered by a news organization and placed on these daily’s…these are things that SharePoint people are talking about, promoting and sharing with the community.

What I find interesting is that these daily papers can be personal or social, but are always very different. It is amazing how different they are, even with the overlap and occasional duplicates between them, they are unique to the ‘owner’. Thinking about it, if you read the SharePointTony Daily you are reading things that the people I follow are posting. If you read the #sharepoint Daily you are looking at the posts by anyone in the twitter community who uses the #SharePoint hashtag. If you create a daily with a narrow focus you can get a very personal “paper”.

In testing out this concept I created a daily paper using a SharePoint MVP and Certified Masters twitter list. I also created one for my family, it obviously has a very small number of “articles” posted but it could be a great family sharing tool. These have a much more personal feel and I can’t wait to monitor them over time to see how I feel about them months from now.

With the growing number of social media outlets, sites, and tools it can become overwhelming. I hope the growth doesn’t create competing twitter Daily papers, but rather complimentary papers each with their own personality. For example, I look forward to reviewing the EndUserSharePoint Daily and WonderLaura’s Daily to find other gems I missed or might have never seen.

Try searching for newspapers, check out the SharePoint 2010 Daily – it is slowing growing as people use the #sp2010 hashtag – and build your own. Look at the media with a different point of view and often you will see something new.

Posted in Commentary | Tagged: Commentary, SharePoint, social media | 2 Comments »

Moving MOSS 2007 SQL Databases part 3

Posted by sharepoinTony on July 27, 2010

If you haven’t seen the earlier posts on this topic: Part 1 and Part 2

D-Day has arrived, it is time to actually move my SharePoint 2007 sql databases to a different SQL Server. My previous posts touched on the research I did leading up to this event. This post will cover the actual tasks and outcome. I am writing this as I go through the process, so let’s all cross our fingers that it goes smooth.

My Plans

A summary of my plan is as follows:

Backup the SharePoint farm
Backup all SQL db’s
Move those backups off to a “safe” spot on the network.
Start the process defined in the TechNet article Move all databases (Office SharePoint Server 2007)
Backup the SSP’s
Remove SSP’s
Stop the Farm (services)
Backup sql db’s
Copy backups to new sql server
Restore sql db’s on new sql server
Apply roles, permissions, etc. to new sql server & restored db’s
Restart Farm
Restore SSP’s from backup
Cross-fingers and check to see that our SharePoint intranet is up and running
Go have a beer

Round 1

I attempted these steps and all went smoothly until I got to step 13 – Restore SSP’s from backup. The restore made it to 50 percent complete then ran into this error:

SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

After several attempts and a grueling session of troubleshooting I found that the SQL Server Agent was not running on my ‘new’ SQL server (SQL Server 2008 R2 64-bit, running on Windows Server 2008 64-bit). The fun part was that I couldn’t get it to start. The Agent would just stop after every attempt to start it. I tried several solutions found on-line, none of which worked.

At this point my weekend was over and we needed the production server back online, so I did the restore BACK to the original SQL Server. SharePoint was up and running fine very quickly.

Finally, I un-installed SQL Server 2008 R2 from the new server and started over. After carefully reinstalling SQL Server 2008 R2 I no longer had any problem with the SQL Server Agent. Hurray, now will the SSP restore work? I have to wait until the next weekend to find out.

Round 2

Friday – A week has gone by and I am now preparing to walk through all of those steps again. More confident than last time perhaps, but concerned at what I might run into this time around. I will do all of the initial steps – the backups – tonight, Friday night. Saturday morning I will start the scary part, removing the SSP’s and moving everything to the new SQL Server.

Saturday – Everything went well up to the restore, again. This time the error was an Access Denied error pointing to the SharePoint backup directory. Short-story resolution: change the SQL Server account to use a Domain account, make sure that domain account had permissions to the backup folder and to the sql database files folder. I also wanted to make sure I didn’t have any more trouble getting to the backup folder so I opened it up (temporarily) to several other accounts – my ssp and app-pool users.

The SSP Restore completed successfully, with zero errors and zero warnings. Hurray!

Hold-on, the process outlined by Microsoft ends here. What about my content databases?

Searching about I found that I need to use stsadm to detach the content databases, one by one, from the SharePoint server and add the databases on the new server. So I begin this task and have no problems until I get to the Config database. It detaches fine, but then the services become disabled and the attach (setconfigdb) results in “Value cannot be null. Parameter name: str” ! What the?! Time for Microsoft Support calls.

Support helped resolve the ‘migration’ issues, however now the SSP is not working-including search, and there are several other things missing. I am told I will have to add any solutions back in, and find whatever features or web parts that might not work and fix them. Also have to open a new ticket for ‘advanced troubleshooting’ on the SSP. It has been a long Saturday.

Round 3

Sunday – Monday (ouch)

After hours on the phone and several rounds of running psconfig we were able to get a new Config db setup and restore over it to capture most of my configuration data. The SSP is a different story. We had to create a new SSP, which left me with a few more days of reconfiguring the SSP, Search, Audiences, etc. before I was “back” to normal.

Wrap-up

Some good came from this pain… since I had to reconfigure the SSP I could apply some lessons learned since the original install. Now I feel like my SSP is “better” than it was before.

I improved our Search features, including a federated search we were using, I cleaned up some Audiences that were not used, etc. I just had to find some improvements!

Posted in Commentary, Install & Configure, SharePoint 2007 | Tagged: SQL | 2 Comments »

SharePoint Conference “season” never ends

Posted by sharepoinTony on June 9, 2010

If your new to SharePoint, or have been working with it for awhile, you should notice that there are lots of conferences and events. This is a good thing, actually it is a great thing for the community. Variety and options are always good and in this case essential to bring information to the large and growing crowd of organizations using SharePoint. If you are trying to choose a conference, often the options are overwhelming. I know, I have been there. I wanted to go to all of them and not miss a thing when I got started with SharePoint.

OK, to be honest, I still do…but that isn’t the point of this rambling article. I’ll get to the point soon, I promise.

Unless you are a SharePoint consultant or vendor you can’t attend all of these events due to budget and time constraints. So don’t let it get you down, look at the volume of conferences and events as a great opportunity for YOU to work some of them into your schedule. Think of it this way, what if there were only one SharePoint conference a year and you couldn’t attend because of some conflict? Ouch!

As others have pointed out, choosing a conference depends on your needs and environment. You have to decide what conference is best for you & your situation. You have to look closely at the conference and the sessions offered to see what fits your needs. My best tip is to review the session abstracts, do the work, and choose what works for your schedule and budget.

The bottom line is, I love SharePoint Conferences! I loved attending the Best Practices Conference last year & SPTechCon in San Fransisco earlier this year – and I got a lot out of useful information from both of them. The SharePoint community is awesome and you get to experience that first-hand when you attend any one of the conferences or any of the other SharePoint events such as SharePoint Saturday (another awesome set of events!). That is why I have a bone to pick with all of the conference organizers out there. [Ahh, now we are finally getting to the point.]

Here is the conflict as I see it…

SharePoint 2007 is huge, there is a very large user base, and many companies have invested in this platform.
Microsoft always pushes business to stay current and upgrade software. With the huge 2007 base, they are eager to get everyone to move to SharePoint 2010.
Businesses always need to strech their investment, and they focus funds on strategic needs rather than constantly upgrading tools used to run their business. Therefore, many, and I emphasize many, are not rushing to upgrade to SharePoint 2010.
Budget dollars are shrinking. Training and conference spending is scrutinized more than ever before. People have to justify going to conferences. If your company isn’t moving to SharePoint 2010 in the near-term you have a very hard time justifying your attendance at nearly any of the SharePoint conferences this year.

Conference organizers (and Microsoft) fail to recognize these points (IMO) and are making it hard for many (like me) to attend. I know, I know, many of the conferences have some 2007 content. But we are talking scrutinized justification here. Would you pay for someone to go to a conference where only 25% of the conference was applicable to your company? 10%? 5%? Business managers are looking for higher percentages than that.

Thousands are attending SharePoint Conferences and events, but that doesn’t mean businesses only want 2010 content. It means there are thousands who are new to SharePoint and want to start with the latest version. It means that some businesses are ready to upgrade and are looking for the 2010 focus. It means that the huge SharePoint 2007 community is left without a conference.

Will there be a conference with lots of topics around migrating to 2010 next year when many businesses are finally considering the upgrade? What about 2007 topics for the next 2 years?

Companies feel like they are behind the curve often enough because software and hardware vendors continue to innovate and push those upgrades (a good thing). That is why we need conference organizers to bridge the gap and provide content that leads them to the latest version. We just need them to do it closer to the pace of most businesses internal software lifecycle.

The truth is that most companies don’t want to upgrade until after new release settles in – often after sp1. Businesses approve attendance for conferences that help them deal with today’s challenges more often than they do for ‘preparing for next year’. They want to know that something will be addressed in this quarter or next quarter because of what is gained at a conference.

So Conference Organizers, you are missing a whole segment of the market and leaving lots of potential customers behind.

That is my opinion.

UPDATE –

Since the original posting of this rant, the organizers of SPTechCon and The Best Practices Conference have communicated and corrected some of my beliefs. These specific conferences do in-fact have a significant amount of content either applicable to or directly focused on SharePoint 2007. Clarity in my message was needed and I am thankful for the input.

I still feel that the marketing and focus of some conferences are overly “2010″ and that feeds the hype created by Microsoft for the purpose of pushing upgrades on customers. That said, I have to agree to the valid points made in the comments section of EndUserSharePoint by these organizers. Their response is further evidence that this community is awesome and demonstrates another reason why I loved attending the above-mentioned conferences. My Thanks to David Rubinstein and Bill English for your insights and efforts, we all appreciate how much you care about your attendees!

Posted in Commentary, SharePoint 2007 | Tagged: Conference, SharePoint | Leave a Comment »

Moving MOSS 2007 SQL Databases part 2

Posted by sharepoinTony on May 11, 2010

Today I am looking at the AvePoint DocAve option that I dreamed up when faced with the need to move my SharePoint sql databases to a different sql server.

DocAve is a great backup tool, and the features it provides for disaster recovery are nice. The product, once installed and configured(1), allows your system admin or SharePoint admin manage backup and restore activities easily. The system can even be configured to allow others (Site Collection Administrators for example) to restore their own sites, lists and libraries. Access is controlled, making this feature a bonus to SharePoint Administrators in larger environments.

In my scenario, where I want to MOVE all of my SharePoint databases to another SQL server, there is a little weakness displayed in the DocAve armor. The ConfigDB, SPWebService, CentralAdmin WebApp, and Admin ContentDB’s can only be restored “in place”(2). That means the destination sql server must have the same name and configuration as the sql server where the backup originated. I can’t restore those db’s to a different sql server, thus I cannot complete my task using DocAve. To be fair, I could use DocAve backups to accomplish part of my task, just not the whole task.

This situation is not common, so AvePoint shouldn’t be dinged points for the DocAve product – my guess is that it handles at least 95% of the requirements for pretty much any SharePoint shop. I like the product, use the product and might even recommend the product…I am just bummed that it isn’t magically making this specific task drastically easier. I guess that is why there are migration tools out there.

Continue to Part 3

Footnotes:

1. Another post may cover the install configuration process for DocAve based on my experience. This is an area where I think AvePoint could improve.

2. Information obtained from the “Platform Backup and Restore” whitepaper from AvePoint.

Posted in Commentary, SharePoint 2007 | Tagged: SQL | Leave a Comment »

Moving MOSS 2007 SQL Databases

Posted by sharepoinTony on May 10, 2010

I have a MOSS 2007 implementation that consists of a SharePoint “farm” on one server and the SharePoint databases on a shared SQL Server. The SharePoint server is running Windows Server 2008 and is 64-bit, but the SQL Server is on Windows 2003 with SQL 2005.

One of the other applications using this shared SQL server is fairly critical and the performance is starting to take a hit. This has opened an opportunity to get our SharePoint databases moved to a dedicated SQL server.

I don’t know if anyone else out there has a similar hardware situation or not, but I thought I would try to post a few thoughts as I go through this process over the next few weeks. Let me know if you have already done this or think I am taking a wrong turn as I go.

One idea I have is to take full advantage of the need to move and upgrade to a SP2010 compliant SQL system – and go to SQL 2008 while I am at it. Good idea or bad idea?

Another thought is to investigate whether or not I can make use of our recently implemented DocAve Data Protection software from AvePoint. Maybe I could ‘act’ like a disaster happened and I need to restore my SQL Server on a new box. I wonder if that would work, and if it would be any faster/easier?

Let the investigation begin.

My first stop is with this TechNet article, Move all databases (Office SharePoint Server 2007): http://technet.microsoft.com/en-us/library/cc512725.aspx – my light reading for tonight.

Continue to Part 2

Posted in Commentary, SharePoint 2007 | Tagged: DocAve, SQL | 1 Comment »

Where have I been?

Posted by sharepoinTony on March 25, 2010

Well, sometimes timing is everything and that applies to the past month for me.
I have had some big deadlines at work and have purchased a home, have been working on fixing that home up, and then have started moving into that home.
So that is why I haven’t been very active on Twitter or posting to my blog. I am hopeful that the big crunch is nearly over and will get back to a more normal pace soon. Only about 50 more boxes to unpack…

Posted in Commentary | Tagged: Commentary | 1 Comment »

« Previous Entries

@info – The practical side of SharePoint

Follow Me

Feedburner RSS

Twitter

Follow Blog via Email

SharePoint Blogs

Say What

categories

Blog Stats

Tags

Categories

Archives

SharePoint Links

Books on SharePoint

Pages

Recent Posts