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

Cannot use file because it was originally formatted with sector size 4096 and is now on a volume with sector size 8192

Error: Error details:Error installing SQL Server Database Engine Services Instance FeaturesCould not find the Database Engine startup handle.Error code: 0x851A0019 Getting the following error in Event Viewer when trying to install SQL Server… Cannot use file ‘D:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\mastlog.ldf’ because it was originally formatted with sector size 4096 and is now on a volume... » read more

0
Read
echiang
Could not find the Database Engine startup handle

Error: TITLE: Microsoft SQL Server 2022 Setup —————————— The following error has occurred: Could not find the Database Engine startup handle. For help, click: https://go.microsoft.com/fwlink?LinkID=2209051&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1000.6&EvtType=0xD15B4EB2%25400x4BDAF9BA%25401306%254025 Issue: Unable to start SQL services. Check Windows “Event Viewer” for errors. Event Viewer Log: Cannot use file ‘D:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\master.mdf’ because it was originally formatted with sector size... » read more

0
Read
echiang
Take Care When Scripting Batches for Long Running Query

Source: https://michaeljswart.com/2014/09/take-care-when-scripting-batches/ The Straight Query Suppose we want to remove sales data from FactOnlineSales for the “Worcester Company” whose CustomerKey = 19036. That’s a simple delete statement: DELETE FactOnlineSales WHERE CustomerKey = 19036; This delete statement runs an unacceptably long time. It scans the clustered index and performs 46,650 logical reads and I’m worried about concurrency issues. Naive... » read more

0
Read
echiang
SQLCMD mode in SSMS

SQLCMD mode is a script execution mode that simulates the sqlcmd.exe environment and therefore accepts some commands that are not part of T-SQL language. Just enable SQLCMD mode in SSMS (Query menu -> SQLCMD Mode) and the query will run fine. SSMS can also be configured to automatically enable SQLCMD mode in Tools menu -> Options... » read more

0
Read
echiang
PowerShell to move specific files after x days

Explanation: Set the directories: Replace "C:\SourceDirectory" and "C:\DestinationDirectory" with the actual source and destination paths. Set file types: Replace ` “.txt”, “.log”` with the desired file extensions. Set the number of days: Modify $days to specify the age threshold for moving files. Get the current date: The script calculates the cutoff date by subtracting the specified number of days from the current date. Get the... » read more

0
Read
echiang
Blazor JavaScript interoperability function not found

Issue: Getting the following error when adding new JavaScript function to Blazor WebAssembly app… Unhandled exception rendering component: Could not find 'xxxxx' ('xxxxx' was undefined).Error: Could not find 'xxxxx' ('xxxxx' was undefined). Fix: If you are running into new function not found issue, make sure you are not using a cache version of index.html by... » read more

0
Read
echiang
How do I call a JavaScript method with parameters in Blazor WebAssembly?

https://www.syncfusion.com/faq/blazor/javascript-interop/how-do-i-call-a-javascript-method-with-parameters-in-blazor-webassembly https://learn.microsoft.com/en-us/aspnet/core/blazor/javascript-interoperability/?view=aspnetcore-8.0 Note: If you are running into function not found issue, make sure you are not using a cache version of index.html by pressing the Ctrl + F5 to refresh index.html. [Index.razor] [index.html]

0
Read
echiang
The redirect URI specified in the request does not match the redirect URIs configured for the application

Error: AADSTS50011: The redirect URI ‘https://xxxxxxxxxxx/authentication/login-callback’ specified in the request does not match the redirect URIs configured for the application ‘xxxxxxxx’. 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 how to fix this. Fix: Got to entra.microsoft.com... » read more

0
Read
echiang