Put Your SharePoint On-Premises, Office 365, or Dedicated Hosting – Which to Choose?

I’ve also been a little delinquent in getting my slides from my talks this month posted, so here you go!

Office365 -How the Cloud Makes IT Easy and Why That’s Difficult – SPSOzarks

This past June Idera started up a SharePoint equivalent of a very cool program they had been doing to help out the SQL Server community, the Advisor and Community Educator (ACE) program, and I was lucky enough to be one of the initial group of SharePoint folks selected by Idera to be SharePoint ACEs. Myself, Liam Cleary, Nedra Allmond, Wes Preston, and Michael Lotter are in the initial class of SharePoint ACEs, and Idera will be resetting the program every year with a fresh group of SharePoint experts to recognize and award. The best part about the ACE program is that it really helps me do a lot more of something that I love doing in the SharePoint community: speaking at events like SharePoint Saturdays all over the country, as Idera is able to sponsor me and help me cover my travel costs inherent in going to so many of these different events, as well as continue to do webcasts and other events that are also sponsored by Idera.

Because of the ACE program, I’m able to submit to many more SharePoint Saturday events than I have in the past, such as the three I’m going to be heading to this September! Three! Wow So if you’re interesting, here’s where I’ll be speaking and what I’ll be covering:

• SharePoint Saturday Ozarks, this Saturday, Sept 8th. For more info, check out http://sharepointsaturday.org/ozarks, I’ll be doing one of my favorite talks: Why Office 365 Makes IT Easy and Why that’s Difficult.
• SharePoint Saturday Redmond, Saturday Sept 22nd. For more info, check out http://sharepointsaturday.org/redmond, I’ll be doing a new talk on Identity in Office 365, as well as participating in a panel session on Cloud Computing.
• SharePoint Saturday Michigan, Saturday Sept 29th. For more info, check out http://sharepointsaturday.org/michigan, still waiting to hear about what I’ll be talking about there

I’ve got a few more possible speaking opportunities coming up, but they’re a little bit more than a month out so I’ll save them for another day. If you see Idera sponsoring a community event, make sure to thank them for their support of the community and don’t hesitate to talk to them about the ACE program and find out how you might be able to be an ACE next year!

This was the first time I’ve gotten a chance to talk about Office 365 since the preview of the next major wave of changes for the platform were announced, and I think this is going to be a really interesting time to start looking at the platform if you haven’t yet. I’m going to start working on getting my thoughts put together in a separate blog post, but the one thing I realized last week as I was preparing for my talk was that the new release fits really well into it. I think that’s the case because there’s a lot of new compelling functionality that we’re going to see rolling into Office 365 soon, but at the same time there really are a lot of considerations that organizations are going to have to keep in mind if they’re going to be successful with it in the long run.

But since there’s a lot I want to cover there, I’m going to save that for another post. I had a wonderful time in Louisville and especially enjoyed changing a few people’s minds about what Wave 2013 holds for all of us in the SharePoint and Office 365 space (CA Callahan, I’m looking at you ) Anyways, here’s my slides from the weekend:

So, here’s the situation: SharePoint needs SQL Server to operate. I tend to think of SharePoint needing SQL Server like humans need oxygen: we often take the act of breathing for granted, but we really notice when we’re having trouble doing it. SharePoint is the same way with SQL Server; it puts just about every piece of data about a farm and its contents into SQL Server databases and when something goes wrong with those databases SharePoint really has problems.Now, that being said, SharePoint is also very particular in how it uses SQL Server. Its databases have to be set up in a very specific way, with some pretty inflexible configurations, and SharePoint reserves the right to change any of the details of those configurations any time it wants (usually via patches and updates).

Now, this relationship isn’t exactly new news. Nor is the fact that Microsoft does not support the modification of SharePoint’s databases or the access of their contents directly through SQL Server, and instead requires that the data in those databases be accessed through SharePoint’s UI, its object models, or its administrative interfaces. Lots of people way smarter than me have written quite a bit about it in the past, but like a bad penny I keep seeing the topic come up and kind of felt like putting my own thoughts out there on the matter, so here goes.

Because of how particular SharePoint is about its SQL Server databases, Microsoft has made some pretty definitive statements about what you can and can’t do with those databases. In general, it’s like this: don’t touch them. Don’t add things to them, such as indices, views, triggers, or new columns. Don’t delete anything off them either, or create new tables within them. Specifically, Microsoft has a knowledge base article on what is not supported, that I really suggest you read: http://support.microsoft.com/kb/841057. On the other side of the coin, there are specific things that you can do, but they’re really more maintenance-oriented things like defragmenting indices or creating maintenance plans for backups. The main source I use for what you can actually do with SharePoint’s databases is this article on TechNet: Database Maintenance for SharePoint 2010 Products.

One thing that I think people often overlook, and sometimes it seems like they’re eager to do so, is an important statement in that KB article I linked to above:

Read Operations Addendum
Reading from the SharePoint databases programmatically, or manually, can cause unexpected locking within Microsoft SQL Server which can adversely affect performance. Any read operations against the SharePoint databases that originate from queries, scripts, .dll files (and so on) that are not provided by the Microsoft SharePoint Development Team or by Microsoft SharePoint Support will be considered unsupported if they are identified as a barrier to the resolution of a Microsoft support engagement.

