SQL Server 2019 (RTM) – 15.0.2000.5 period has expired after upgrade to CU 8

Hi i have MS SQL with version

Microsoft SQL Server 2019 (RTM) – 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)

When i use this version and performed Log shipping, there is an error and i check on microsoft doc, the error because bugs in sql and i need to upgrade the sql server with Cumulative Update that i download in here https://www.catalog.update.microsoft.com/Search.aspx?q=sql%20server%202019

i use the latest CU. at first everything was fine until about 60 days i get error that says ‘SQL SERVER Evaluation period has expired’. And this happened in 3 servers (Production, DR, UAT). after several weeks after upgrade to CU8, got period has expired.

is it normal? because when doing installation, what i do is next and next

Picture library slideshow webpart SharePoint 2019 On-Premise

I am using SharePoint 2019 On-Premise. I have created a new picture library. Add some pictures inside of it. After this, I add a picture slideshow webpart on my home page. I selected my picture library and the default view. I got this error:

This library either no longer exists or has no images in it. Please select a different library.

“Why do I got this error? I try also other views, but got the same error. I created a new view and selected it in my slideshow webpart, and got the same error.
In my virtual (VMWare server) workspace works great, but in test server environment i got described error.”

I found similar post here:
Picture library error: This library either no longer exists or has no images in it. Please select a different library
I cannot found any related information in event log.

FYI: I tried upgrade sharepoint to the newest version and not helped me…
I go step by step from this tutorial: https://sharepointmaven.com/add-slideshow-sharepoint-site/ and more others tutorials…
I just found only a small discrepancy in field preview picture(Field Internal Name= “PreviewOnForm”). This field not showing in server environment, it can be error, but I don’t know how to repair it…

Can no longer connect to localdb after updating from Sql Server 2016 to 2019

I need to restore a backup for an assignment, but SMSS said I was running v13 while the backup was made in v15. So I download and installed SQL Server Express 2019 and uninstalled the older version.

However, SMSS can’t connect anymore to (localdb)MSSQLLocalDB.

I read somewhere to add a firewall rule for sqlservr.exe. When I try to run that file manually, it says the SQL Server installation is corrupt.

So I ran the Repair from SQL Server Installation Center, everything was okay in the output log but still no luck.
I’m pretty clueless, any help is appreciated.

catalina – Big sur 11.2.2 very lagging on 2019 Macbook Pro

I have a late 2019 macbook pro (the base model). I’ve been running Catalina until yesterday when I upgraded to Big Sur 11.2.2. It’s noticeably laggy. Has anyone experienced this? I’m not sure if 11.2.1 was laggy, so I was considering downgrading. Does anyone know how I can downgrade to 11.2.1, and possibly back to Catalina?

raid1 – Windows 2019 RAID 1 Storage Pool not working

I have a 2TB RAID 1 disk on my home-based Windows 2019 Server. This has been used now for at least 5 years for storing data for my company. In the last couple of days, it suddenly started dropping off. Now looking at the Storage Services window, it tells me that one disk is OK, but the other disk has a status of “Split, OK”.

I have decided to order two replacement disks. I would like to know how I should proceed when replacing the two existing disks.

Any help would be appreciated. Preferably in the form of the steps required to perform the replacement.

javascript – Sharepoint 2019 – modify search result item template to return Office URI Schemes

I am looking for a way to open word, excel, ppt files in a local client application.
For any mysterious reasons that work in document libraries but not in search results.
I know that it works if I manually add the micrsoft URI sheme to a file-URL.

So my idea was to modify the search result item template (HoverPanel) output from the “open”-link. So that the “open”-Link does return the Microsoft Uri schema instead of the plain file-URL.
The reason why I choose this way is to avoid client-side javascript code like in cewp or script-editor-webpart.

I am definitely no javascript professional, so maybe anybody can tell me whether that is possible or not. And of course, if it’s possible, a code example would be very nice ^_^

