MS SharePoint / SQL - an on-premise option for SMBs
Overall Satisfaction with MS SharePoint / SQL
We've used this as a platform for "point solutions" - where we can specifically address distinct and unrelated data needs while still having a similar underlying technical base. For instance, our communications department wanted to manage news, so we leveraged and extended the SharePoint list feature, breaking down each announcement into data elements such as title, body copy, author, and topic. That data was then used to push out an email digest of the news, as well as be published on the internal SharePoint news page. Other examples included a budget planning solution for all departments.
Pros
- If you are an existing and extensive Microsoft customer, the platform will fit in your application ecosystem nicely.
- For SMBs or departments within larger organizations, the solution can be created with "foundation" versions of the products, which can provide plenty of power at a reasonable (often already included) price.
Cons
- If you are a LAMP stack developer or shop, there is a learning curve.
- From a general usability standpoint, it can be a less than pleasant experience. The interface is blocky and the concepts are not straightforward. It feels dated.
At its core, MS SharePoint (with SQL) is for managing document-based content. It falls just short of being a best in class records manager (it does offer some features for this though), and it isn't the easiest to solution to make great looking modern and engaging web sites. It sits somewhere in between and can do a little bit of both out of the box, and do a lot more with some development effort. Other solutions cannot do both and do not even come close to the breadth of possibilities. Think of the MS SharePoint / SQL as a Swiss army knife of solutions. It can do a lot of things reasonably well, but if you need a really special blade for a special job, you probably should get that blade for that job. If you want an all around platform that has lots of different blades (some more helpful than others), then look at MS SharePoint / SQL.
Comments
Please log in to join the conversation