Salaudeen Rajack's SharePoint Experiences!
CAML stands for Collaborative Application Markup Language. It’s an XML-based query language used to query against data in SharePoint. How to use CAML query in PowerShell? We create a CAML query and pass an SPQuery object to retrieve filtered list items from the object. Here is a basic example of using the…
Read more
While troubleshooting SharePoint Email issues, as a first step, we have to check outgoing Email settings applied on the SharePoint Central Administration site are valid. So, how to test SharePoint outgoing email quickly? Here are my PowerShell scripts to test outgoing emails in SharePoint 2013 or 2016. Method 1: Send Email using…
Read more
Requirement: Set content database to read only in SharePoint Server using PowerShell. Solution: We may have to set SharePoint databases to read-only mode in scenarios such as upgrades, disaster recovery / highly available maintenance, patching, etc. Setting SharePoint content database in read-only mode from SQL Server Management Studio is explained in another…
Read more
Requirement: Move SharePoint content database from one drive to another in SQL Server! By default, SharePoint creates its databases in the default SQL Server location: “C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA” folder (SQL Server 2016). We don’t have any option from the SharePoint side to specify where the data and log files for the…
Read more
Problem:During SharePoint 2013 migration, we ran the Test-SPContentDatabase cmdlet, and the output report contains several MissingAssembly errors! Category : MissingAssemblyError : TrueUpgradeBlocking : FalseMessage : Assembly [DealEventEventhandler, Version=1.2.6.0, Culture=neutral, PublicKeyToken=b4122bae67581526] is referenced in the database [wss_content], but is not installed on the current farm. Please install any feature/solution which contains this assembly.Remedy …
Read more
Requirement: Move SharePoint databases to a new SQL Server! You’ll have to move SharePoint databases, including all content databases, configuration databases, and service application databases to another SQL Server at least in a couple of circumstances: Upgrading SQL Server to a new version. E.g. Upgrading SQL Server 2012 to SQL Server 2016. …
Read more
Requirement: Delete site column with PowerShell in SharePoint How to Delete a Site Column in SharePoint? Site columns in SharePoint can be deleted when we don’t need them anymore. When you delete a site column, any lists and libraries with the particular site column don’t get affected, and that site column becomes…
Read more
Requirement: Get all users of SharePoint Farm. SharePoint PowerShell to Get All Users in Farm Do you want to get a list of all users in your SharePoint farm? PowerShell can help you with this! This blog post will show you how to use PowerShell to quickly find all users in your…
Read more
Here is how to check whether standard or enterprise edition is installed in SharePoint 2013. Go to Central Admin >> Upgrade and Migration >> Click on “Enable Enterprise Features”. This procedure stays the same to check standard or enterprise SharePoint 2010 and SharePoint 2007: When the “Enterprise” is selected and grayed-out, it’s…
Read more
Introduction:Active directory federation services is the solution for extending enterprise identity beyond the corporate firewall. It simplifies sharing identities between trusted partners across organizations. It’s a common requirement in a typical business scenario, users in one organization want to access a secured application/website from another organization. Without ADFS, we’d end-up re-creating user…
Read more