Below the example content of Item_powerPoint.html and Item_PowerPoint_HoverPanel.html.

Item_PowerPoint.html

<html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"> 
<head>
<title>PowerPoint-Element</title>
<!--(if gte mso 9)><xml>
<mso:CustomDocumentProperties>
<mso:TemplateHidden msdt:dt="string">0</mso:TemplateHidden>
<mso:MasterPageDescription msdt:dt="string">Zeigt ein auf Microsoft PowerPoint-Dokumente abgestimmtes Ergebnis an.</mso:MasterPageDescription>
<mso:ContentTypeId msdt:dt="string">0x0101002039C03B61C64EC4A04F5361F385106603</mso:ContentTypeId>
<mso:TargetControlType msdt:dt="string">;#SearchResults;#</mso:TargetControlType>
<mso:HtmlDesignAssociated msdt:dt="string">1</mso:HtmlDesignAssociated>
<mso:ManagedPropertyMapping msdt:dt="string">'Title':'Title','Path':'Path','Description':'Description','EditorOWSUSER':'EditorOWSUSER','LastModifiedTime':'LastModifiedTime','CollapsingStatus':'CollapsingStatus','DocId':'DocId','HitHighlightedSummary':'HitHighlightedSummary','HitHighlightedProperties':'HitHighlightedProperties','FileExtension':'FileExtension','ViewsLifeTime':'ViewsLifeTime','ParentLink':'ParentLink','FileType':'FileType','IsContainer':'IsContainer','SecondaryFileExtension':'SecondaryFileExtension','DisplayAuthor':'DisplayAuthor','ServerRedirectedURL':'ServerRedirectedURL','SectionNames':'SectionNames','SectionIndexes':'SectionIndexes','ServerRedirectedEmbedURL':'ServerRedirectedEmbedURL','ServerRedirectedPreviewURL':'ServerRedirectedPreviewURL'</mso:ManagedPropertyMapping>
</mso:CustomDocumentProperties>
</xml><!(endif)-->
</head>
<body>
    <div id="Item_PowerPoint">
<!--#_ 
        if(!$isNull(ctx.CurrentItem) && !$isNull(ctx.ClientControl)){
            var id = ctx.ClientControl.get_nextUniqueId();
            var itemId = id + Srch.U.Ids.item;
            var hoverId = id + Srch.U.Ids.hover;
            var hoverUrl = "~sitecollection/_catalogs/masterpage/Display Templates/Search/Item_PowerPoint_HoverPanel.js";
            $setResultItem(itemId, ctx.CurrentItem);
            ctx.currentItem_ShowHoverPanelCallback = Srch.U.getShowHoverPanelCallback(itemId, hoverId, hoverUrl);
            ctx.currentItem_HideHoverPanelCallback = Srch.U.getHideHoverPanelCallback();
            ctx.CurrentItem.csr_OpenApp = "powerpoint";
_#-->
            <div id="_#= $htmlEncode(itemId) =#_" name="Item" data-displaytemplate="PowerPointItem" class="ms-srch-item" onmouseover="_#= ctx.currentItem_ShowHoverPanelCallback =#_" onmouseout="_#= ctx.currentItem_HideHoverPanelCallback =#_">
<!--#_
                if(!$isNull(ctx.CurrentItem.ServerRedirectedPreviewURL))
                {
                    ctx.CurrentItem.csr_PreviewImage = ctx.CurrentItem.ServerRedirectedPreviewURL;
                    ctx.CurrentItem.csr_PathLength = Srch.U.pathTruncationLengthWithPreview;
                }
                ctx.CurrentItem.csr_Icon = Srch.U.getIconUrlByFileExtension(ctx.CurrentItem);
_#-->
                _#=ctx.RenderBody(ctx)=#_
                <div id="_#= $htmlEncode(hoverId) =#_" class="ms-srch-hover-outerContainer"></div>
            </div>
<!--#_
        }
