Msg 15170: this login is the owner of 1 job(s) and cannot be dropped. Here is how to find those jobs and reassign them first.
SQL SERVER – Upgrade Failure – The Cluster Resource is Not Online. Bring the Analysis Services Server Online Before Starting the Upgrade Process
Upgrade and one need to evaluate them before making a final choice. Let us see an error related to Upgrade Failure. Let us learn today.
SQL SERVER – Previewing Old Azure Backup Blobs Before Removal with PowerShell
Backup Files From Azure Storage need a retention review before removal. I list the candidates before approving any cleanup.
How to Write Case Statement in WHERE Clause? – Interview Question of the Week #127
How to write CASE statement in WHERE clause? First, CASE is an expression, not a statement. Here is how to use it for optional search conditions.
Domain Controller – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved
SQL Server would not start under a domain account when a Read Only Domain Controller (RODC) was involved. Here is what fixed it.
SQL SERVER – How to Enable Lock Pages in Memory?
Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.
SQL SERVER – Msg 15137, Level 16 – Error Related to sp_xp_cmdshell_proxy_account
A client using a proxy account to run xp_cmdshell hit Msg 15137 with sp_xp_cmdshell_proxy_account. Here is what causes the error and how I fixed it.