Radius v0.42.0-rc1

What's Changed

## changelog

• change region to solve s3 issues by @nithyatsu in #8117
• revert region since the issues were intermittent by @nithyatsu in #8119
• release 0.41.0 by @nithyatsu in #8114
• Bump the all group across 1 directory with 13 updates by @dependabot in #8111
• Bump bicep-types from ba8eaca to c86fc24 by @dependabot in #8109
• Bump mikefarah/yq from 4.44.5 to 4.44.6 in the all group by @dependabot in #8110
• Bump golang.org/x/crypto from 0.25.0 to 0.31.0 in /test/magpiego in the go_modules group across 1 directory by @dependabot in #8123
• Remove CosmosDB database provider by @rynowak in #8116
• enable irsa on cicd by @nithyatsu in #8052
• Update Notification Condition for Scheduled Test Runs by @kachawla in #8115
• Bump golang.org/x/crypto from 0.28.0 to 0.31.0 in the go_modules group by @dependabot in #8124
• Changing permissions of UCP - removing unused permissions by @ytimocin in #8080
• Bump bicep-types from c86fc24 to 7c34fe6 by @dependabot in #8134
• Simplify database interface by @rynowak in #8126
• Bump aws-actions/configure-aws-credentials from 1.7.0 to 4.0.2 in the all group by @dependabot in #8136
• Bump the all group across 1 directory with 21 updates by @dependabot in #8142
• Rename database APIs by @rynowak in #8143
• Move database and similar packages to components by @rynowak in #8148
• Refactor and implement shared integration test host by @rynowak in #8112
• Remove ETCd database and secret store by @rynowak in #8158
• Add async operation support to dynamic-rp by @rynowak in #8161
• Bump the all group with 11 updates by @dependabot in #8167
• Bump bicep-types from 7c34fe6 to 3676a8b by @dependabot in #8168
• Move shared services and host to components by @rynowak in #8160
• Bump the all group with 2 updates by @dependabot in #8175
• Implement resource provider API for dynamic rp by @rynowak in #8177

Full Changelog: v0.41.0-rc1...v0.42.0-rc1