Automate creation of test databases on Azure SQL with Active Directory security groups
For database testing it is customary to make periodic copies of the production database and use the latest copy as a test database. But how does that work in a scenario where you use Azure SQL and a traditional Active Directory instance? And on top of that you obviously want to automate that process! Steps Steps involved: Create an Automation Account. Give the automation account the right permissions. Make the automation account administrator on the SQL server....