Look into the following logs… Critical Events from Failover Cluster Manager Validate Cluster Report Windows Event Viewer Quick Action: Update SQL Server to Latest Patch. Reboot server on all nodes. Critical Events from Failover Cluster Manager Cluster -> Nodes -> Show Critical Events Validate Cluster Report Cluster -> Validate Cluster -> Run all test Windows... » read more
Issue: Unable to get AlwaysOn database back online. The local availability replica is not in a state that could process the command. Verify that the availability group is online and that the local availability replica is the primary replica, then retry the command. (Microsoft SQL Server, Error: 41190) Fix: Drop AlwaysOn and re-create it. Steps:... » read more
This is one of the common errors I have seen while working with customers who are using SQL Server AlwaysOn availability groups. Once this error comes, the resource in the cluster goes to failed state and in SQL Server Management Studio, we should be an availability group in resolving state. Resolving state essentially means that... » read more
Error: When using Git, getting the following error when trying to link to a Git repository… Fix: Open up command prompt and run The above should add the safe directory to the .gitconfig file Reference: https://stackoverflow.com/questions/72978485/git-submodule-update-failed-with-fatal-detected-dubious-ownership-in-reposit
Error: Getting the following error when trying to clone a project in TortoiseGit or Visual Studio… error: unable to create file xxxxxxx: Filename too long Fix: Location your .gitconfig file Open up the .gitconfig file and add “longpaths = true”
Issue: All – Visual Studio has an issue where it saves SQL files as UTF-8-BOM as default, which causes errors when concatenating for our DBAs. Please follow the attached instructions to install the “Fix File Encoding” Extension for Visual Studio. This will fix the issue by saving your SQL files as UTF-8 (without BOM) by... » read more
BitTorrent BitTorrent is a proprietary adware BitTorrent client developed by Bram Cohen and Rainberry, Inc. used for uploading and downloading files via the BitTorrent protocol. BitTorrent was the first client written for the protocol. It is often nicknamed Mainline by developers denoting its official origins. https://www.bittorrent.com/products/win/bittorrent-classic-compare/ Beware: Installing the free edition of BitTorrent application on... » read more
Press Windows logo key + Shift + S for a static image snip. https://support.microsoft.com/en-us/windows/use-snipping-tool-to-capture-screenshots-00246869-1843-655f-f220-97299b865f6b
Error: Msg 13545, Level 16, State 1, Line 14Truncate failed on table ‘tbXXXXX’ because it is not a supported operation on system-versioned tables. Resolution: Links: https://rajeevdotnet.blogspot.com/2019/05/truncate-system-version-table-temporal.html
Issue Unable to install SSRS 2022. Setup failed UnexpectedError: Bundle action failed: The system cannot locate the resource specified (0x800C0005) Setup: Install Completed for package Installing Microsoft .NET 4.8 Resolution Server does not have internet access. Unable to download and install supporting component Microsoft .NET 4.8. Download offline installer for “Microsoft .NET Framework 4.8 offline... » read more