Welcome to MSDN Blogs Sign in | Join | Help

Update your feed, favorites and bookmarks to www.sharepointjoel.com

First and foremost, this blog is not going away.  I won't be contributing here after this post.  All new posts will be on http://www.sharepointjoel.com.  It's a work in progress trying to get it setup the way I want it to be.

My RSS feed has been updated automatically.  If this is the last post you've gotten, then you need to update to the feedburner address which is on http://www.sharepointjoel.com or the RSS link on this site.

The Feed you should be subscribed to is: http://feeds.feedburner.com/JoelsSharepointLand that's where my feed is going.  If this is still the last blog in your feed then you are missing out BIG TIME!

Posted by joelo | 4 Comments
Filed under:

SharePoint in the Middle East

I'm so jazzed about my upcoming trip.  I wanted to share just a bit of my travel plans, and give a shout out to the user groups as well as call out the sessions I'll be speaking at.  Hope you enjoy some points of interest on my upcoming trip.  Hope to see you there.  I'll be hanging out with Todd Klindt, Eray Chou, and Jerome Thiebaud and look forward to meeting the other speakers, MVPs, and customers.

 

Let me know if you're going to be there, and don't be afraid to stop me and say hi, shalom, Es salaam aleikom, Salaam, Ahlan or other local greetings!

 

Jordan SharePoint User Group

Muhanad convinced me with his 7 reasons Joel should visit Jordan.

Current plans are casual Q&A SharePoint Night out with Joel with Arabian food.   I'm looking forward to the lamb and coos coos and steamed carrots and those soft pillows. 

Meeting Details

 

Date: March 31, 2008
Time: 7 PM – 10 PM
Location: Reem Al Bawadi (near Amman Mall)
Description: Dinner and Q&A SharePoint Night with Joel Oleson

More details on the Jordan SharePoint User Group site

Israel Office System User Group

It was Avi (MOSS is my middle name) who convinced me to come visit the holy land and spend some time with MS and HP customers and meet up with the Office System User Group there in Israel.  If TechEd Israel wasn't on Sunday and conflicting with the Dubai SharePoint conference I'd totally be there.  Next year... put me in your list.  Love to speak.  Contrary to Bill Gates, I do need invitations to know I'm invited to speak.  (Inside joke with Avi.)  Would be nice to assume I can speak at any conference I'd like to.  I hope to be getting to that level, but no guarantees :)

 

SharePoint Conference Dubai April 7-8

My sessions:

April 7

10:15 - 11:15 SharePoint Server 2007 Administration Fundamentals

11:30 - 12:30 Chaos No More: SharePoint Governance and Adoption

April 8

9:00 - 10:00 SharePoint 2007 Advanced

 

SharePoint Conference Istanbul April 10-11

My sessions:

April 10

10:15 - 11:15 SharePoint Server 2007 Administration Fundamentals

11:30 - 12:30 Chaos No More: SharePoint Governance and Adoption

April 11

9:00 - 10:00 SharePoint 2007 Advanced

 

Things to do in Petra, Jordan.

 

Treasury

 

Treasury, Petra, Midday - Petra

The name "Treasury" came about because of a local myth that pirates hoarded their treasure inside the urn on top of the facade. In fact you can still see the bullet marks where the local bedoins tried to crack open the urn with their rifles. Inside the Treasury you won't find the Holy Grail, as was depicted in Indiana Jones and the Lost Ark

 

The Siq

The Siq - Petra

The 1.5 Kilometer passage to Petra of what use to be a water channel dammed up by the Nabateans.  Go early in the morning for the best viewing and for silence.

 

The Monastary

Al Deir - Petra

The biggest most impressive carved building in Petra.  Expect a bit of a climb and a lot of steps.  You might consider a donkey on this one (don't pay 35 JD, local guides can get them for 2).  Donkeys and camels get cheaper as the day goes on.

 

High Place of Sacrifice and Tombs

View from the High Place - Petra

View of the tombs from the high place of sacrifice.  If you think you've seen it all with the Treasury and monastery there's more.

 

Dubai

Dubai Things To Do

You'll find the ski area in the Emirates Mall.  Don't forget your gloves and hat, you rent everything else.  2 hours for 28 euros.  Also Burj Al Arab hotel, you have to check it out.  Of course, there's also sand bashing one of the more common things to do.  If you want to see the city from a different view consider the helicopter tour.

Istanbul

Hagia Sophia

The gorgeous Aya Sofia Church/Mosq - Istanbul

One of the greatest churches in history.

 

Blue Mosque

Blue Mosque in Istabul - Istanbul

Largest in Turkey with 6 minarets. No cost.

 

Topkapi Palace

Topkapi Palace - Istanbul

Palace of Ottoman sultans for 350 years... now a museum.  Don't miss the harem, throne room, and treasury.

 

Grand Bazaar and Spice Bazaar

Kapalikarsi - Istanbul

Why not go shopping in the oldest mall?

 

Where else can you see Europe and Asia in one city?

Jerusalem

East Jerusalem just beyond the Wall. - Jerusalem

 

The Wailing Wall (Western Wall) - Jerusalem

Wailing Wall.  Western wall to the temple.

Israel Museum

Has the dead sea scrolls and archeological finds, considered top 10 in the world.

Bethlehem Church of the Nativity - I might pass on this one.

Way of Sorrows, Church of the Holy Sepulcher

The Church of the Holy Sepulchre - Jerusalem

Mount of Olives

View from the Mount of Olives - Jerusalem

Garden of Gethsemane

Olive trees in the garden of Getshemane - Jerusalem

 

Golgotha

Golgotha

Posted by joelo | 4 Comments
Filed under: ,

Coolest online translation utility for global reach

I don't know if you've ever seen a blog with a little drop down with "translate" in it .  I saw one today by following some track backs to others that were in job changes the choose your own adventure post was a great analogy.  I must admit I was so surprised by it, I hit the drop down and saw how you could dynamically change the language and hit the button and boom it would send the blog off to be translated.  (Credit for where I found it goes to Hanselman, I snippet it from there.)  Very slick.  (You can try it on this blog to the left)  I simply added this one little line of code.

<script type="text/javascript" src="http://translator.live.com/TranslatePageLink.aspx?pl=en"></script>

image

 

Here's my blog translated into Arabic, how slick is that?

image

 

Add the web page Translator to your site: http://translator.live.com/AddIn.aspx?MKT=en-US

Get one-click web page translations with the Windows Live Toolbar Translator Button.

I can imagine this might be just a bit easier to manage than variations.  :)

