SQL SERVER – Fix: 400 – Bad Request Authentication Failed for Account and the Provided Key. Please Provide a Valid Key and Try Again

While helping a client with Azure environment, I came across an interesting error. I this blog I would explain cause and fix of error “Authentication failed for account sqlauthprembackup and the provided key. Please provide a valid key and try again.”

Read More

SQL SERVER – Finding User Who Dropped Database Table

Though I mainly focus on SQL Server Performance Tuning as my primary consulting engagement, there are moments when I am asked questions from my regular clients which are not related to SQL Server Performance and they still expect me to answer. I think it is totally fair, no one wants to go to find a new consultant for some simple questions. Recently my customer wanted to know who dropped the database table from their primary database.

Read More

SQL SERVER – You Are Not Logged on as the Database Owner or System Administrator

Every day I spend a good amount of time with my regular and new clients, helping them with SQL Server Performance Tuning issues. Today, in this blog, I will discuss a situation faced where I was engaged in Comprehensive Database Performance Health Check. I saw below message on client’s SSMS while he was trying to create a table – You are not logged on as the database owner or system administrator.

Read More

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