welcome to XRM blog

SharePoint provides a ton of features for a user to imply along with a ton of customizations for their convenience. This blog focuses on implementing things programmatically i.e. using the REST API to get the work done.

Office 365 to SharePoint Migrating using SSIS integration toolkit

SSIS Integration Toolkit for Office 365 and understanding of SharePoint.

Migration in SharePoint is a challenging task for Member. with the help of SSIS Integration Toolkit make easy in migration.

SharePoint SQL Query to Get the Site Names, Site List & Libraries

SELECT

Webs.Title AS 'Site Name',

AllLists.tp_Title AS 'List Name',

AllDocs.DirName AS 'List Partial URL',

count(1) as 'Record Count'

FROM AllDocs

JOIN AllLists

ON AllLists.tp_ID = AllDocs.ListId

JOIN Webs

ON Webs.Id = AllLists.tp_WebId

WHERE

  Webs.FullUrl like 'client/%'

group by Webs.Title,AllLists.tp_Title, AllDocs.DirName

ORDER BY Webs.Title

To see the actual record we need to run the following query

 SELECT Webs.Title AS 'Site Name',

AllLists.tp_Title AS 'List Name',

AllDocs.DirName   AS 'List Partial URL',

AllDocs.LeafName  AS 'File Name',

AllDocs.ExtensionForFile AS 'Type',

AllDocs.TimeCreated AS 'Date Created'

FROM AllDocs

JOIN AllLists

ON AllLists.tp_ID = AllDocs.ListId

JOIN Webs

ON Webs.Id = AllLists.tp_WebId

WHERE

Webs.FullUrl like 'client/a%'

ORDER BY Webs.Title

These days we hear so much about cloud computing as it’s been one of the major IT buzz for the past few years, ‘Cloud Computing’ has brought a new era with an incredible promise to the world of information technology. Cloud computing interest among the people has grown rapidly and has led to widespread curiosity and awareness of cloud services amongst the public.

The content database is probably important database in SharePoint Server 2013. The following cmdlet in PowerShell to manage content database.

Getting setup to use PowerShell to manage content databases.

There are following new features available in SharePoint Server 2016 

Excel Services is a business intelligence tool that allows you to share data-connected workbooks across an organization.

Excel Services in SharePoint Server 2013 is a shared service that you can use to publish Excel 2013 workbooks on SharePoint Server. The published workbooks can be managed and secured according to your organizational needs and shared among SharePoint Server 2013 users, who can render the workbooks in a browser. Excel Services was introduced in Office SharePoint Server 2007 and is available only in the Enterprise edition of SharePoint Server 2013.

In SharePoint 2013 there is a new service called distributed catch. The Distributed catch service is built on windows AppFabric, which implements the AppFabric catching service window server AppFabric installs with the prerequisites for SharePoint Server 2013.

The Term store management tool is a beneficial features that can help you manage Terms Sets that are used in the managed metadata service in SharePoint 2013. Term store is also preconfigured service in SharePoint Online we just need to create out Group, Term set and term as per our organization requirement.