Looks like there is a desktop version for translating word docs and stuff for pretty cheap... http://www.systransoft.com/live?mkt=en-US

Posted by joelo | 6 Comments
Filed under:

What About Resources for End Users?

I really don't like the term end user.  Sounds like it's over.  It's the end.  Client or Cutomer is nicer, but client sounds like an application and customer sounds like a business.  Information worker sounds like they must be smart (that's not so bad), and knowledge workers sound like they are all about filling out taxonomies and love workflows.  Not sure if gurus, power users, and champions work, but that's even different.  Those people know this stuff.

It's true I don't say much about end users, because my focus is IT Pro.  I came across a post titled "I will never be Joel Oleson" that included my picture on a day I hadn't shaved for a couple of days.  The person was talking about the SharePoint greats at the SharePoint Conference.  Personally SPC2008 last week was a pinacle for me, so thanks for the praise and "wanting to be like Joel" is pretty flattering, thanks Mark.  AC is amazing and blows my mind and he should get credit.  Todd Baginsky makes development and integration seem like cake, so I can understand that.  SPC2008 was the first conference I've ever had the #1 session, so that feels good, especially with over 100 SharePoint sessions and the top SharePoint speakers from around the globe. The comments in Mark's post really do support that we do need people that care about users that do care about what really make the SharePoint world go round.  It's that 100 million users (ok, sure that's licenses and all that isn't yet deployed) that really decide if the platform is doing what it was designed for.  A super well tunned, well managed deployment can still be junk, if the users don't know how to use it or how to adopt it.  Enough of the rambling...  A good deployment has resources and training for it's end users... So here's my list of top references for SharePoint Users.  (Oh, and by the way there is plenty of room for experts and bloggers in the IW and end user space.  Welcome!)

One question I get most often around end user support is around cross browser supportability.  If you have Non IE contributors I recommend looking at the Telerik web parts for 2007 designed to work with SharePoint to enhance the cross browser experience.  Beyond browser it's an Office question.  Did you know an XP vs. 2003, vs 2007 client document comparison was done?  The Office Client comparison of Good, Better, Best Whitepaper was put together to describe the integration experience with the different releases of Office.

Posted by joelo | 6 Comments
Filed under: ,

Moving on...

Oh, the opportunities with SharePoint.  Oh the places I’ll go!

I have a lot to thank Microsoft and SharePoint.  It’s was one of the hardest, but best decisions I ever made taking a pay cut to come work for Microsoft, and moving my family from Plano (Murphy), Texas to a Redmond Washington suburb, Duvall.  It’s been a wonderful ride and I have a ton of people to thank for both the opportunities to work with them whether for pleasure or lessons learned through hard knocks.

If SharePoint was a person then I’d give her a big kiss.  She’s been really great. I'd also tell her, I'm not going anywhere.  I'll still be there for her.

So, I’m on to the next step in my career.

What will I be doing?  That’s an interesting question.

·         SharePoint Global evangelism

·         SharePoint Consulting, whitepapers, advisory and analyst work

·         SharePoint Community involvement

·         Speaking at SharePoint and Technical conferences around the globe 

All of the above.  What I don’t know is who I’ll be doing these things for yet, or if I’ll be doing them for myself.  I do plan to make a decision one way or another in the next few weeks.

Don’t miss me, cause I’m not going anywhere.  I’m still Joel Oleson in the blogosphere and I’m still as passionate about SharePoint as I was yesterday.

Love,

Joel Oleson

Your favorite SharePoint Blogger. 

 

 

 

Posted by joelo | 33 Comments
Filed under:

Evaluating SharePoint Partner Solutions and Applications built on SharePoint

With the SharePoint Conference there are a number of new partners in the SharePoint space with more coming every day.  How do you keep them straight?  How do you know if they are going to treat you well?  I've been thinking I need to put together a litmus test for SharePoint partners.  The SharePoint team doesn't have the resources to do certification on the product or have "logo'ed" partners, but there are ways of telling how well their solutions will do under scrutiny.  I've come up with a simple set of questions you can use to find out how well the partner follows the "rules."

