EugeneChiang.com

Knowledge is Power. Never Stop Learning. Seek the Truth.

.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress

Unable to download publish profile due to basic authentication disabled

Error: Unable to download publish profile because the basic authentication is disabled when you setup the web app. Fix: Enable basic authentication for FTP. In the app’s left menu, select Configuration > General settings. For SCM Basic Auth Publishing Credentials or FTP Basic Auth Publishing Credentials, select On, then select Save. Reference: https://learn.microsoft.com/en-us/azure/app-service/configure-basic-auth-disable?tabs=portal

0
Read
echiang
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

0
Read
echiang
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

0
Read
echiang
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.

0
Read
echiang
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

0
Read
echiang
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

0
Read
echiang
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 .

0
Read
echiang
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.

0
Read
echiang