Software
U2U Caml Query Builder for SharePoint (Standalone Edition)
CAML (Collaborative Application Markup Language) is an XML-based query language that helps you query lists and libraries in SharePoint. This desktop application has been developed to ease the work of SharePoint on-premises and SharePoint Online developers. It helps you create and test your CAML queries. This edition uses the Client Side Object Model to connect to any remote SharePoint on-premises or SharePoint Online environment. The following prerequisites are required: Microsoft .NET Framework 4.6 (x86 and x64) The original CAML Query Builder dates from before the existence of SharePoint Online. It was later adapted to also work with SharePoint Online, but it could not handle multi-factor authentication. Therefore, a new version was created that supports multi-factor authentication. There are now two versions of the CAML Query Builder. If you want to use the tool with SharePoint on-premises, use the on-premises version. It also works with SharePoint Online when you are not using MFA. If you are using SharePoint Online with MFA, use the online version, which also works without MFA.
SqlASDoc, the Analysis Services Documenter
Analysis Services Documenter (SqlASDoc for short) is a tool which creates documentation for your Analysis Services databases. It connects to your live server, and queries the metadata for the name and description which the developers attached to every object (database, cube, dimension, hierarchy, attribute, translation, data source, data source view,...). It then produces an HTML file which contains the name and description of all these objects. But there is more: also other properties, such as last processing time, creation time, sizes of fact tables etc. are written to the HTML file.
It's a clickonce application, so the download will automatically install the tool. The tool also regularly checks for updates. Currently, the tool is available for free. However, notice that this software is licensed “as-is.” You bare the risk of using it. U2U gives no express warranties, guarantees or conditions.
License
The MIT License (MIT) Copyright (c) U2U
Permission is hereby granted, free of charge, to any person obtaining a copy of the above software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
