How to identify PID of AppPools

I thought i would reshare how to find the PID of an AppPool, as it's not the easiest thing to find if your not familiar with the process.

This allows you to map the w3wp process to the AppPool that you are trying to diagnose.

Step1 - Open IIS Manager, go to the root node in the tree on the left that represents your computer (should be labelled as your computer name)
Open IIS Manager

Step2 - In the features view to the right, you'll see a section called IIS. Under that you'll see Work Processes.
Worker Processes

Step3 - Select that and it should show you all running worker processes and some basic info, including Process ID (PID)
Process ID (PID)

Step4 - You can map that Process ID to the matching process in the Process tab in Task Manager.

This is a repost, the original post can be found on the MSDN Blogs here.

How to increase the Umbraco Media upload limit

If you need to increase the upload limit with Umbraco, this can easily be done if you have root access to your server.

You may have to contact your hosting provider if this is not the case.

First off, you need to update your Web.Config allow the file size you need...

Carry out a search for:

maxRequestLength

Then change the value to the file size you require in kb, for example 100MB in kb is 100000

Once you have made this change you need to update IIS to also increase the limit, there are 2 ways to do this...

First Way:

Navigate to:

cd %winsrv%\system32\inetsrv

and run this code:

appcmd.exe set config "sitename" -section:requestFiltering -requestLimits.maxAllowedContentLength:size in bytes -commitpath:apphost

Second Way:

Open Internet Information Services (IIS) Manager find your website under Sites and click on its name.

Then under IIS click on Request Filtering in this section on the right click on Edit Feature Settings

Then change the Maximum allowed content length (Bytes) in my case again 100MB is 104857600Bytes.

Click Ok and then restart your sites Application Pool

(Original Source)

Visual Studio update to 15.5.3 breaks donet core 2.0 solution

I came across an issue after updating my Visual Studio version to 15.5.3 which would cause my solution to throw an exception whenever it tried to access the database.

System.IO.FileLoadException: 'Could not load file or assembly 'System.Data.SqlClient, Version=4.2.0.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'

The fix for this is nice and easy, you just need to install the NuGet (V4.4.2) package System.Data.SqlClient.