What is a ‘HASH INDEX’ in SQL? A Hash Index is a specific type of index that works best for equality comparisons. It uses a hash function to distribute rows evenly across a specified number of buckets. The hash function takes column values as input and returns a bucket number. When a query involving an... » read more
Recreating Always On from an existing setup using SSMS AlwaysOn Wizard. Note: Delete all database and database files on secondary servers. Make sure all drive and folder mapping are the same as primary server. Use Local drive or NAS drive for AlwaysOn backup file location. Make sure existing database backup jobs has been disabled. Might... » read more
.NET workload wasm-tools .NET wordload wasm-tools-net6 Visual Studio -> Tools -> Command Line -> Developer Command Prompt Example: ********************************************************************** ** Visual Studio 2022 Developer Command Prompt v17.9.6 ** Copyright (c) 2022 Microsoft Corporation ********************************************************************** C:\Users\xxxxx\source\repos>dotnet workload list Installed Workload Id Manifest Version Installation Source --------------------------------------------------------------------- maui-windows 8.0.7/8.0.100 VS 17.9.34728.123 maccatalyst 17.2.8004/8.0.100 VS 17.9.34728.123 ios 17.2.8004/8.0.100... » read more
Note: Make sure all the drive and folders are setup correctly. Make sure you select “Full” backup files and/or “Diff” backup files and that those files appear in the Backup sets to restore list. Make sure you have all the log files selected. The backup files can be read from a network folder (\\xxxxx\xxxxxx) or... » read more
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
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.
Error: Cannot delete rows from a temporal history table xxxxxxx Fix: Reference: https://stackoverflow.com/questions/53746197/cannot-delete-rows-from-a-temporal-history-table
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
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
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