_#-->
    </div>
</body>
</html>

Item_PowerPoint_HoverPanel.html

<html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"> 
<head>
<title>PowerPoint-Daraufzeigebereich</title>

<!--(if gte mso 9)><xml>
<mso:CustomDocumentProperties>
<mso:TemplateHidden msdt:dt="string">0</mso:TemplateHidden>
<mso:MasterPageDescription msdt:dt="string">Zeigt einen auf Microsoft PowerPoint-Dokumente abgestimmten Ergebnisdaraufzeigebereich an.</mso:MasterPageDescription>
<mso:ContentTypeId msdt:dt="string">0x0101002039C03B61C64EC4A04F5361F385106603</mso:ContentTypeId>
<mso:TargetControlType msdt:dt="string">;#SearchHoverPanel;#</mso:TargetControlType>
<mso:HtmlDesignAssociated msdt:dt="string">1</mso:HtmlDesignAssociated>
<mso:ManagedPropertyMapping msdt:dt="string">'Title':'Title','Path':'Path','Description':'Description','EditorOWSUSER':'EditorOWSUSER','LastModifiedTime':'LastModifiedTime','CollapsingStatus':'CollapsingStatus','DocId':'DocId','HitHighlightedSummary':'HitHighlightedSummary','HitHighlightedProperties':'HitHighlightedProperties','FileExtension':'FileExtension','ViewsLifeTime':'ViewsLifeTime','ParentLink':'ParentLink','FileType':'FileType','IsContainer':'IsContainer','SecondaryFileExtension':'SecondaryFileExtension','DisplayAuthor':'DisplayAuthor','ServerRedirectedURL':'ServerRedirectedURL','SectionNames':'SectionNames','SectionIndexes':'SectionIndexes','ServerRedirectedEmbedURL':'ServerRedirectedEmbedURL','ServerRedirectedPreviewURL':'ServerRedirectedPreviewURL'</mso:ManagedPropertyMapping>
</mso:CustomDocumentProperties>
</xml><!(endif)-->
</head>
<body>
    <div id="Item_PowerPoint_HoverPanel">
<!--#_
        var i = 0;
        var wacurlExist = !Srch.U.e(ctx.CurrentItem.ServerRedirectedURL) && !Srch.U.e(ctx.CurrentItem.ServerRedirectedEmbedURL);
        var id = ctx.CurrentItem.csr_id;
        ctx.CurrentItem.csr_FileType = Srch.Res.file_PowerPoint;
        ctx.CurrentItem.csr_ShowFollowLink = true;
        ctx.CurrentItem.csr_ShowViewLibrary = true;
        ctx.currentItem_IsOfficeDocument = true;
_#-->
        <div class="ms-srch-hover-innerContainer ms-srch-hover-wacSize" id="_#= $htmlEncode(id + HP.ids.inner) =#_">
            <div class="ms-srch-hover-arrowBorder" id="_#= $htmlEncode(id + HP.ids.arrowBorder) =#_"></div>
            <div class="ms-srch-hover-arrow" id="_#= $htmlEncode(id + HP.ids.arrow) =#_"></div>
            <div class="ms-srch-hover-content" id="_#= $htmlEncode(id + HP.ids.content) =#_" data-displaytemplate="PowerPointHoverPanel">
                <div id="_#= $htmlEncode(id + HP.ids.header) =#_" class="ms-srch-hover-header">
                    _#= ctx.RenderHeader(ctx) =#_
                </div>
                <div id="_#= $htmlEncode(id + HP.ids.body) =#_" class="ms-srch-hover-body">
