Running Cluster Validation cause drives to disappear and go offline

When running a validation test on a Windows Failover Cluster, drives may disappear from the cluster and file explorer if the cluster is hosting an Availability Group with iSCSI-backed disks.  When you choose the default options in Validation – any storage that could be possibly shared storage is taken offline and brought into the cluster’s available... » read more

Troubleshoot SQL Server AlwaysOn Failures

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

Fix AlwaysOn by Recreating AlwaysOn

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

git: fatal: detected dubious ownership in repository

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

TortoiseGit Error: Filename too long

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”

UTF-8 Encoding Issue in Visual Studio

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

Download Large File with BitTorrent Client

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

Screen Capture on Windows

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

Truncate table for system versioned table

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