Import database when policy “Azure SQL DB should avoid using GRS backup” is enforced

Symptoms:
Creating or importing database failed due to violation of policy “Azure SQL DB should avoid using GRS backup”
When creating database, you should specify the backup storage to be used, while the default is GRS (Globally redundant storage) and… Continue reading Import database when policy “Azure SQL DB should avoid using GRS backup” is enforced

Enhance performance techniques:use index on computed column

 
I want to share the following example in how you can use the “computed column” in some cases, to enhance your queries performance.
 
On AdventureWorks 2019 sample database, there are two tables TransactionHistory  and TransactionHistor… Continue reading Enhance performance techniques:use index on computed column