2019 – SP2019 – Load Balancing

I have SP2019 set up in MinRole topology ( x2 App w/search and x2 Web w/ DistCache ).

What’s the best way to load balance ? I am thinking of using the standard Windows Server NLB feature.

Do I only need to load balance the x2 Web Front End servers ? or do I also need to load balance the apps servers too ? My understanding is no, as that is handled within MinRole itself.

Other aside question; if my x2 Web w/dist cache servers are acting as the web servers, why do all of the app pools and sites appear on all servers within IIS including the app w/search servers ?

Thanks in advance!

windows – Anyone tried building bitcoin core with visual studio 2019?

I followed the steps mentioned in the below link:


Trying to build from https://github.com/bitcoin/bitcoin/tree/0.20



Error   C1083   Cannot open include file: 'QApplication': No such file or directory bitcoin-qt  bitcoin-0.20.1srcqtbitcoin.h    12
Error    MSB3073 The command "C:Qt5.9.8_x64_static_vs2019binmoc.exe  "....srcqttestaddressbooktests.h" -o .QtGeneratedFilesqtmocmoc_addressbooktests.cpp" exited with code 3.    test_bitcoin-qt bitcoin-0.20.1build_msvctest_bitcoin-qttest_bitcoin-qt.vcxproj  103
Error    MSB3073 The command "C:Qt5.9.8_x64_static_vs2019binmoc.exe  "....srcqtbitcoinamountfield.cpp" -o .QtGeneratedFilesqtbitcoinamountfield.moc" exited with code 3.   libbitcoin_qt   bitcoin-0.20.1build_msvclibbitcoin_qtlibbitcoin_qt.vcxproj  168

Related Questions:

building bitcoin-qt.exe using Visual Studio 2017

Environment for building Bitcoin core in Windows



SQL Server 2019 Database stuck In Recovery state after restart

There’s not really anything you can do. Your database is going through crash recovery, and it needs to process the transaction log. I’ve written about this exact scenario more in depth here.

If SQL Server hadn’t completed a CHECKPOINT recently, there would be database changes that were committed, but had only been made in memory & in the transaction log, but not in the data files. These changes need to be redone from the log file so that the changes aren’t lost. This is what your server is doing right now. I describe the phases in more detail in the article I linked to earlier.

If your transaction log is unnecessarily very large, this can cause SQL Server to do checkpoints less frequently. A too large log file, or too many VLFs can both result in a longer recovery time after a crash.

For a planned restart you can minimize/eliminate the delay by performing a manual CHECKPOINT; before shutting down and by allowing the SQL Server service to gracefully stop. Rebooting the server without first stopping the service can result in a forced termination of the sqlservr.exe process, leading to recovery like you’re seeing on startup.

To get your database back online, just be patient. Don’t restart, don’t try to get rid of your log file. Just be patient. That estimated recovery time is notoriously incorrect, so hope that it’s online sooner, rather than later.

RDLC report not working after upgrading from Visual Studio 2008 to Visual Studio 2019 with Sql Server 2016

Please kindly help. After RDLC report updated with visual studio 2019 is not working with SQL server 2016.

Message=An error occurred during local report processing.

Inner Exception 1:
DefinitionInvalidException: The definition of the report ” is invalid.

Inner Exception 2:
ReportProcessingException: The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace ‘http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition’ which cannot be upgraded.

macbook pro – AirPods Pro connected to 2019 MBP; receiving end hears static

As you could probably tell from the title, whenever I call someone with my AirPods connected to my MacBook, the receiving end of the call hears just a super robotized voice and a very static-like sound, so bad to the point where its not understandable. This happens on all kinds of calls (Discord, FaceTime, anything) and only happens with my Mac. However, itt doesn’t happen all the time but I would say occurs 80% of the time? I don’t quite know what causes the other 20% to work. This problem has been occurring consistently but only on my MacBook and not on my iPhone nor my ipad, so I don’t know what the problem is.

2013 Workflow Continuously Restarts in 2019 Environment

We are upgrading our 2013 on prem farm to 2019 on prem. We’ve completed creating the 2019 farm and migrated the data using AvePoint, a migration tool. I have a 2013 workflow that set to run on change but it continuously restarts itself on the 2019 farm. It restarted 21 times in one minute and locks the item for editing while it’s running. Is there a setting we’re missing?

In our 2013 farm, the 2013 workflows that are set to run on change will only run/be triggered if someone physically updates the item manually. In other words if the system makes updates behind the scenes after the form is submitted the 2013 workflow is not triggered.

2019 – Site Visits (Site Analytics) always return Zero SharePoint Modern Site

I have a Communication Sites and Team Sites in my SP 2019 farm.


Communication Site – It does not showing Site visits (Always return Zero) but in the New Items has the value in Site Analytics also Popularity Trends returns the some valid data.

Team Site – It was working fine. It shows number of Site visits and New Items in Site Analytics

Anyone help me on this!!

Executing Visual Studio 2019, stored in a remote server

I have a personal computer, and a server. On both systems, Windows 10 Pro is already installed.


I want to execute Visual Studio 2019 Enterprise on my personal computer, but place the application’s installation locations on the server.

Full explanation

On my personal computer, I have a total of 32Gb of disk space. It goes without saying that the OS takes most of it, leaving behind at most 500Mb of free space. On the server, there’s more than 500Gb of disk space. It’s more than enough to install virtually any software that’s currently publicly available.

My problem is that I can only execute Visual Studio 2019 (either community, pro, or enterprise) on my personal computer. I want to develop Android applications with Visual Studio, but the server doesn’t have a recent enough processor to allow hardware acceleration, and in order to run an android emulator, I need this feature.

So, I’d like to know if it’s possible to store the application on the server, but still be able to run it on my personal computer.

What I tried so far

Attempt #1

I tried to create a shared folder on the server and replaced C:Program Files and C:Program Files (x86) with directory symbolic links (see this post for how the idea came to me):

mklink /D "C:Program Files" "\serverwindowsProgram Files"
mklink /D "C:Program Files (x86)" "\serverwindowsProgram Files (x86)"

The problem is that permissions don’t translate well over network directories. In other words, my personal computer can’t execute anything that’s stored through the symbolic link (at least, when I boot the OS and log into my account, a bunch of application-specific error messages are displayed (like “Microsoft Xbox Bar” not found, and many more)).

Attempt #1.1

I then tried to symlink Visual Studio’s installation directories, as they are actually what I want to put remotely. The problem I encountered here is that I actually don’t know where all of the Visual Studio “workloads” get installed. Apparently, it is not possible to customize many of Visual Studio’s installation locations (see this). Every software of a workload can have it’s own installation location, and nothing seems customizable by the user.

I’m getting out of ideas. Perhaps would you know a way to do this?