You'll also find these questions aren't just for partners, but good for your business and dev teams.  Push them to give you the answers.  If they try to follow these Five simple guidelines or have good answers to all of them we'll all be better off.  Budget constraints are not a reason to skirt these guidelines.  These are real no brainers, but I figure spelling this out will help you have the right conversations.  If you think I'm wrong let me know.  With all these, I hope you're following the guidance for managing this all in a dev, test, or build environment.  You don't want to find out that the production environment is being impacted by these.  You can nearly validate most of them in the test environment before they make it production.  Don't just take their word for it... that's what I'm saying.

Instructions for keep partner solutions or your dev teams inline

1. Do they directly update or modify the database?  You should find out what the solution is doing and why they are doing it before going with any solution that directly accesses and modifies the database.  One of the riskiest of solutions is based on an assumed database schema.  Given there are partners that are out there that have found no other way to do what they are doing, but the better you can understand these things and as well encourage MS to expose these things via the object models, web services or other APIs the better off all of us will be.  Think about supportability as well.  CSS isn't going to be excited to work on your environment if they know database modifications have been made.  Modified stored procedures are a no, no.

2. What is the residue or footprint if you remove it?  Is it a solution or feature? Can that solution be removed cleanly? Some of the nastiest solutions I've ran into have very messy solutions where when you run the remove programs or in more recent cases remove the solution through either the UI or stsadm, the pages puke.  I mean they throw chunks.  Sorry for the sad picture, but yes this means they hemmorage errors and won't render anything.  If they say, yes there's residue, the follow up should be how do I clean up this residue?  If they don't have a good answer then run.  I wish the product had better answers, but today it means building responsible code or getting the devs to build hunter tools to track and remove residue. 

Demand Solutions and Features or MSIs... You do want your DLLs in the form of solutions that can be easily deployed, removed and managed.  I tell customers they should demand that their developers do it this way.  You should expect the same or better from a partner solution.  The partner should be thinking ahead to what happens when the evaluation is over.  If the evaluation is over and it destroys your environment and doesn't remove cleanly you're both in trouble.  Some web part solutions will never have a good answer to this, and when that's the case it's important that you acknowledge a plan for how to deal with these.  Is there a tool that will be purchased or provided to help out the operations and support team?  What is the configuration management plan or release plan and how do you decide how to remove it?

3. Do they have an upgrade path?  How will this be upgraded when it's ready to be upgraded? If the partner themselves has only been around for a few months, they may have some suggestions for what they might do.  New partners should be given a chance, but you should ask for maintenance agreements through upgrade.  Even if its your dev team within your company or a scarier a consulting company who is simply working on a "short term project" to address a "highly critical" requirement, they or you or your business must allocate budget for the future.  Dev projects are not just pay once.  With the 3 year cycle of SharePoint, you'll be revisiting these solutions and add-ons and you'll want to have a contingency plan for supportability and upgrade, or what does #2 look like when the functionality is now in the product?  They get paid the bucks to come in and what do they do... they think short term and not about upgradability and supportability.  That's why you'll see custom site defs and list defs.  Easy answers, but not good answers.  More and more you'll find application based SharePoint deployments *need* a dev to complete the upgrade as a result of custom code including customizations that either were modifications to out of box pages or new site and list defs.  Those are the hardest ones to address.

4. What is the support and sustainability for the app or solution?  How often is something rolled out and you have support for the solution for a couple or three months and then the dev leaves the company, the consultants roll off at fiscal or budget runs out?  Hey everythings good right?  We haven't had any issues up to now.  Why would we have issues in the future?  I'll give you 5 reasons... 1) service packs 2) hot fixes 3) upgrades 4) server rebuilds 5) unexpected errors.  As soon as you have to troubleshoot that crazy web part that use to be soooo cool that is now slowing down the system or is now resulting in can't load assembly or can't locate, or whatever.  You're going to be hating life.  Where is that dev?  Do you have a 24 hr support number with a support contract with a maintenance agreement?  Where did you store that PID key?  That's why it's so important that you must do configuration management.  Do you have a book or a log outside of your server farm where you keep a log of what's been rolled out?  Does that governance plan have contact numbers both within your team including support hours and SLAs for the dev teams?  Heard of OLAs?  Those are operations agreements you might have with other teams.  Those devs may have a pager that they rotate for times like this.  If they don't maybe they should or at least get with the times and have a text message system.

5. Does it scale?  How does it scale? The saddest stories I've heard are where SharePoint gets blamed for someone's custom navigation control.  Why it's always navigation I don't know.  Some of the coolest master pages aren't the largest.  Sure there are some decent sized ones, but the really good ones are those who take into account caching methods and don't hit the database for each item and know how to optimize those round trips.  There is already a big enough perf hit to get security trimmed UI, the bread crumbs, role based UI and targeting.  We don't need much extra.  What this one means is who is perf testing this solution that's being rolled out?  If there's a chance it could slow the system what are the benchmarks for it?  You should ask to see benchmarks with OOB vs. the solution.  If it's your dev team, you should get them to use Visual Studio Test tools against it with it off and with it on.  It's important you understand your environment and what the slowest component or bottleneck is.  Not that you want it to be the out of the box components, but you do.  Once you want to do more than that, you may go with minimal master pages for the serious designers, or you go with page optimization techniques for anonymous Internet sites.

 

