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

Restore Database from full, differential, and log backup files.

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-differential-database-backup-sql-server?view=sql-server-ver16 RESTORE WITH NORECOVERY which leaves the database non-operational, and does not roll back the uncommitted transactions. Additional transaction logs can be restored. The database cannot be used until it is recovered. Examples (Transact-SQL) A. Restoring a differential database backup This example restores a database and differential database backup of the MyAdvWorks database. B. Restoring a database, differential... » read more

0
Read
echiang
Setup Email Subscription for SSRS

To setup email for SSRS subscription, go to Report Server Configuration Manager. Go to the E-mail Settings and fill in the SMTP Settings fields. Sender Address: me@mydomain.com Current SMTP Delivery Method: Use SMTP server SMTP Server: smtp.mydomain.com Authentication: No authentication Note: Make sure to restart the SSRS service after making modifications to these fields.

0
Read
echiang
Visual Studio Unload Project From Solution

In Visual Studio, you can “Unload” project from a solution. It can be useful to unload a project from a solution while resolving circular dependencies between projects or conflicts with different versions of the .NET framework between projects. In Visual Studio, the “Unload Project” option allows you to temporarily remove a project from the solution... » read more

0
Read
echiang
Web App Login with Microsoft Entra Error: Redirect URI does not match

Error: Sorry, but we’re having trouble signing you in. AADSTS50011: The redirect URI 'https://app01.domain.com/authentication/login-callback' specified in the request does not match the redirect URIs configured for the application 'xxxxxxxxxx'. Make sure the redirect URI sent in the request matches one added to your application in the Azure portal. Navigate to https://aka.ms/redirectUriMismatchError to learn more about... » read more

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