In plain English: querying SharePoint databases can lock data in those databases and cause performance issues, and can put you in an unsupported state. Yep, even running a query against a SharePoint database can be unsupported, a situation that I see a lot of people either ignorant of or willing to look past. Are there times where you may need to do it? Sure, but I would do my darnedest to avoid having to do that in a live Production environment without first trying to exhaust every supported approach to get the info I need the right way or to copy the database out and query it outside of my live Production SharePoint environment.

So that’s why I like to think of SharePoint’s databases as being a lot like Kuzco in Disney’s movie, the “Emperor’s New Groove”:

I’m embedding the slides from that presentation below, along with links to some of the tools and info that I mention in the presentation. One important link I do want to call out is to a white paper that I’ve written for Idera Software on the same subject, which can be downloaded from Idera’s website at http://www.tinyrul.com/SPTrouble. It’s a handy companion to the presentation, each was an outline for the other and my perspective is that you’ll get more from the two combined than you will with just one or the other.

Here’s the slides:

And here’s the links to resources that I mentioned in the presentation:

• Microsoft’s ULS Log Viewer: http://archive.msdn.microsoft.com/ULSViewer
• LogParser: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=24659
• Performance Analysis of Logs (PAL) Tool: http://pal.codeplex.com/
• Microsoft’s MSDN/TechNet Forums for SharePoint: http://social.msdn.microsoft.com/forums/en-US/category/sharepoint/
• SharePoint forums on StackExchange: http://sharepoint.stackexchange.com/
• The #SPHelp Hashtag on Twitter: https://twitter.com/#!/search/sphelp
• My Idera whitepaper on Troubleshooting SharePoint: http://tinyurl.com/SPtrouble

Speaking of Idera, they also invited me to do a free webinar last month on the subject of SharePoint Disaster Recovery, which was a great opportunity for me to do yet another new presentation I’d been working on: Backup is not Backup, Restore is Backup. I’d been wanting to try to encourage a different perspective with SharePoint DR: one stressing the importance of making sure you’re able to actually restore your content when it counts rather than just getting it backed up and forgetting about it. The webinar went very well, and I really enjoyed the conversations in the chat room during it in addition to the overall opportunity to deliver it. If you didn’t get a chance to join us, Idera has published a recording of the webcast, which you can go here to download: http://www.idera.com/Events/RegisterWC.aspx?DoThis=TY&EventID=403

Additionally, here are the slides for that talk:

That’s all I’ve got time for right now, but I’m going to challenge myself to get another blog post up this week on a technical SharePoint topic that keeps coming up for me time and time again, even though its been around for quite a long time on the SharePoint platform: how to access SharePoint’s databases. Hopefully I’ll be able to get that done this week, we’ll see if its possible with the upcoming July 4th holiday here in the United States or not.

Until then, have a great one and I hope the slides are useful!

Seriously, if you’d like to learn a little more about SharePoint Backup and Restore, head on over to the registration site and sign up!

In case you missed my earlier post about the webinar, here’s some info: The session is called Backup is not Backup. Restore is Backup, and I’ll be talking about the need to focus on what you need to do after a SharePoint disaster to bring back your valuable content. Something I’ve seen a lot of organizations do, and something I’ve been guilty of myself in the past, is zeroing in too much on getting their SharePoint backups set up and running, without thinking about how they’re going to use those backups when they need them.

The great folks at Idera are sponsoring and hosting this webinar as a part of their Secrets of SharePoint series, so please don’t forget to tell them thank you for their support of the SharePoint community (and specifically my webinar)!

• I really enjoy talking about SharePoint Online It’s a great platform, but I do think it’s just as important to help educate people on its shortcomings and how you can overcome them as it is talking about all the great things it can do.
• I have so many friends in the local and greater St. Louis SharePoint community, and got to see them all again, which was AWESOME.
• It was a very well run event, and it’s very comforting as a speaker to be a part of a smooth sailing ship like that. My hat’s off to the whole SPS STL planning group, they did a fantastic job.
• I learned some really good information about Identity and Authentication in Office 365 thanks to my good friend Neil Sly. Neil’s been getting really hands on with stuff like ADFS 2.0 and Single Sign On configuration, and it showed in his talk last Saturday. Thank you Neil!
• I had an absolute blast travelling to and from the event with my brother from a different mother, Enrique Lima. We had some great conversations about SharePoint and technology on the way over on Friday, and in general just yucked it up all weekend long
• You may also want to keep an eye on my blog later this week, if things go according to plan I’ll have some much more detailed information about the stuff that Enrique and I talked about on our way home from St. Louis yesterday morning, it was a very productive drive!

I would really like to thank everyone who came out for my two sessions on Saturday, the audiences in both were great. I love presenting when I am talking with the audience and get a lot of questions and discussions, it just really makes it more of a productive dialog than when I’m just talking at a group, and that was definitely the case on Saturday. I’m embedding my two presentations below if you are here looking for my slides, and you can download the PDFs of those decks from my account at http://www.SlideShare.net/ferringer.

Here’s the slides from my talk on SharePoint Online Development:

And here’s the slides on my second talk, SharePoint Online as an Extranet solution:

Check out the first link for the full slate of speakers and sessions, I’m looking forward to delivering two different sessions related to Office 365:

• SharePoint Online as an Extranet: Is It Hot or Not?
• Same But Different: Why Developing for the Cloud is like Developing for SharePoint but SO Much Different

Hopefully I see you this weekend in St. Louis!