<!--#_
                    if(!Srch.U.n(ctx.CurrentItem.ServerRedirectedEmbedURL))
                    {
                        ctx.CurrentItem.csr_DataShown = true;
                        ctx.currentItem_ShowChangedBySnippet = true;
_#-->
                        <div class="ms-srch-hover-viewerContainer">
                            <iframe id="_#= $htmlEncode(id + HP.ids.viewer) =#_" src="https://sharepoint.stackexchange.com/_#= $urlHtmlEncodeString(ctx.CurrentItem.ServerRedirectedEmbedURL) =#_" scrolling="no" frameborder="0px" class="ms-srch-hover-viewer"></iframe>
                        </div>
                        <div class="ms-srch-hover-wacImageContainer">
                            <img id="_#= $htmlEncode(id + HP.ids.preview) =#_" alt="_#= $htmlEncode(Srch.Res.item_Alt_Preview) =#_" onload="this.parentNode.style.display='block';" />
                        </div>
<!--#_
                    }
                    else
                    {
                        ctx.CurrentItem.csr_ShowLastModifiedTime = true;
                        ctx.CurrentItem.csr_ShowAuthors = true; 
                    }

                    if(!Srch.U.e(ctx.CurrentItem.SectionNames))
                    {
                        ctx.CurrentItem.csr_DataShown = true;
_#-->
                        <div class="ms-srch-hover-subTitle"><h3 class="ms-soften">_#= $htmlEncode(Srch.Res.hp_SectionHeadings) =#_</h3></div>
<!--#_
                        var sectionNames = Srch.U.getArray(ctx.CurrentItem.SectionNames);

                        var sectionIndexes = Srch.U.getArray(ctx.CurrentItem.SectionIndexes);
                        if(!Srch.U.n(sectionIndexes) && sectionIndexes.length != sectionNames.length)
                        {
                            sectionIndexes = null;
                        }

                        var hitHighlightedSectionNames = Srch.U.getHighlightedProperty(id, ctx.CurrentItem, "sectionnames");
                        if(!Srch.U.n(hitHighlightedSectionNames) && hitHighlightedSectionNames.length != sectionNames.length)
                        {
                            hitHighlightedSectionNames = null;
                        }

                        var numberOfSectionsToDisplay = Math.min(Srch.SU.maxLinesForMultiValuedProperty, sectionNames.length);
                        var sectionsToDisplay = new Array();

                        var usingHitHighlightedSectionNames = Srch.SU.getSectionsForDisplay(
                            hitHighlightedSectionNames,
                            numberOfSectionsToDisplay,
                            sectionsToDisplay);

                        for(i = 0; i < sectionsToDisplay.length; ++i)
                        {
                            var index = sectionsToDisplay(i);
                            if(Srch.U.n(index))
                            {
                                continue;
                            }

                            var tooltipEncoded = $htmlEncode(sectionNames(index));

                            var htmlEncodedSectionName = "";
                            if(usingHitHighlightedSectionNames)
                            {
                                htmlEncodedSectionName = hitHighlightedSectionNames(index);
                            }
                            else
                            {
                                htmlEncodedSectionName = tooltipEncoded;
                            }
_#-->
                            <div class="ms-srch-hover-text ms-srch-ellipsis" id="_#= $htmlEncode(id + HP.ids.sectionName + i) =#_" title="_#= tooltipEncoded =#_">
<!--#_
                                if(!Srch.U.n(sectionIndexes) && sectionIndexes.length >= i && !Srch.U.e(sectionIndexes(index)) && wacurlExist)
                                {
                                    var encodedSlideIndex = "&wdSlideIndex=" + $urlKeyValueEncode(sectionIndexes(index));
_#-->
                                    <a clicktype="HoverSection" linkIndex="_#= $htmlEncode(i) =#_" href="_#= $urlHtmlEncodeString(ctx.CurrentItem.ServerRedirectedURL + encodedSlideIndex) =#_" target="_blank">
                                        _#= htmlEncodedSectionName =#_
                                    </a>
<!--#_
                                }
                                else
                                {
_#-->
                                    _#= htmlEncodedSectionName =#_
<!--#_
                                }
_#-->
                            </div>
<!--#_
                        }
                    }
