EugeneChiang.com

bluebird.min.js Unhandled Rejection and WebSocket connected failed for pace.min.js for Blazor App

Error: WebSocket connection to wss://localhost:23443 failed for pace.min.js:2 Unhandled rejection for bluebird.min.js:29 Issue: What is Pace min js? Pace. js is a lightweight (~4kb minified and gzipped) and standalone JavaScript library to create beautiful progress indicators for your page load and ajax request. It automatically monitors AJAX requests, event loop lag, document ready state, and elements on... » read more

Fastest way to shrink database log files

If the database can do with just a simple backup/recovery model, then… Change database from “Full” recovery model to “Simple” recovery model (Database Properties -> Options) Shrink database log file (Tasks -> Shrink -> Files -> Shrink Log Files)

Unable to see a list of job history

Issue: Unable to see a list of past job history. Only see the most recent. Default settings limits to last 1000 records overall and last 100 records per job. Fix: Make sure the Limit size of job history log is not enabled. Else you will not be able to see older jobs history. SQL Agent... » read more

Sysinternals

https://docs.microsoft.com/en-us/sysinternals/ The Sysinternals web site was created in 1996 by Mark Russinovich to host his advanced system utilities and technical information. Whether you’re an IT Pro or a developer, you’ll find Sysinternals utilities to help you manage, troubleshoot and diagnose your Windows systems and applications. RamMap – list of application taken up RAM memory.

Unable to access database because it lacks a quorum of nodes for high availability try the operation again later

Issue: Unable to access database because it lacks a quorum of nodes for high availability try the operation again later. Fix: Restart failover cluster.

How do I flush the PRINT buffer in TSQL?

Example… Sources: https://stackoverflow.com/questions/306945/how-do-i-flush-the-print-buffer-in-tsql

Unable to Join Database to Availability Group

Issue: Unable to join restored database to Availability Group You can create an availability group using the New Availability Group wizard or using a series of transact-sql commands. A common failure can occur when attempting to create an availability group using either method. The error is as follows and is caused because the target primary... » read more

IIS was not able to access the web.config file for the Web site or application

Error: HTTP Error 500.30 – Internal Server Error IIS was not able to access the web.config file for the Web site or application. This can occur if the NTFS permissions are set incorrectly. IIS was not able to process configuration for the Web site or application. The authenticated user does not have permission to use... » read more

Windows Server Failover Cluster unavailable as Cluster Type

Issue: “Windows Server Failover Cluster” is not available as a Cluster Type option. Resolution: Make sure AlwaysOn has been setup on all nodes. Restart SQL Server services. If none of the above work, try to re-setup AlwaysOn. Remove node from AlwaysOn and then re-add node to AlwaysOn. Restart SQL Server services.

Look at Query for Process