Free Procedure Cache in SQL Azure Database

To free up the procedure cache on the SQL Azure database use the following ALTER DB Statement,

ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE;

This is same as running DBCC FREEPROCCACHE in the on-Premise SQL Instance.

SQL Azure:Powershell AzureRM Create a new database in a existing server

Below is a simple script with modification from the MSDN sample script below to create a SQL Azure database on an existing resouce group and existing SQL server in oppose to creating a new RG and server in the below example,

Copyright © 2018 Vinoth N Manoharan.The information provided in this post is provided "as is" with no implied warranties or guarantees.