Monday 30 July 2018

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.

Thursday 22 February 2018

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.