If all this seems overwhelming then try to start by keeping it simple.  The KISS principle pays off early and frequently.  It's a lot harder to start over, or to try to play catchup after some custom assembly has been freed into the wild and no one knows where it's being used.  The more you know what the out of the box can provide, the better off you'll be when providing guidance to the business on how best to take advantage of the solution.  Less is more.  There are some awesome solutions out there and some awesome partners that support them.  Just make sure you weed out those that are just trying to make a buck and don't have your best interest in mind.  You want to make sure whatever choices you make you acknowledge that these are lasting relationships.  I'm saying this is that new brother in law you'll see every Christmas from now on.  That's really what rolling out service packs and upgrades feels like, it's a level of trust that is going to feel uncomfortable.  Oh yeah, forgot I had that solution, but man I feel good that it's Uncle Jesse, he's on it, and he's got my back. :)

There are some similar posts and reference articles that may help with this topic:

Posted by joelo | 4 Comments

Backup Throughput Benchmarks

I twisted Mike Watson's arm to let me blog some of his recent time tests on backup.  I thought the data was an interesting reference.  Emphasis is purposefully placed on reference.  Your numbers will sure to vary.

  • Data Protection Manager 2007: 100MB/sec (over GigE) GigE, Network, and Network Interface is usually the constraint. Also highly depends on the disk speeds. Our 12 disks SATA backup arrays only give us about 75MB/sec.
  • Site Collection Backup: 3.25MB/sec (to disk) STSADM –o backup -url  You can do multiple threads, but it really impacts your performance when you got a like 5 threads going.  Going from one to two will nearly double, but going from 1 to 5 is not 5X, and blocking will result.
  • Native SQL Backup: 150MB/sec (to disk) Using compression gets you about 30% compression with 25% faster backups.  Adding multiple threads this can increase, but you risk total system performance at more than about 3 or 4.
  • Farm Backup: 35MB/sec (over GigE) With Central Admin UI.  If you use disks local to the SQL server (even if over UNC) you will see much much, better performance than remote shares.  This is the number most likely to vary from one environment to another since the Index backup is the slowest part, so it really depends on how large your index is and what topology and network you're using for your index server and between your SQL environment.

This information flows well with the post on demistifying and navigating backup strategies.

If your experience is different than this, or you want to add what your third party vendor speeds are, feel free to add to comments for others to enjoy.

Posted by joelo | 1 Comments
Filed under: ,

Top 10 SQL 2008 Features for SharePoint IT Pros

