I wanted to move some of the reporting workload to the secondary replica but the following things stopped me:
- no writes can be performed (including creating temporary tables);
- a license is required;
I guess I might get it wrong... I've checked the docs again and it is said that:
Though you cannot write data to secondary databases, you can write to read-write databases on the server instance that hosts the secondary replica, including user databases and system databases such as tempdb.
which basically means I can execute every reporting query.
But I am not able to find any information about the licensing in the docs. Is the licensing requirement off, now?