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#”
Consider you need to install a new Cumulative Update or Service Pack on your current SQL Server, but you don’t know what’s the current update level that already installed on your environment!!
In this article, we will explain
How to detect the current Cumulative Update / Service Pack that was installed on SQL Server.
Detect the Current Cumulative Update / Service Pack Installed
You can use the ServerProperty as a system defined function to return the SQL Server Instance information like the ProductLevel and ProductUpdateLevel
The ProductLevel returns the version level of the SQL Server instance as the following.
- ‘RTM‘ = Original release version
- ‘SPn‘ = Service pack version
- ‘CTPn‘, = Community Technology Preview version
select SERVERPROPERTY('ProductLevel') as 'Product Level'
Continue reading “Get the Update Level In SQL Server 2016”
In this article, I will show
How to detect the SharePoint 2016 Edition and the Farm Build Number via Server Side Object Model – C#.
Get SharePoint 2016 Edition
The below function “Get_SPEdition” is used to detect the SharePoint 2016 Edition, based on the installed product SKU it shows the corresponding edition.
Continue reading “Detect the Installed SKU of SharePoint 2016”
In this article, I will explain
How to detect the installed SharePoint Edition Using PowerShell?
Before you run this script, you should make sure that the current user has sufficient privilege to run PowerShell Script in SharePoint, Read more at Add-SPShellAdmin
Note: You can directly use the farm account to run this script.
There is a lot of articles talk about this topic, but the new here is detecting the SharePoint 2016 Edition based on the SKU ID. Continue reading “Detect the Installed SharePoint Edition Using PowerShell”
In this article, I will show
How to query data from SharePoint List / Library in Power BI.
Get SharePoint List/Library Using OData Feed
First, let’s briefly define the OData?
- The Open Data Protocol (OData) is a data access protocol for the web.
- OData provides a uniform way to query and manipulates datasets through CRUD operations (create, read, update, and delete).
- OData defines an abstract data model and a protocol that let the client access information exposed by SharePoint.
Continue reading “Get SharePoint List items in Power BI”
In this article, I will talk about the below bug in Project Server 2016.
The Site Title can not be changed in Seattle Master Page in Project Server 2016.
By default in Project Server 2016, the assigned Master Page for the PWA Instance is Seattle with Home word as a Site Title.
So I have tried to change the PWA Site Title through
- Site Settings > Look and Feel > Title, Description and Logo.
But unfortunately, The new Site Title is not changed as shown below:
Actually, I didn’t face this issue before in Project Server 2013 with Seattle Master Page, and I think it’s a bug in Project Server 2016. So I raised this bug in Project User Voice.
Please don’t forget to upvote this voice to get this issue solved as soon as possible!
By the way, The farm has been updated with the latest Cumulative update (Sept 2017) for SharePoint 2016 and looks like the issue still not solved!
Continue reading “Project Server 2016: Can’t change the Site Title in Seattle Master Page”
In this article, I will show How to
Export Data View Web Part To Excel In SharePoint 2013 / 2016
In SharePoint 2013, I created a Data View Web Part with an external database connection as a data source via SharePoint designer.
Continue reading “Export Data View To Excel In SharePoint 2016 / 2013”