This is a SharePoint blog, so let me give you my top 10 reasons why a SharePoint Administrator would want to upgrade their SQL environment at RTM.  (I say RTM since the SharePoint team plans to support SQL 2008 at it's RTM release.)  I also look at this list and think it's not a bad list for any application that uses SQL for it's database.  Look for performance, manageability, and cost savings.

  1. Backup compression (25-35% at least) - huge cost savings and hey it's native! (note SQL 2005 encryption is not supported by product support but
  2. Transparent Encryption - transparently encrypt the data without the application needing to be aware or know about it.
  3. Database Mirroring Enhancements - compressed tlogs, more automatic failover options
  4. Policy Based Administration - manage policies across databases and even across instances and servers
  5. Cluster enhancements - easier to configure and more scenarios that it supports including many in WS08 that provide more intelligence for failover
  6. Resource Governor - limit wild database resources or control one database resources from another!
  7. Easier to deploy - Easier to install, easier to configure, on and on
  8. Reporting Services in SharePoint Mode (report builder rocks!) - easy reporting solutions built to leverage SharePoint mode with more flexibility and with ease.
  9. Data compression - smaller databases with the same amount of data (compression will vary, but watch the overhead on enterprise environments or heavy used environments)
  10. Powershell integration - super extensible and super scriptable

If you don't know what these things are, you should check out the SQL 2008 site.

Posted by joelo | 7 Comments
Filed under:

The Social Side to the SharePoint Conference

Beyond the 10 or so customer meetings I had, 6 or so partner meetings, and 2 analyst meetings, I did find some time to attend some social events that were a lot of fun. If you're looking for my decks or notes on the keynote and announcements I posted them in a recap.  You can also see the SharePoint Conference press pass PR content and keynote announcements.

If you were at the conference you may have seen me with Paul Graham a SharePoint newbie from Portland.  He's so passionate about SharePoint he's willing to drop everything, and is planning on working for in an "internship" if he can't find something fulltime.  I introduced him to plenty of SharePoint folks who are looking for SharePoint people and who might be willing to give him on the job training.  I'd like to give him a boost if there is someone looking for people with passion and lacking deep skills.  (Ping me through this blog if you have ideas, or openings, he is willing to relocate.)  He's been to Shane Young's Advanced Admin class in December, and since has been running MOSS on his home machine.  His background in IT, network & desk side support and troubleshooting is a good start.

One big background social theme throughout the conference was... it's hard to get good SharePoint talent.  The talent pool on SharePoint is a small elite group.  One quote I over heard in passing was, "why miss a week where I can make 10K for a week at the SharePoint conference where it covers what I already know?"  I'll tell you...  Because the sum of this social network of MVPs is of more value than the parts.  Hence what I consider a big SharePoint reunion and tight social network.  Sorry if you didn't make it or tried and it was sold out.  Many a scalper was turned away.

The first night, Monday night, there were 4 concurrent events.  From the Ted Pattison and Ascentium social to the HP dinner, MVP dinner, and Syntergy appreciation party.  It was tough determining where to go.  The MVP dinner was so well attended I ended up taking a decent contingency (Chandima, Todd, Matt, Ivan and a few of his Auzzie buddies, Mike, Paul, and a few others to Mortons.  The was some count that there were ~35 SharePoint MVPs at the conference, but there were 60 who showed up.  I had a group of about 10 MVPs with me.  The steak was great.  The Ascentium/TPG party was pretty good as well, it's advantage of starting earlier I saw a few MVPs like AC and Shane Young who were trying to fit in both.  When I first arrived I ran into Brian Cook and Brett Campbell from Nintex.  Brian and I walked through our deck and decided on some slight changes and arrangements.  He's got such a dynamic and great personality that grows on anybody.  They keynote went off with very little concern.  The customer deployments and simply having Bill talk about his passion for SharePoint is always fun.  I saw the keynote from building 16, Rob Silver, Rob Lefferts, Dustin Fr, and Derek Burney were there as well, so I was definitely in good company.  It was fun to watch their faces during the Q & A and with the solution accelerator demos by Tom Rizzo.  Michael Herman's unified storage question for example brought a few eyebrow raises, but Billg handled it well.  SQL08 makes some major steps in the right direction with the new data types.

Tuesday night, the Museum of Flight party was the official one.  Heather Solomon's Ruth Chris spontaneous dinner really hit the spot, great food, great company.  There were 20 of us with the SharePoint Experts crew.  It was good meeting Matt from SP Experts for the first time.  I can see he's very passionate about the IT Pro and ensuring SharePoint deployments are successful.  His focus on planning and working with the business and not against it... he's got something.  Sitting next to Matt I could feel his passion.  It was fun to watch Shane's reactions to his stories.  Welcome Matt Passannante to the SharePoint community.  Hanging out with Shane Young, AC, Todd, Nicola, Dustin, Todd (x2), Chris, Medero, and Heather (amongst others) is one of my favorite things to do at Conferences.  Dustin Miller has his new challenge...  Integrate guitar hero into his session, not just the words, but the actual game.  After the dinner we went back to the Crown, where most of the gang was hanging out.  Adam Buenz, Bob Fox and cronies, Jason Medero, AC, Chris Regan, Steve Smith, Ben Curry, Ted Pattison, Nick Swan, Todd Klindt, Darrin Bishop, Todd Baginsky, Spence, Steve Smith, and more.

Wednesday started off seeing most of the biker keynote.  Then Bob and my session. 

SharePoint Jokes I made up especially for the WS08/SQL08 Bob Fox and Joel Oleson session:

on_stage_with_joel and bob 1. What does SharePoint and Paintball have in common?

A. The more experience you have, the more likely you'll be to miss the zingers.  (It pays off to learn or to work with experienced MOSS architects or experts.)

2. Three guys go into a bar to play a game.  The first guy leaves on a stretcher, the second guy passes out.  The last guy wins.  It's Bob and it was a drinking game.  Their did happen to be a fourth guy watching the game drinking pineapple juice.  That was Joel.

3. What do SharePoint and Beer have in Common?

A. You have a little bit, and things start to not seem so bad.

Todd Klindt said he'd had a 50% chance that he might have a SQL 2008 CTP VPC with him the night before the session.  I said bring it.  I'd like to show off the backup compression and transparent encryption options.  Sure enough he had it, and he said he had looked at these settings, so I invited him to show it off during the session.  He really nailed it, and the crowd loved it.  They wanted more SQL 2008.  In the shower that morning I was thinking... hmmm what can I do to ensure that the session isn't super serious.  If anyone had been to the SQL 2008 or WS08 sessions at the various launch events, or possibly any events since last TechEd, they might have seen most of our material, but I really wanted to put a SharePoint focus to the session. 

Wednesday night was the game night.  Snacks, drinks, and XBOX games with your top favorites.  After chatting with folks at the game night, we split up and I ended up at the Dell and AMD social at Ruths Chris.  It was good to see some of the Dell IT folks who visited recently and those working on AMD.com.  Dino, Doron, and Mike were all enjoying themselves as well.  Also had a chance to connect with Matt from Catalysis and connected with a few MS folks from the field.  After we were all very hungry and on our way to AC and Bob's SharePint party at Kells, we couldn't find a good place to eat (little did we know Kells had Shepherds pie!)  I suggested Wild Ginger, but the 15-20 minute wait was too much for Shane.  He bowed out and took a portion of the crew (Todd and Nicola) with him to MCDs and then Kells and back to the hotel.  We didn't see them after that.  We did meet up with Woody and David Solomon.  We even ran into Rob Bogue.  Good chats with him about TechEd and the state of things in the midwest.  Steve Carvajal had been chatting with Shane and ended up eating with us and following us to Kells.  Kells is definitely where the party was.  AC, Bob Fox, Fitz, Kimmo, the HP SharePoint experts like Kevin Laahs, Daniel McPherson (and gang),  some Mindsharp folks, Keith Richie, Maurice Prather, Ted Pattison, Gayan, Patrick Tisseghem, Eric Shupps, Auzzies, Irish and Scots and on and on were there. 

kells

AC and Bob did very well, it was a good time.  I told AC that we need to definitely do this for TechEd.  Note we are looking for sponsors, and now that we have proof we can throw a party, I expect them to line up.  You can start by contacting Andrew Connell via his blog.  This is isn't his first such party, but we have a challenge... we need to beat Palermo's TechEd party.  When we get more details we'll reach out more substantially. [Picture left from Kells]

I was dressed for the occasion.  I was wearing the Bamboo Solutions "Revlolution" garb with the SharePoint Experts dog tags.  I looked pretty mean.  Meeting up with Mike Watson there, he and I followed the lead of the Avepoint folks.  They suggested the real party was up on capitol hill and we found a local dance music venue as Kells was closing down.  We'll leave it as "dance venue," but you can imagine it was a whole lot more than that.  As the night went on as we shut the place down, someone suggested Five Points for cheesy tots.  That was awesome!  Very impressive local dive that lived up to the reputation.  It is impressive that you can find cheesy tots at 3am.  After a round of hot chocolate Mike and I caught a taxi to the W.  It would be an early morning starting at 8am with an analyst meeting.  Tony and the awesome group of Avepoint folks were a lot of fun.  There's no doubt I'll be trying to hook up with them some night at an upcoming conference.  His cousin has tight connections with Spongebob.  Being only 3 steps removed from Spongebob is unreal.

Thursday night started off with a good visit with Fitz and Brian and a good chat with Steve Smith about his whitepapers.  We all ended up at an interesting French cuisine place with the SharePoint Experts and the Ted Pattison group folks.  It was good seeing Dustin, Heather, Shane, Nicola, AC, Ted, Penny, and a follow up chat with Matt about his session.  We were also joined by some cool SharePoint Auzzies.  We accidentally left AC in the back of the tiny SUV.  As we walked off, he called Shane.  By far the funniest thing of the day!  Although watching AC eat the bone marrow was pretty funny as well.  Shane's immediate reaction to the food brought back memories of France.  Flashbacks.

[Photos courtesy Chandima SharePoint MVP]

Posted by joelo | 7 Comments

Man, What a Week! SharePoint Conference 2008 Recap and Session PPTX Downloads

We've been preparing for this conference since since the fall and oh, was it worth it.  I had a blast!  Not only with the sessions, parties, but simply hanging out with 3900+ incredibly cool people (with 500 on the waiting list) and taking about our passion.... SharePoint!

billg

The Keynotes by Bill Gates, Jeff Teper, and Kurt Delbene included some Awesome stats... (Numbers added to simplify for non U.S. math and term confusion.)

  1. 1 Billion (yeah with a B! $1,000,000,000 USD) in revenue
  2. 100 Million CALs (100,000,000) by end of fical year June 30 (this is estimated to be 10% of all PCs, not just business PCs)
  3. 500 Million Licensed Office PCs (1/5th of that total licensed for SharePoint, but that number includes consumer PCs... makes you wonder if it's more like 40-50% of business PCs.)
  4. 3/4 of the Fortune 100 that's 75% of Fortune 100 companies
  5. Fastest growing server product in Microsoft History (maybe in any company ever?)
  6. 2250+ SharePoint ISVs (integrated solutions vendor)

 

(Photo courtesy Chandima SharePoint MVP)

The Solution Accelerators demo'ed very well.  Tom did an excellent job, even if he did over sell them :)  just kidding.  He did a great job.  If you have followed my previous posts you'd see I've worked closely on all of them.  I'll provide more info on the extranet or external collab one in a future post.  I'm trying to get them to decouple the workflow provisioning and approval site collection piece from the user management and ADAM with FBA piece.

SharePoint Capacity Planning Tool
Performance models for Microsoft Office SharePoint Server (MOSS) 2007 and Windows SharePoint Services (WSS) 3.0 that use the analysis and simulation features of Microsoft System Center Capacity Planner 2007 to help you plan your SharePoint topology.

SharePoint Monitoring Toolkit
Helps you monitor and manage Microsoft SharePoint environments by providing a set of management packs for Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 (including SP1). These management packs are supported by both System Center Operations Manager 2007 and System Center Essentials.

SharePoint Cross-site Configurator
This tool contains sample code that you can use to automate the deployment of configuration changes across SharePoint site collections as broadly as entire web applications or even entire farms.

External Collaboration Toolkit
It consists of software and guidance that will help you to deploy a customizable solution built on Microsoft® Windows® SharePoint® Services 3.0 or Microsoft Office SharePoint Server 2007 that teams can use to collaborate securely with partners outside the firewall. The toolkit’s familiar SharePoint interface makes the solution easy for project team members to understand and use.

The SharePoint Online beta (register now) announcement was well received.  I think heard a few customers wheels spinning on that one.  The best way to understand this amongst the other SharePoint hosted offerings is to look at the various offerings.

Office Live (this one is released)- Small Business Site Collection Hosting (Consider this the site collection hosting)

SharePoint Online Standard beta - SharePoint (in the Cloud) hosting (I'd consider this the multi tenant hosting solution)  (up to 5000 users)

SharePoint Online Dedicated Hosting beta - Dedicated SharePoint Farms in MS data centers with 99.9% SLAs and integration with AD resource forest, Exchange and OCS.  (This internally use to be called MMS (Microsoft Managed Services) now the team is BOSG (Business Online Services Group)) (5000 users and up).  I worked with Mike Watson and Kimberly Malone amongst others to design the SharePoint hosting for the pilot with Energizer.  Good times :)..

A couple of my sessions were top rated.  Let me thank those of you who went to my Upgrade session and my Governance session.  I really appreciate all the 9's and nice comments.  I do read them and really appreciate them.  Thanks to Shane and Brian who co-spoke with me on those.  Bob Fox's presentation with me...  well ok.  It was fun to present.  The comment I got from the users that they thought we were both drunk wasn't very nice, and wasn't accurate.  I was drinking lemonade the night before, so it couldn't have been me.  Bob did a great job for his first time and I'm sure he gained some new fans as a result.  He has a lot of knowledge and he had a lot of pressure leading up to this.  Under the circumstances he did well.  I'll leave it to your comment to set the story straight.  I enjoyed the session even if it wasn't one of the top rated.  I got feedback from more than a couple people in the crowd who thoroughly enjoyed it. 

My Session Downloads (may require SPC login):

Governance: From Chaos to Success in 10 Steps - Joel Oleson and Brian Cook

What's New in Windows Server 2008 and SQL 2008 for SharePoint Admins - Joel Oleson and Bob Fox

Upgrading from SPS 2003 to MOSS 2007 - Joel Oleson and Shane Young

Advanced Administrative Architecture, Deployment and Operations - Joel Oleson and Shane Young

Commentary:

"Proactive Planning Crucial to Avoiding SharePoint Chaos" -

By Margie Semilof, Senior News Director, 05 Mar 2008 | SearchWinIT.com

One other thing to add to your favorites and dig into is the new adoption, planning content, engineering, release and adopt to GEAR UP!

Also, be sure to check out Microsoft Search Server Express 2008 general availability announced during the keynote!  Developers and more will want to look at the SharePoint Silverlight Blueprint which definitely promises to make the UI much more exciting and rich.

Relevant Partner Announcements you shouldn't miss as an IT Pro:

(Full list @ http://www.microsoft.com/presspass/events/sharepointconference/partners.mspx)

 

Miss a party?  Go behind the scenes and see the social side of the SharePoint Conference.

Posted by joelo | 6 Comments
Filed under: , ,

SQL Database Management for SharePoint Insight

I hope you have checked out the database maintenance whitepaper that Bill Baer put together and just released on TechNet.  In the review cycle for the paper, I saw some very insightful guidance from Mike Watson, Tom Tseng, and incredible insight from Ronnie Thompson.  Ronnie one of the Sr. Ops folks who was recently promoted to Ops Manager.  (A super strong SQL SME and good person to know :))  He is someone who comes from a SQL background and has learned SharePoint coming from that side of supporting the more than 17 TB in MSIT.  Here's a few snippets from the email:

  • Your clustered Index IS your table – rebuild / reorganize your clustered index is what defrags the table. You cannot defrag a table with rebuilding / reorganizing your clustered.
  • There is no defrag option. ‘reindex’ is defrag – they are synonymous.
  • We should never – absolutely never – recommend setting up a DB maintenance plan to autoshrink DBs. Shrink DB or Shrink files is one of the most resource intensive operations within SQL and the bigger the DB the bigger the perf hit.
  • Good places to shrink is when you have explicitly moved site collection out (say for instance using merge db etc.) and you know the db is become smaller.  If this is a small change like cleaning recycle bin etc., customers should not look for this small reduction. 
  • Maintenance operations can be long running and can have a significant impact on perf.
  • Personally – I would never recommend shrinking a DB unless disk space is an issue and / or your DB has lost at least 50% of its content.
Posted by joelo | 1 Comments
Filed under: ,

This Jumper was in Sydney, now LA, next week Seattle for SharePoint Conference then Middle East

Just got back from Jumper the movie.  A new movie about a guy who teleports.  Can't say I teleport, but yesterday I left Sydney and it was Monday at 3:30pm when I got on the plane and 1:00pm when I was back in Seattle including a connection in L.A.  Less than 24 hours I was back in L.A (my least favorite airport in the world, and they complain about Bali Airport in the LA airport (way better in my opinion).

I'm in LA for the Windows Launch event.  Stop by the SharePoint booth in the Microsoft Pavilion area and say hi.  You can get the new SharePoint Deployment Guide (first come first served).  I'll also have some at the SharePoint Conference next week in Seattle.  Can't wait for my Governance session next week, I've invited Brian Cook from OBS to co-speak.  I'm also excited to be speaking with Bob Fox.  He's a blast.  He's been playing with Windows Server 2008 for months and has been validating the new hands on labs I've been working with Patrick Gaul.  Patrick's done an excellent job.  They'll be on the web in the next month after some good validation as well planned to be available at TechEd.  If you can't make it you should download a soft copy of the SharePoint Deployment Guide and Essentials Checklist.

So where do I jump next? How about Istanbul and Dubai (www.sharepointconferenceistanbul.com and www.sharepointconferencedubai.com)?  How cool would that be?  I'd love to see you there.  My hotel is booked and flights getting put together by end of week.  These Middle East SharePoint Conferences were recently announced and have live sites for more information.

Todd Klindt will also be there.  I'm covering 3 sessions at each.  1) SharePoint Admin Fundamentals 2) SharePoint Advanced Administration 3) Chaos No More - SharePoint Governance and Adoption.  Todd has an STSADM and a SQL storage session both should be really good.  I saw the STSADM one in Barcelona.  It was excellent, he almost brought the house down, I should say tent.  (Really it was scary, but he still didn't loose anyone in those 100 mile an hour gusts bashing the tent.) 

I've been debating a stop over to Jerusalem (Holy Land), Cairo (Pyramids), Jordan (Petra).  Let me know what you think.  I'd love to visit the Jordan SharePoint User Group or meet up with the prolific blogger MOSS is his middle name.

Posted by joelo | 7 Comments

Navigating SharePoint Server Backup

I think one of the most common IT questions is around how to backup SharePoint Server and when to use SQL backup over STSADM backup.  I've chosen 200GB below, but essentially anywhere between 200-500GB or as soon as you're ready to manage it outside of a scheduled task.  Let me quickly demistify this for you.  There's essentially 5 sets of configuration and data you should be concerned about.

  1. Content Databases - this is where you data is stored
  2. Configuration Databases and Admin and SSP Admin Databases - farm and web app configuration including server names, solutions and features you've deployed
  3. SSP, Search Databases and the Index(es) catalogs - Essentially everything from Profiles, BDC, Search, best bets, properties, content sources
  4. Server Configuration - IIS configuration including metabase information and other server configuration such as system state including registry
  5. On disk files - anything in the 12 hive or program files directories you've added or customized, all deployment packages and features (have special copies of these for redeployment), back these up.  I'd STRONGLY recommend that there never be anything on disk that isn't in a feature or solution deployment pack, but I realize there are some exceptions that must be documented in your recovery plan especially around search configuration or some changes to specific web.config files.  This also includes deployment of any add-ons.  Make sure you have copies of these web part packages, interop solutions, search add-ons or whatever they are.  I'd say all disks on all servers for simplicity, but this oversimplification doesn't help for more complex environments.  If you can do a windiff (file comparison) against a clean box, you'll essentially reveal what the is necessary here.  I recommend creating a special directory with a copy of all of the things you deploy to your farm from ifilters, web parts, solutions, web config change history, AAM configuration, the setup files, QFEs, service packs, really keeping a change log that's easy to re apply is essential and this needs to be easy to recover.  You may want to keep this in a handy directory or share as a "version" of what you're running from top to bottom.  I'd keep this on a staging server or some server off your production environment so you don't have to go to tape if you simply lost a web front end for example.

To backup 1-3 for small environments under 200 GB, you could essentially use the out of the box stsadm -o backup -directory commands to backup the relevant databases.  This will need to be scheduled, if you're electing to use Microsoft tools, you'll likely start with a daily scheduled task that should be monitored.  I do emphasize monitoring it, there are a number of ways this task can fail with improper perms, failed access to a share, missing flags, already running backup job that hung, etc...  You may elect to purchase DPM 2007 or a third party to make the backup easy to do while making retrieval easier and potentially more reliable than a simple scheduled task.  Using the -o backup -directory would give you the granularity of content databases.  You'd then use NTBackup or whatever normal server backup you use to backup all of the backup files to tape, disk or into your offbox/offsite recovery solution.  At this size for 4-5 you can backup all your directories and system state.  It's the easiest route to go and you'll be glad you did when you try to locate that ifilter you purchased.  (Essentially get a clean copy of 1-5 out of the data center.)

For over 200 GB I recommend no longer using STSAdm to backup the content databases.  What's essentially happening in STSAdm -o backup -directory is a SQL backup anyway ;).  So as you get more data, you need to have more granularity around it so you can more quickly monitor the jobs for backup up the individual content databases in a quick and manageable way.  Use SQL Server to backup 1-2, and if you need granular recovery use DPM 2007 or AvePoint or your favorite backup vendor that supports SharePoint Server 2007 (some backup vendors add special sauce to do brick backups, some do not, so be sure to ask all your questions around ability to get granular recovery and speed) to backup the content for quicker recovery.  Some vendors focus on speed, like Quest's SQL litespeed with database backup compression like you'll get in SQL 2008.  You should still use stsadm -o backup to backup 3, you essentially want to keep the time stamp as close to the same time for all of the search/index related components (configuration and data).  Of all of what you backup, the search, ssp, and index will be the most tricky to get right.  I highly recommend you test out your recovery plan on a recurring basis.  The ops team must know you to get this right unless your plan is to recrawl.

The larger your databases get, the more creative you'll get.  Backup takes a lot of disk IO and network throughput, don't dismiss it as a bottleneck while it's running.  It can easily be overlooked as the most heavy usage your boxes may see.  This is one reason you may consider a snapshot solution like DPM 2007 or using VLANs to move the Network IO off the NICs that is normally used by your user traffic.  Once this isn't competiting for resources with your users you can start to multi thread the processes and backup multiple databases at once.  That's one reason I recommend not putting all your data in one large da