SQL SERVER – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault

Along with my performance consulting, I also help many clients in fixing some quick issue. You can refer to various consulting services which I provide. This blog is an outcome of one such engagement where the has Azure Key vault and was not able to delete it. In this blog, we would learn about how to fix error Vault ‘Name’ cannot be deleted as there are existing resources within the vault.

Read More

SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting

One of my clients contacted me in a situation where their business was down! Their production SQL Server instance used by their Human Resource team was unable to start in a clustered environment. In this blog, we would learn about how to fix the error: 17300 – The error is printed in terse mode because there was an error during formatting received during SQL startup. (To save my client privacy, I have changed the name and location)

Read More

SQL SERVER – Script – Turn off Firewall Remotely (PowerShell, NetSh, PsExec)

I was working with a client to deploy an automated solution to install SQL Server. Since this involved scripting and running PowerShell remotely, we wanted to disable the firewall. Due to automation, we were not supposed to log in to the server and use UI. So, I search on the internet and found a few ways to do that. In this blog, I am going to share scripts which can turn off the firewall remotely.

Read More

PowerShell – Get Maximum Memory of Server with dbatools

Yesterday I blogged about the very famous Powershell free community tool dbatools. After writing this blog post, I received some interesting emails. I think lots of people confused this with native PowerShell. Well, actually dbatools is build using PowerShell scripts and runs under the hood script of PowerShell. The biggest advantage of the PowerShell is that it helps us to do multiple operations like finding the maximum memory of the server.

Read More