Monthly Archives: December 2016

Creating the deployment would exceed the quota of 800 – Azure Error resolution

While performing multiple Azure operations from portal we get below error. This error occurs while performing multiple operations like creating elastic pool, moving a database to a new elastic pool, creating Secondary database, etc. Error: Error submitting the deployment request. … Continue reading

Posted in Azure, Uncategorized | Tagged , , | Leave a comment

Windows Server storage capacity and usage report using Powershell

Below Scrip generates list of all Drives and mount points configured, thery storage capacity and free space. Following Script to check the storage on a single server; If you want to calculate the storage to be added to maintain certain … Continue reading

Posted in Powershell, Productivity, Uncategorized, Windows Server | Tagged , , , , | Leave a comment

Generate SQL Query for Database Snapshot creation using Powershell

Following PowerShell script generates SQL Query to take a snapshot;

Posted in Powershell, Productivity, SQL, Uncategorized | Tagged , , , , | Leave a comment

Tip – Excel formula to convert Instance Name to Server Name

Below formula will give sub string preceding \

Posted in Script, Uncategorized | Tagged , , , , , | Leave a comment