_#-->
                    _#= ctx.RenderBody(ctx) =#_
                </div>
                <div id="_#= $htmlEncode(id + HP.ids.actions) =#_" class="ms-srch-hover-actions">
                    _#= ctx.RenderFooter(ctx) =#_
                </div>
            </div>
<!--#_
            if(!Srch.U.n(ctx.CurrentItem.ServerRedirectedEmbedURL)){
                AddPostRenderCallback(ctx, function(){
                    HP.loadViewer(ctx.CurrentItem.id, ctx.CurrentItem.id + HP.ids.inner, ctx.CurrentItem.id + HP.ids.viewer, ctx.CurrentItem.id + HP.ids.preview, ctx.CurrentItem.ServerRedirectedEmbedURL, ctx.CurrentItem.ServerRedirectedPreviewURL);
                });
            }
_#-->
        </div>
    </div>
</body>
</html>

sql server – SQL 2019 Linux, slow at GUI fast at sqlcmd/Query Analyzer

Server information

OS Redhat 7
Memory 100GB
CPU usage 1%
User db size 2 gb each on avg
total 7 user databases
SSMS installed on a jump server
Azure Data studio is also installed
App Gui on application server
Latency between jump server to db server <1ms
Latency between application server and db server <1ms
all are in same network, only switch is between them
all are physical machines

Issue

  1. SSMS – When I connect to SSMS, the databases in object explorer takes around 30 seconds to populate. Opening database properties takes upto 50 seconds to open
    Query analyser/sqlcmd from SSMS runs “select name from sys.sysdatabases” instantly without delay

  2. Azure data studio – Populates Databases list fairly quickly but takes more than a minute to show database properties.

  3. App Gui – also have the same behaviour as SSMS.

From every location, querying seems fast enough but GUI is found to be slow.

Different scenario

I have other SQL Server on windows OS, the SSMS, Azure data studio behaviour is usual where they populate information on GUI instantly.
We also have few database on Azure SQL Database and Azure VM, they also connect instantly and populate information instantly at SSMS GUI

What we want to achieve?

We need our App gui, SSMS to perform as fast as SQL Server on Windows OS at gui level.

So what could be the issue and how I can fix this?

Please help!

sharepoint enterprise – InvalidOperationException: Could not get algorithm from X509AsymmetricSecurityKey to make Client Context for SP 2016 in VS 2019

I’m trying to create a context to SP 2016 site with the help of a certificate using following piece of code:

OfficeDevPnP.Core.AuthenticationManager othManager = new OfficeDevPnP.Core.AuthenticationManager();
System.Security.Cryptography.X509Certificates.X509Certificate2 cert = new System.Security.Cryptography.X509Certificates.X509Certificate2({certificate path}, {password to access Certificate});
ClientContext oContext = othManager.GetHighTrustCertificateAppOnlyAuthenticatedContext({siteurl}, {clientID}, cert, {certificate issuer id});
Web objWeb = oContext.Web;
oContext.Load(objWeb);
oContext.ExecuteQuery();
string webTitle = objWeb.Title;

However, it is running fine on Visual Studio 2015 but I have various solutions in VS 2019 so it is throwing following exception in VS 2019:

InvalidOperationException: Could not get algorithm from X509AsymmetricSecurityKey

Even tried following in App.config file of my application but issue persists:

<system.web>
<compilation debug="true" targetFramework="4.7.2"/>
<httpRuntime targetFramework="4.6.1"/>
</system.web>

Any help would be much appreciated!

windows server 2019 – Missing loads of tabs on active directory

I was working inside of AD UC and all of a sudden, loads of tabs from the properties menu have disappeared for everything, OU’s etc.. Now these are the only options:

properties tabs

Even with advanced mode I still don’t get ‘Members’ tab.

Any ideas? Thanks.