DevOps Visual Studio 2022 Local/Remote Branch code setup

Get Latest from Main Branch In “Git Changes” window, go to Local -> main branch Do a “Pull” to get latest changes from main branch. Switch and select Local -> user branch Hover over “main” branch, right click and select “Merge into Current Branch” Push Changes to Main Branch In “Git Changes” window, “Commit” all... » read more

Can’t determine project language from files

Error: Getting the following error when trying to run a project from Visual Studio… Can't determine project language from files Solutions: Might be missing local.settings.json file from the project folder. Copy the file from the original project. References: https://github.com/Azure/azure-functions-core-tools/issues/2050

How to Delete hiberfil.sys on Windows 10

How to Delete hiberfil.sys on Windows 10 Select Search. Enter command. … Right-click Command Prompt and select Run as Administrator. … Select Yes if a User Account Control window appears requesting permission to continue. … Type powercfg.exe /hibernate off into the Command Prompt window and press Enter.

Search of Large Files on Disk Drive

Option 1: Folder Explorer Go to folder explorer and type in … in the search box size:huge Option 2: TreeSize Free app https://www.jam-software.com/treesize?&cp=ProductAds&cp_kwd=TSfree_TSpro Note on Removing Files: hiberfile.sys ok to delete pagefe.sys should NOT be deleted .ost outlook files should NOT be deleted Although hiberfil. sys is a hidden and protected system file, you can safely... » read more

Upgrade availability group replicas

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-ver16 When upgrading a SQL Server instance that hosts an Always On availability group (AG) to a new SQL Server version, to a new SQL Server service pack or cumulative update, or when installing to a new Windows service pack or cumulative update, you can reduce downtime for the primary replica to only a single... » read more

Check Current Windows Version

To find out which version of Windows your device is running, press the Windows logo key  key + R, type winver in the Open box, and then select OK. Select the Start  button > Settings  > System  > About .

Things to Avoid in Your Query

LIKE ‘%xxxxxx%’ https://www.brentozar.com/archive/2010/06/sargable-why-string-is-slow/ Table Valued Functions https://www.brentozar.com/blitzcache/tvf-join/ Functions in from/below Implicit Conversions (convert to different data type) Comparing the contents of 2 columns on 1 table Table Variables Table variable does not have stats and serial for updates.