Great solution that combines the power or two great products (SharePoint and SQL)
April 10, 2018
Great solution that combines the power or two great products (SharePoint and SQL)
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with MS SharePoint / SQL
I have used SharePoint/SQL for years. In my previous role I was a consultant and implemented this for customers. Currently, our company uses SharePoint/SQL across the enterprise to help simplify and automate multiple business problems. We use it to provide HR resources to employees, as a full blown PMO solution for our PM group, and for enterprise wide collaboration and reporting.
- Great platform for document management, versioning and sharing data/reports. The ability to keep history of edits and all previous versions of the file is very valuable.
- The solution easily allows you to solve unique business problems. The ability to create custom reports, dashboards, lists or workflows without writing code (most of the time) adds a lot of value.
- Provisioning and permissions are simple and flexible. They can be as global or as granular as you needed. It is very easy to give and remove permissions and there are lots of solutions for automating them.
- This is a great product but sometimes I find that there are 10 ways to do the same exact function or action. SharePoint has lots of ways to do the same ting, from a different screen or menu. This can be challenging when it comes to end user training.
- Staying on track with the current version can be a challenge. Microsoft is also notorious for constant patches, updates and hotfixes. A new major version is released every few years and it can be a pain to migrate to the new version if you have customized heavily.
- Creating intuitive global navigation and menus can sometimes be difficult and require a specific skillset of web designer or similar. SharePoint does great for individual sites/solutions, but it can be confusing sometimes to provide global navigation that makes sense for an end user.
We use tools like Jira for Agile specific work/projects, but SharePoint is the choice for groups that are trying to solve a specific business problem or share data/documents. It is the industry leader here and is must more flexible and easy to use than competitors like Google Docs/Apps and similar products from IBM. The software of .NET and SQL are found in almost every business, so the cost of entry is minimal.