MS SharePoint / SQL
MS SharePoint / SQL
MS SharePoint / SQL
Overview
What is MS SharePoint / SQL?
MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and...
Read moreRecent Reviews
Popular Features
View all 28 features- Multi-User Support (named login) (58)9.393%
- Role-Based Security Model (61)8.989%
- Multiple Access Permission Levels (Create, Read, Delete) (65)8.181%
- Customizable dashboards (53)7.272%
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of MS SharePoint / SQL, and make your voice heard!
Pricing
View all pricingEntry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
1 person want pricing too
Alternatives Pricing
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is MS SharePoint / SQL?
MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.
MS SharePoint / SQL Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.
Reviewers rate Mobile Application and Delivery to Remote Servers highest, with a score of 10.
The most common users of MS SharePoint / SQL are from Enterprises (1,001+ employees).
Comparisons
View all alternativesCompare with
Reviews and Ratings
 (1102)
Attribute Ratings
Reviews
(1-25 of 73)- Popular Filters
Companies can't remove reviews or game the system. Here's why
DBS that supports the SharePoint server in my case 2016 is either created automatically, which is good for DB admins, with the SharePoint wizard configs, or manually by DBS admin when they configure the SharePoint server a problem could be that Microsoft does not support directly querying or modifying the databases.
- You can use some BI solutions with SharePoint Server 2016.
- A great feature is AlwaysOn Availability Groups and Failover Cluster Instances solutions.
- Setup reporting services with SharePoint Server 2016 you create a report server. that's cool.
- You can't install office online server to use excel online.
- Service applications DBS in partitioned mode cannot be created from central administration.
- Something good is that You can configure alerts to notify you when the production server fails.
March 22, 2022
Makes life easier
Score 7 out of 10
Vetted Review
Verified User
It's been a really useful tool and allows multiple users to view and edit content. Saves time and reduces emails. The moving of documents can be a bit clunky (having to identify the new folder every time if moving several documents0 but in general is has proved more user friendly than other document storage methods
- Good for multiple use editing
- easy to copy links
- Easy to create new conten
- Easier method to move multiple documents
- Editing icons can disappear if working in the app
November 13, 2021
Works well for us as a news feed
It is being used as an intranet site. Most users use it as their homepage. We use it as a news feed for all of our remote sites. Departments use it as a document repository. It also hosts an internal trouble ticket system for all staff to track IT issues.
- Document repository
- News feed
- Ticket system
- Advanced logging
- Too complex
- Tries to do too much
- Advanced skills required to fully utilize
May 19, 2021
SharePoint for your organization
Score 10 out of 10
Vetted Review
Verified User
SharePoint is basically a collaboration platform for teams to connect, collaborate and work by sharing data pertaining to their work/project. In my case, it is being used across the organization. In most cases, it is used by a group of people for team collaboration. Some of them are using it for storing data, some are using this platform to create applications for business applications. Like, for example, the HR team can use a SharePoint site to store details about the upcoming programs, recruitment, etc; a business team can use it for storing business proposals, meeting contents, souvenirs, etc. So it has multiple uses for hosting content and the supporting tools to make it a solution.
- Collaboration
- Security
- Automation
- User-friendly
- Quick enablement platfrom
- Search
- Customization
- Number of items limit
- No direct integration to other systems
May 14, 2021
Power MS SQL user for the past 12 years
MS SQL is being used as our primary database throughout our entire IT department. We have almost completely moved off Oracle into MS SQL. It is the backend storage for all our applications which supports all app development.
- Very fast data storage and retrieval
- Great support for ORMs which provide a layer of abstraction over MS SQL
- Great community of support and users
- SSMS is a nice GUI for interfacing with MS SQL
- Licensing costs over free to use DB systems
We are using it to share everything, all our internal sites are hosted via SharePoint. Basically, from onboarding to the latest news, to the stock market, everything internal is updated via SharePoint.
- Integration with Office.
- Easy to launch.
- Support of Microsoft.
- Complicated
- Sometimes very slow
SharePoint was used for internal knowledge sharing for employees, education and storing employees data and mainly for keeping agents up to date with internal company news. SharePoint is easy to manage and maintain, accessible like any internal portal and secured. Having a SQL data base comes in very handy when storing data internally.
- Integrates so well with all of Microsoft's other products like Skype and Outlook.
- Easy to learn and manage by admins.
- Less coding required.
- Better access to the date base, more direct access would be nice as using API requires more technical skills.
- The search functionality.
- You still need a separate data base for example for data warehouse. SharePoint sits on top of SQL Server, which is a relational database management system.
February 28, 2020
MS SharePoint / SQL is easy to set up, with a robust feature set
We use Microsoft SQL Server as a database backend for many different applications in our company. It is used for SAP, cash management applications, file transfer software, Symantec antivirus, and employee data storage. We find it to be easy to set up and maintain and easy to grow if needed. Once you set up your maintenance plan on it, you can leave it alone for years without intervention if it's set up correctly.
- Easy to install
- Great front end to look at and manipulate data
- More widely used than other databases so more support available when needed
- Licensing can be confusing
- Like Windows, you have to upgrade/migrate to newer versions over time as older ones become unsupported
February 26, 2020
MS Sharepoint is the one collaboration tool you need.
MS Sharepoint / SQL Server is used as an enterprise solution to allow our teams to collaborate and share information and files. As the enterprise solution, I have used this for several very large programs that I have been in charge of the technical side. One was a massive database retooling for our application suite. The second large program was for a very large divestiture to make sure all data belonging to the divested team is identified and transmitted to the purchasing organization. We have team SharePoint sites set up for both programs and within the various work streams, each workstream had its own site.
- Collaboration and sharing of information.
- Security, allowing access to only those individuals with a need to know.
- It can be a little hard to master so you need to take time to read the various primers available to know how to configure and deploy SharePoint. Do you use Foundation, 365 or Server?
February 26, 2020
MS SharePoint / SQL - an on-premise option for SMBs
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.
- 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.
- 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.
October 18, 2019
SharePoint\SQL is a great for any organization to utilize
We use Microsoft Sharepoint SQL throughout our entire organization. Sharepoint is used as a central file repository for all departments and teams. This enables our employees to access files from any location worldwide. We also use Sharepoint as a notification bulletin board system to enable posting of company wide notification collaboration tools.
- Internal intranet for our company to enable users a central location for file storage, company wide notification and collaboration tools
- Enables a central file depository for teams and departments
- Great search functions
- Customizable user permissions
- Integration with 3rd party providers since Sharepoint has been around for years
- On-boarding can take some time with new hires on how to use SharePoint
- One issue we noticed is SharePoint One Drive sync issues creep occasionally
- Cache issues with certain browsers that cause issues and required the browser Cache to be cleared out
- It can become complex quickly with customization and difficult to fix when problems do arise.
September 20, 2019
Very convenient document management system.
We use SharePoint to store our documents so that each department can collaborate. It was very easy as we had to manage multiple documents from tenders and requirements spanning different timelines.
- Good integration with the Microsoft ecosystem. Active directory security is an advantage.
- Remotely accessible and the files are up to date. We can link to local storage.
- Version control.
- The search function is confusing.
- Navigation can be annoying.
September 18, 2019
SharePoint just works
It was being used at Starbucks and is being used at LendingTree to share information between individuals, teams, and organizations. We use it both for sharing business processes and information as well as training material. Some of the SQL that it generates is not tremendously performant, but the sites serve thousands of people very well.
- We're using it here at LendingTree as a centralized document storage location broken up by teams and content so it's easy to find what you're looking for in a centralized location.
- At Starbucks, we used it to pass along information to the tens of thousands of baristas located all over the world.
- Some of the SQL it generates is, or at least was, pretty horrible. It could do a better job of taking advantage of the performance possibilities within SQL Server.
- It is pretty easy for one user to change settings for an entire team, in an unintended manner. But perhaps that's just because we aren't provisioning users as well as we could be.
September 15, 2019
Organize your documents
SharePoint is a service that provides storing files within the company for us. Another advantage is being easy to use for users. They can easily access the images we deploy for our company website from SharePoint and also they can download those pictures to their computers as well.
- Solid service for company intranet.
- It organizes the company documents in one place.
- Easy to access documents.
- The user interface could be more simplified.
- Accessing outside of the company network should be easier.
- The implementation can be more smooth as it is a little challenging process.
July 18, 2019
MS SharePoint/SQL Review
I used SharePoint while working remotely. It was a great tool to have within our company when we have so many different departments located all around the U.S.
- Remote access.
- Instant update/upload of files.
- Multiple users.
- I do not find any areas where SharePoint needed to improve on.
April 26, 2019
Developer Tenancy is free for one year!
We are using SharePoint Online and SQL in Azure. It keeps our data safe and available, and eliminates the need for backups and costly infrastructure. We are building apps with forms and workflows to replace the apps in Lotus Notes. It also provides threat management and data loss prevention. Collaboration between departments is also very easy with SharePoint Teams.
- SharePoint: Data Management of documents, and turning spreadsheets into lists.
- SharePoint Online: Continuous improvements, and the ability to preview the improvements before general release.
- SQL: Excellent Database platform. Easy to connect to, and less expensive than Oracle for both implementation and management. I don't believe in using open source (i.e. MySQL) in a corporate environment.
- SharePoint: 5,000 item view limit.
- SharePoint: User groups should default to Contribute, not Edit. Edit is too much permission for end-users; it allows the users to change the table structure or even delete the whole list or library.
- If using either SharePoint or SQL on-premise, backups and patches approach nightmare level.
March 29, 2019
I'm not sure how we lived without it!
We use SharePoint to share install walkthroughs, configuration files, PMR's, PDR'S, and lots of other department specific files. We use SharePoint to ensure that our team always has the relevant information that they need to do their job, no matter where they are. We use SQL specifically as a reporting tool on the back of our Datacap tool. The error handling, monitoring, and data extracted all gets output to the data tables.
- Allow users to access documents no matter where they are.
- It's secure.
- It is end-user friendly. Our team members can use it quickly and efficiently.
- It is efficient in managing large amounts of data.
- Allows us to monitor and track data from our OCR tool.
- It can be a little difficult to get it set up. There are very few walkthroughs in it on how to set up.
- The search functionality needs improvement. It's currently nonexistent.
- It's difficult to lock down files to ensure that users who can access them don't delete them.
March 06, 2019
Good for central location storage
Microsoft SharePoint is being used across our organization on a per project basis to manage and share documents. We also share information with our clients using Microsoft SharePoint. The controls within SharePoint make it easy to control who has access to certain documents so only those who need access to a certain project have access.
- Microsoft SharePoint provides controlled access to information.
- Microsoft SharePoint allows users to access information remotely.
- Microsoft SharePoint allows collaborative work.
- The user interface for SharePoint is not exactly intuitive.
- To get the software set up correctly and to your liking, you have to have a lot of knowledge and time to customize the software.
- Basic functions and navigation seem difficult.
March 04, 2019
SharePoint Service Desk solution
We are using SharePoint as a service desk solution, including ticketing, asset inventory, purchase requisition, and project tracking. We also support several departments using SharePoint as a intranet solution. We went with SharePoint as a solution for the flexibility it provided us, while there are some drawbacks for the most part we can mold it into whatever we would like. This does require staff able to spend the time to configure and manage SharePoint though.
- Flexible - able to make any changes we would like vs traditional service desk system.
- ROI - We were already using SharePoint for internal intranet, so we are simply getting more use out of licensing we had already committed to.
- Easy to use for end users.
- Staff time - flexibility is great but in order to benefit you do need to have staff able to configure and manage SharePoint.
- Reporting - reporting leaves something to be desired both directly within sharepoint and with SQL reporting services.
March 02, 2019
SharePoint through a IT support view
SharePoint is being used globally across our company. SharePoint allows for better collaboration and file and folder sharing through OneDrive and Teams.
- As SharePoint is also the back of end of MS Teams it allows for much better many to many collaboration. It also allows for conversations in teams to be had globally between different teams within the same organization.
- Yammer is also another app which has a SharePoint backend that is now being utilized more within our company. You can join and create groups within Yammer where you can discuss work-related projects or non-work related subjects such as sharing photos and information about your pet(s).
- Within SharePoint itself, you can create document Libraries which can double up as repositories which can be used in applications such as Repstor which is a 3rd party tool that plugs into Outlook and in doing so brings SharePoint into Outlook. By doing this, you can create folders within Repstor which then sync back to the SharePoint document library. You can then file emails into these folders and make this information shareable with other users by allowing them access to the repository.
- SharePoint also allows you to set up email content types which extract the metadata from emails filed into SharePoint so that they are filed with the correct field names and those fields are populated. Doing this allows for much more efficient storage and searching.
- The technical/configuration side of it is not as intuitive as I would like it to be.
- Can be clunky and temperamental at times in that you could be working on setting up a SharePoint site and it could all just seize up. This could, however, be down to the infrastructure in our company.
- Easier and better differentiation for users so that they can easily understand the differences between SharePoint and OneDrive (my.sharepoint).
We currently use MS Sharepoint/SQL across the enterprise with a number of SharePoint farms supporting different customers who have different needs. It allows a single place for all users to collaborate on work and projects. The ability to easily share information with other users with a familiar interface allows us to address communication issues.
- Easy to share information with colleagues or partners within or outside of the organization.
- Easy to learn quickly, people are used to the interface.
- Everyone likes talking about themselves, SharePoint gives users a place to do that if they so wish.
- Setting up an external facing SharePoint site securely can be a challenge.
- Permissions can be difficult for users to set up and maintain.
- Setup can be intimidating as it can require many servers if you split all the roles out.
February 21, 2019
MS SharePoint - CMS done right
At our marketing firm, we have been heavy consumers of Microsoft products. As our company started to expand globally and due to the presence of many remote employees, we felt the need of using a proper content management system to improve interdepartmental collaboration. MS SharePoint was the natural choice for us mainly due to our existing alliance with Microsoft.
- Access and sharing through users is role-based and very familiar to the regular Microsoft Office suite.
- Document versioning and backups is a breeze.
- Microsoft SharePoint is one of the best tools for sharing and collaborating on internal documentation.
- Exposing websites outside the intranet can be really challenging.
- Customizations to provide the same look and feel to make it compliant with other company resources can be daunting as well.
February 15, 2019
Ms SharePoint: tried it and I'm satisfied
It is used within our bank to store all the documents for all the departments (HR, IT, the Cards Team, etc.) It is used to share any new documents or updated when a document is modified.
- Easy to configure
- Easy way to share your documents
- Makes transparency easy
- None, as I didn't work with any thing other than MS SharePoint
January 12, 2019
Perfect Data Integration Tool
Sharepoint is used across all the departments in the organization. Sharepoint enables us to monitor, collect, and analyze critical business data from desktops, smartphones, or any Internet-enabled devices, in order to achieve an accurate view of business operations.
- Extremely convenient to collaborate effectively by setting up websites for sharing information related to projects.
- Enables users to manage documents with interactive dashboards and graphs to analyze organizational needs.
- Easy to customize, providing options to edit components and create your own custom applications to suit your organization.
- Excessive features can sometimes be overwhelming and difficult to locate. Also, configuring security is slightly complicated unless you are a SharePoint developer.
- Sometimes the application freezes and locks up. However, this could be due to the network configuration from my organization's end.
- Loading the calendars is sometimes slow and freezes.
December 28, 2018
Great Collaboration Tool
SharePoint is used in our organization to facilitate collaboration on the production of technical reports that will be made available to the public. It is a very effective tool for our technical report preparation and allows various teams to seamlessly contribute by marking up the documents from any platform. Office Online Server is used in conjunction with SharePoint naming the overall package a winner.
- The collaboration of Technical Reports.
- Has a good search feature.
- Ease of posting content.
- Updates can be tricky to apply.
- Implementation is difficult.
- It is hard to find good SharePoint consultants at reasonable rates.