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
https://serverfault.com/questions/31554/how-to-check-progress-of-dbcc-shrinkfile
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
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]
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
Error: 4861: Cannot bulk load because the file could not be opened. Operating system error code 1326 (The user name or password is incorrect.). Fix: This error message “Cannot bulk load because the file could not be opened. Operating system error code 1326 (The user name or password is incorrect.)” means that your SQL Server is... » read more
https://stackoverflow.com/questions/30597429/how-to-clear-cache-of-1-stored-procedure-in-sql-server
Issue: Certain SQL Server job get stuck and unable to finish. When run manually, the code finish running, but when it runs via SQL Server Agent, it never finishes. Fix: Restart SQL Server.
Issue: Getting the following when trying to shrink the database. Error: Could not adjust the space allocation for file ‘xxxxxxxxx’.Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. (Microsoft SQL Server, Error:... » read more
https://pragmaticworks.com/blog/table-partitioning-in-sql-server-partition-switching Partition switching moves entire partitions between tables almost instantly. It is extremely fast because it is a metadata-only operation that updates the location of the data, no data is physically moved. New data can be loaded to separate tables and then switched in, old data can be switched out to separate tables and then archived or purged.... » read more