{"id":75,"date":"2011-12-05T22:22:00","date_gmt":"2011-12-06T06:22:00","guid":{"rendered":"https:\/\/thebeagle.itgroove.net\/?p=75"},"modified":"2023-02-24T21:47:07","modified_gmt":"2023-02-24T21:47:07","slug":"sbs-and-sharepoint-decisions","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/","title":{"rendered":"SBS and SharePoint Decisions"},"content":{"rendered":"

We have a number of customers that ask about SharePoint and SBS.  This might be a bit surprising as SharePoint has been an integral part of SBS since SBS2003 (Companyweb, anyone?) but it is a very good question nevertheless because of the nature of SharePoint.<\/p>\n

Microsoft has always pushed the use of SharePoint as an integral selling point of SBS and I would not disagree. BUT, and this is a big BUT, you need to think carefully about what your needs are and what it is that you want to accomplish with SharePoint before you decide on using Companyweb out of the box.<\/p>\n

Companyweb is built on top of SharePoint WSS3 (SBS2008) or SharePoint 2010 Foundation (SBS2011).  Both are the \u201cfree\u201d SharePoint products built on top of \u201crestricted\u201d versions of SQLserver.  These immediately impose upper limits on what you can do in terms of storage and\/or performance as all SharePoint objects and files are stored within a SQLserver database.  SBS2008 Companyweb is built using the \u201cSQLserver Embedded Edition\u201d (SSEE) which has no size limit but does have severe performance caps.  SBS2011 Companyweb is built using SQL Express that has either a 4GB size limit (2008 version) or a 10GB size limit (2008 R2).  This is not to say that Companyweb is in some way unusable because that would be patently false; you can do quite a lot with Companyweb.  Rather, the problem is really one of scalability, overall performance and features.<\/p>\n

Companyweb (SharePoint) is hosted on and runs from the SBS host itself.  This means that SharePoint is competing with all the other services that run on the SBS box for server resources.  An under-sized SBS server can result in sluggish responses from SharePoint.  A properly sized SBS server can provide decent SharePoint performance but it can never match that of SharePoint running on a dedicated server or, for that matter, on the second server of an SBS Premium installation.  In an SBS Premium environment you can migrate the backend of the SBS SharePoint service to the SQLserver Workgroup Edition that is installed on the second server and immediately take advantage of the increased performance and storage provided by licensed SQL.  Keep in mind that you would still be running within the preconfigured parameters of Companyweb that may not line up with your actual needs.<\/p>\n

In an SBS Premium environment you do have the option to bring up another SharePoint environment that is independent of SharePoint on the SBS server.  This would entail installing either SharePoint 2010 Foundation or SharePoint 2010 Server on the second server and utilizing the SQLserver Workgroup installed on that server.  The assumption here is that you would NOT bother to migrate the Companyweb database to the SQL Workgroup as the \u201cheavy lifting\u201d in terms of SharePoint would be handled by the SharePoint\/SQL combo on the second server.  You could even go so far as to add a third server to the mix (Server 2008 R2) and install SharePoint on it pointing back to the SQL install on the second server.<\/p>\n

The point to all of my rambling to here is that almost without fail SharePoint use will shoot past anything you envision up front; you will find ways to use SharePoint to solve business issues and process issues that don\u2019t seem apparent as yet.  We see this all the time within our SharePoint practice and the more you understand this up front the less enthusiastic you will be about accepting the limits of the basic \u201cfree\u201d SharePoint\/Companyweb installation in SBS.  At the risk of giving away my age, if you \u201cgrok\u201d \"Star\"SharePoint (what it is, what it can do) then you will \u201cgrok\u201d the reasons for trying to build what you need up front rather than retrofitting things down the road.<\/p>\n

In terms of a \u201cgood, better, best\u201d model it stacks up like this:<\/p>\n

Good:<\/strong>  SBS2008\/2011 SharePoint\/Companyweb<\/p>\n

Better:<\/strong>  SBS2008\/2011 Premium, two server install with SharePoint 2010 Foundation installed on second server utilizing the SQLserver Workgroup Edition.<\/p>\n

Best:<\/strong>  SBS2008\/2011 Premium, two server install with SharePoint 2010 Server installed on second server utilizing the SQLserver Workgroup Edition.<\/p>\n

Funnily enough, the capability\/performance scale stacks up the same way, as well.<\/p>\n

SBS Premium gives real bang for your licensing dollar and it makes a great platform for a full SharePoint installation that can extend far beyond the constraints of the \u201cfree\u201d SharePoint that ships with SBS.  What\u2019s the right path for you?  Well, every organization is different but a little planning now can provide you with very large dividends down the road AND save you some headaches and dollars.  If you are serious about making SharePoint fly in an SBS environment then I\u2019d recommend giving serious consideration to the \u201cbetter\u201d or \u201cbest\u201d options above.<\/p>\n

\"Star\" See http:\/\/en.wikipedia.org\/wiki\/Grok<\/a>; \u201cStranger in a Strange Land\u201d, Robert A. Heinlein, 1961<\/p>\n","protected":false},"excerpt":{"rendered":"

We have a number of customers that ask about SharePoint and SBS.  This might be a bit surprising as SharePoint has been an integral part of SBS since SBS2003 (Companyweb, anyone?) but it is a very good question nevertheless because of the nature of SharePoint. Microsoft has always pushed the use of SharePoint as an … <\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[258,265],"tags":[329,352,410,508,543,16],"acf":[],"yoast_head":"\nSBS and SharePoint Decisions - Archive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SBS and SharePoint Decisions - Archive\" \/>\n<meta property=\"og:description\" content=\"We have a number of customers that ask about SharePoint and SBS.  This might be a bit surprising as SharePoint has been an integral part of SBS since SBS2003 (Companyweb, anyone?) but it is a very good question nevertheless because of the nature of SharePoint. Microsoft has always pushed the use of SharePoint as an …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2011-12-06T06:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:47:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/thebeagle.itgroove.net\/wp-content\/uploads\/thebeagle\/2011\/12\/wlEmoticon-star.png\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/\",\"name\":\"SBS and SharePoint Decisions - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/thebeagle.itgroove.net\/wp-content\/uploads\/thebeagle\/2011\/12\/wlEmoticon-star.png\",\"datePublished\":\"2011-12-06T06:22:00+00:00\",\"dateModified\":\"2023-02-24T21:47:07+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#primaryimage\",\"url\":\"https:\/\/thebeagle.itgroove.net\/wp-content\/uploads\/thebeagle\/2011\/12\/wlEmoticon-star.png\",\"contentUrl\":\"https:\/\/thebeagle.itgroove.net\/wp-content\/uploads\/thebeagle\/2011\/12\/wlEmoticon-star.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SBS and SharePoint Decisions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SBS and SharePoint Decisions - Archive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/","og_locale":"en_US","og_type":"article","og_title":"SBS and SharePoint Decisions - Archive","og_description":"We have a number of customers that ask about SharePoint and SBS.  This might be a bit surprising as SharePoint has been an integral part of SBS since SBS2003 (Companyweb, anyone?) but it is a very good question nevertheless because of the nature of SharePoint. Microsoft has always pushed the use of SharePoint as an …","og_url":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/","og_site_name":"Archive","article_published_time":"2011-12-06T06:22:00+00:00","article_modified_time":"2023-02-24T21:47:07+00:00","og_image":[{"url":"https:\/\/thebeagle.itgroove.net\/wp-content\/uploads\/thebeagle\/2011\/12\/wlEmoticon-star.png"}],"author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/","url":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/","name":"SBS and SharePoint Decisions - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"primaryImageOfPage":{"@id":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#primaryimage"},"image":{"@id":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#primaryimage"},"thumbnailUrl":"https:\/\/thebeagle.itgroove.net\/wp-content\/uploads\/thebeagle\/2011\/12\/wlEmoticon-star.png","datePublished":"2011-12-06T06:22:00+00:00","dateModified":"2023-02-24T21:47:07+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#primaryimage","url":"https:\/\/thebeagle.itgroove.net\/wp-content\/uploads\/thebeagle\/2011\/12\/wlEmoticon-star.png","contentUrl":"https:\/\/thebeagle.itgroove.net\/wp-content\/uploads\/thebeagle\/2011\/12\/wlEmoticon-star.png"},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2011\/12\/05\/sbs-and-sharepoint-decisions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"SBS and SharePoint Decisions"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/archive\/author\/swallbridge\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/75"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":3081,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/75\/revisions\/3081"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}