We have users that do not have Visual Studio installed on their computers, we need these users to be able to check files into Team Foundation Server Source Control 2015. I have read a lot about TFS Team Explorer and Power Tools but I don't know which will be better for our requirements. How do I choose which to use? One type of file that will commonly be checked in is SQL scripts. Which will be the best approach to use to enable our DBAs to check their files in?
I'm pretty sure you could use the Visual Studio Web Portal to manage all your source (perform checkins, checkouts). You just need to set up the permissions for these users. As nschonni said you will need to Purchase a TFS CAL for these users which is usually cheaper than buying them a copy of Visual Studio. I believe that Microsoft got rid of team explorer in order to push more users towards using the web interface which has greatly improved with each build.
This might be helpful for that method. Not sure if your using TFVC or GIT
https://www.visualstudio.com/en-us/docs/connect/work-web-portal