Power BI: Calculate The Project Status In Project Server

In this article, I will explain

How to Calculate The Project Status In Project Server based on the Project Start and Finish Date In Power BI?

Power BI: Calculate The Project Status In Project Server Continue reading “Power BI: Calculate The Project Status In Project Server”

Advertisements

SQL Server: Get the Detailed Information Via SERVERPROPERTY

In this article, we will explain

  • How to get the SQL Server Instance Information using “SERVERPROPERTY”?
  • How to get the SQL Server Instance Information remotely?

What’s the SERVERPROPERTY?

SERVERPROPERTY is a System Defined function used to return the SQL Server Instance Information.

SERVERPROPERTY Syntax

SERVERPROPERTY ('propertyname')

propertyname is one of the following values.

  • MachineName.
  • ComputerNamePhysicalNetBIOS.
  • ServerName.
  • InstanceName.
  • InstanceDefaultDataPath.
  • InstanceDefaultLogPath.
  • Edition.
  • EditionID.
  • EngineEdition.
  • ProductBuild.
  • ProductBuildType.
  • ProductLevel.
  • ProductMajorVersion.
  • ProductMinorVersion.
  • ProductUpdateLevel.
  • ProductVersion.
  • BuildClrVersion.
  • Collation.
  • LCID.
  • IsSingleUser.
  • IsIntegratedSecurityOnly.
  • IsHadrEnabled.
  • HadrManagerStatus.
  • IsAdvancedAnalyticsInstalled.
  • IsClustered.
  • IsFullTextInstalled.
  • ProcessID.

Continue reading “SQL Server: Get the Detailed Information Via SERVERPROPERTY”

SharePoint 2016: Show a List From Parent Site In Sub Site

In this article, I will Show

How to display a SharePoint list from Parent site in Sub Site?

Scenario

In SharePoint 2016, I have a list in the parent site, I would like to show this list inside a page in the subsite.

So that when adding a new item to this list from the subsite, it should also be listed in the same original list in the parent site and vice versa.

Note: You can use the same steps to display a SharePoint list from subsite in parent site.

Continue reading “SharePoint 2016: Show a List From Parent Site In Sub Site”

Migrate PWA Instance from Project Server 2013 to Project Server 2016

In this article, I will explain

How to Migrate from Project Server 2013 to Project Server 2016 Step By Step?

Prerequisites

Before we get started, you should check the below Project Server 2016 Migration Prerequisites.

In Source Farm,
  • Make sure that the current Project Server 2013 farm is at least patched to Service Pack1.

To get the latest SharePoint Cumulative Update installed check Find farm patch level / latest cumulative update that has been installed on SharePoint farm

  • Specify the Web Application content databases.
  • Specify the PWA instance with its ‘Project Web App‘ database.
  • Take a full database backup for the PWA instance database.
  • Take a full database backup for the Project content databases.
In Destination Farm,
  • Prepare Project Server 2016 farm.
  • Take a full database backup from the Content Database.

Note: In Project Server 2016, a single database (SharePoint Content Database) holds the project data and the content to facilitate the database operations, such as backup and restore, migration, etc.


Source Farm Prerequisites

Continue reading “Migrate PWA Instance from Project Server 2013 to Project Server 2016”

SharePoint 2013 setup unable to proceed : This Product Requires Microsoft .Net Framework 4.5

In this article, I will be fixing this error

SharePoint 2013 setup unable to proceed due to the following errors: This Product Requires Microsoft .Net Framework 4.5

This Product Requires Microsoft .Net Framework 4.5 Continue reading “SharePoint 2013 setup unable to proceed : This Product Requires Microsoft .Net Framework 4.5”

Configure Content Management Interoperability Services (CMIS) In SharePoint 2016

In this article, I will answer the below CMIS questions

  • What’s The CMIS?
  • What’s the SharePoint CMIS Procedure?
  • How to configure CMIS Procedure in SharePoint 2016?

What’s The CMIS?

CMIS stands for Content Management Interoperability Services. It’s a web service standard that allows different content management systems to inter-operate seamlessly over the Internet.


What’s The SharePoint CMIS Procedure?

The Content Management Interoperability Services (CMIS) Producer is a SharePoint feature that allows the applications to interact with SharePoint lists and document libraries programmatically by using the interfaces that are defined in the CMIS standard.

Note:

  • CMIS is turned off by default on all on-premises sites.
  • CMIS is available after the Content Management Interoperability Services (CMIS) Producer feature is activated.
  • CMIS is not supported in SharePoint Online.

How to configure CMIS Procedure in SharePoint 2016?

To configure CMIS in SharePoint 2016, you should do the following: Continue reading “Configure Content Management Interoperability Services (CMIS) In SharePoint 2016”

SharePoint Lookup Field Multiple Values Via C#

In this article, we will explain How to programmatically

  • Set a SharePoint Lookup Field (Single Value) via SSOM C#.
  • Set a SharePoint Lookup Field (Multiple Values) via SSOM C#.
  • Get a SharePoint SharePoint Lookup Field (Single Value) via SSOM C#.
  • Get a SharePoint SharePoint Lookup Field (Multiple Values) via SSOM C#.

 Continue reading “SharePoint Lookup Field Multiple Values Via C#”