Mohamed El-Kassas

Get the first record added per day group by the user in SQL

In the previous post Get the last record added per day group by the user in SQL I explained How to get the last entry for each user per day.

In this post, I am gonna to explain

How to get the first record added per day for each user in SQL.

Get the first entry added per day for each user in SQL

Consider you have a [Transaction] table to save multiple transactions for different users…

Get the last record added per day group by the user in SQL

In this post, I am gonna explain

How to query the last entry added per day for a user in SQL.

Get the last entry added per day group by the user in SQL

Consider you have a [Transaction] table to store multiple transactions for different users daily!

(more…)

Windows Server 2016: Switch from Server core to GUI

I tried to install Windows Server 2016, I got the dialog that ask me to select the operating system that I would like to install as shown below:

You may be also interested to check Windows Server 2016: Expand Virtual Machine Hard Disk & Extend the Operating System Drive.

Actually, I have confused which option should I use

Windows Server 2016 Standard or,

Windows Server 2016 Standard…

Import Excel Sheet Into Project Server

In this article, I will explain How to

Import excel sheet into Project Server / Project Online.

You may be also interested in Create a New Project From SharePoint List Item In Project Server 2016.

(more…)

Roll up Summary Task In SharePoint Task List

In this article, I will show how to

Roll up the % Complete for the Summary Task in SharePoint Task List.

You may be also interested in Count All Tasks in Project Server

Scenario

(more…)

Can’t download the SharePoint prerequisites

In this article, I will fix the below SharePoint Prerequisites download error:

Error: The tool was unable to download Microsoft SQL Server 2012 Native Client. Please check your Internet connection and try again.

(more…)

Could not connect to the specified Project Web App URL

In this article, I will solve the below Project Server issue

Could not connect to the specified Project Web App URL.

Scenario

(more…)

Missing Save As Power BI Report Server In Power BI Desktop

In this post, I will solve the below issue

Missing Save As Power BI Report Server Option In Power BI Desktop.

Check also Install and Configure Power BI Report Server (On-Prem) step by step.

(more…)

Comments In SharePoint Designer

In this article, I will show How to 

Add comments on a highlighted code in SharePoint Designer.

(more…)

Convert Numbers To Time In SharePoint

In this article, I will explain How to

Convert Numbers To Time In SharePoint Calculated Field

Scenario

I have a SharePoint list, one of its columns is a number column that holds a duration value with minutes.

I would like to display the number of minutes as a Time Format (hh:mm) in the SharePoint Calculated field as shown below:

(more…)

Project Server 2016: Invalid object name ‘pjrep.MSP_EpmProject_UserView’

In this article, I am going to fix the below issue

Missing Views ‘pjrep.MSP_EpmProject_UserView’ in Project Server 2016 Database.

Scenario (more…)

Missing Alerts and Reminders in Project Server 2016

In this article, I will explain

How to configure Alerts and Reminders in Project Server 2016

You may be interested to know How to Install and Configure Project Server 2016.

(more…)

Security Token Serviec cannot be activated due to This collection already contains an address with scheme http

In this article, I’m gonna to fix the below SharePoint Event log issue

WebHost failed to process a request Exception: System.ServiceModel.ServiceActivationException: The service ‘/_vti_bin/sts/spsecuritytokenservice.svc’ cannot be activated due to an exception during compilation. The exception message is: This collection already contains an address with scheme http.

Solution 

To overcome “The…

The installation of this package failed – Update SharePoint Server

In this hint, I’m gonna solve the below SharePoint Package update issue

The installation of this package failed

(more…)

SharePoint 2016: Failed to create the configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown

In this article, I will solve the below SharePoint 2016 Configuration Wizard issue

Failed to create the configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.

Scenario

Unfortunately, I didn’t have an internet connection on the…

No Project web app instances found. Create at least one PWA instance before accessing this page In Project Server 2016

In this article, I will fix the below Project Server 2016 issue

No Project web app instances found. Create at least one PWA instance before accessing this page

Scenario

After creating the PWA 2016 Site Collection, I have tried to browse it, but i got the below error

No Project web app instances found. Create at least one PWA instance before accessing this page

Cause (more…)

SharePoint Limitations – Security Limit Maximum value

The SharePoint Security Limit Maximum value Limit Maximum value Limit type Notes Number of SharePoint groups a user can belong to 5,000 Supported This is not a hard limit but it is consistent with Active Directory guidelines. There are several things that affect this number:

The size of the user token

The groups cache: SharePoint Server 2010 has a table that caches the number of groups a…