SQL 2016 uses little RAM

I have a SQL 2016 server, version:
(SP2-CU4-OD) (KB4482972) – 13.0.5239.0 (X64)

The server is a Win 2016, with 64 GB of RAM.
I have configured the maximum memory for SQL to 54 GB, but it uses less than 1 GB.
Data has been migrated from an older SQL version.

Can someone help me?

Thank you

How to change the name of the sender in the OpenIDConnect discovery document on Windows Server 2016 ADFS

I installed ADFS on Windows Server 2016 and the discovery document looks like this: https://ad.nexgen.am/adfs/.well-known/openid-configuration

You can see that the name of the sender is in capital letters "AD", which means that my OpenId client generates an error: the name of the sender does not correspond to the authority.

It looks like the name of the transmitter is case sensitive as mentioned here: https://stackoverflow.com/questions/43626944/getting-discoveryclient-fails-with-issuer-name-does-not-match- authority

For some reason, the OIDC client doesn't seem to like the authority URL in uppercase and I have a feeling that it is converting it to lowercase. Everything works fine if I tell the OIDC client not to validate the name of the sender, but it seems to me to be a hack.

I tried to modify the properties of the ADFS service from the user interface and set the "Federation service name" and "Federation service identifier" which does not seem to update the 39; issuer in the discovery document.

I understand that the computer name is in uppercase, which is why this is happening, but I really don't want to go there as it is a domain controller and I & # 39; I have read horror stories about the change of name of a domain controller.

Any other suggestions?

Does anyone know why differential backups of SQL Server 2005 will not be restored correctly on SQL Server 2016? And how can I fix it?

We plan to migrate from the old SQL 2005 server to the SQL 2016 server with differential backup, but I read an article that differential backup does not support properly.

Upgrade / migration / site -> question on site collection in Sharepoint 2010 and Sharepoint 2016

Hoping for some thoughts / advice on the approach for this. I'm in the middle of an upgrade / migration project from an SP2010 to SP2016 environment. Due to gaps in versions, the approach we take is to provision an SP2016 environment, create the required topology, and then use a migration tool (most likely Sharegate) to actually migrate the content from the ; old environment to new environment.

Existing usage is fairly straightforward (there is not a lot of customization) but the volume data is not trivial – it is at least a few hundred GB, currently all in one database content data. For this reason, in the context of migration, it makes sense to reorganize a bit and ensure, for example, that site collections have their own database.

Anyway, the question / advice: there is a sub site from the root site collection which has a lot of content and this is the one I would like to move to its own site collection so that its data can go into a separate content database. The problem is that the URLs will have to stay the same after the migration because they are linked to another system.

I will try to illustrate! Currently, there is a SP2010 server, which we will call SP2010SERVER. There is a CNAME in DNS that points to (with AAM configured AFAIK), for example, SHAREPOINT. So, for now, you can browse the content in SP2010SERVER using the DNS name of SHAREPOINT. There is a subsite, which we will call SUBSITE1, and the URLs are there for example, http: // sharepoint / subsite1. (Note: there are many other subsites and site collections with managed paths, etc.)

We have the new SP2016 server; which let's say is called SP2016SERVER. Once done, the idea is to switch the DNS record so that SHAREPOINT is now pointing to SP2016SERVER.

I need to move the current SUBSITE1 to its own site collection in the new environment while keeping the URL of http: // sharepoint / subsite1. Migrating content to the root site of a new site collection is pretty trivial, I think, but the question is how to keep the URL. I cannot use a managed path (afaik) because if I configured for example, “ subsite1 & # 39; & # 39; as a managed path, it would still need a site collection name after the path.

I have studied host-name (d) site collections as a possible solution. I think in this case you can more or less specify any URL for the site collection, but I haven't used them before and all of the examples I've seen tend to use a sort of subdomain.domain.tld. type configuration.

Would it work for my needs? If not, are there any other solutions or options for this?

I imagine I could get the same thing with some sort of IIS magic / redirect, etc., but I was hoping to avoid that if possible.

Thanks for any thought / help!

Windows Server 2016 – create shared volume from folder in partition volume

I have a server with Windows Server 2016 with a 2 TB space drive.
I have 3 volumes of partitions.
My need is to use a partition and create folders inside representing the services of the company.
For each folder, I tried to create a virtual drive so that a user for example in HR could see a volume A with the name HR, so that all HR documents of HR users are stored there.
So I tried to create a virtual disk with iscsi but when I try to create it, it fails.
What requirements have I missed before making this possible?

Cannot uninstall Sharepoint 2016

Unable to uninstall Sharepoint 2016 using the control panel, after clicking Change / Uninstall, nothing happens.

Is there another way to uninstall?

vba – Excel 2016 – Worksheet_Change does not fire after the macro of click on the button added to the module

I have the following code (which clears values ​​in dependent dropdowns) in the Sheet2 code window

    Private Sub Worksheet_Change(ByVal Target As Range)
    'Update by Extendoffice 2018/06/04
    On Error GoTo ErrorHandler
    Application.EnableEvents = False
    If Target.Column = 5 And Target.Validation.Type = 3 Then
    Target.Offset(0, 1).Value = ""
    Target.Offset(0, 2).Value = ""
    End If
    If Target.Column = 6 And Target.Validation.Type = 3 Then
    Target.Offset(0, 1).Value = ""
    End If
    Application.EnableEvents = True

    ErrorHandler:
    Application.EnableEvents = True
    End Sub

This code worked fine until I added a button and the following code (which copies the existing line and inserts the selection into a new line) in Module1. Now the Button event is working fine, but the Change event never seems to fire.

    Sub AddRow()
    Dim LastRow As Long
    Dim NextRow As Long
    With Sheet2
        LastRow = .Range("B" & .Rows.Count).End(xlUp).Row
        NextRow = LastRow + 1
            With .Range("B" & LastRow & ":I" & LastRow)
                  Range("B" & LastRow & ":I" & LastRow).Select
                  Selection.Copy
                  Range("B" & NextRow & ":I" & NextRow).Select
                  Selection.Insert Shift:=xlDown
                  Range("C" & NextRow & ":I" & NextRow).Select
                  Selection.Clear
            End With
    End With
    End Sub

Any suggestion?

upgrade – migrate a sharepoint subsite 2013 to 2016

What is the error you get when migrating the content database, could you share it here? About common troubleshooting in content database migration, you can refer to the article below:

SharePoint migration: basic tips and tricks in a migration project

In a second approach, you can use the third-party migration tool like sharegate, Metalogix or the Microsoft SharePoint migration tool.

Sharegate and Metalogix – a trial version is available, you can download it and the Microsoft SharePoint migration tool is a free version, you can also use it.

Do you remember in 2016 when the liberal media declared that Trump had no chance and that he then won?

The reason we think you are stupid is that you don't seem to realize that we all live in the same country. You applaud for the things that are ruining our country because it will make the Liberals cry. BUT YOU ALSO LIVE HERE.

For one example, when you applaud the repeal of Obamacare because you think it will hurt people you don't like, you're so stupid that you don't realize YOU will lose them. benefits you now have in healthcare. Be wise.

Sharepoint 2016 On Prem Single sign-on with Web API

We have an on-premises SharePoint 2016 site that uses both forms-based authentication and Windows authentication.

We plan to add SharePoint Framework Web Parts (SPFx) to the site. For this, we are developing a custom Web API. I am looking on the Internet for a solution to create a unique authentication behavior with SharePoint and the main custom web API .Net.

If anyone has an idea, it will be of great help.

Thank you