A retail team let non-sysadmin users run xp_cmdshell and got Msg 229: the EXECUTE permission was denied on the object. Here is the fix.
SQL SERVER – Error Installing Microsoft Visual Studio 2010 Shell
A Visual Studio 2010 Shell error during patching led to a missing cached package. This historical case shows why the exact package path matters.
SQL SERVER – Could Not Load the DLL xpstar.dll, or One of the DLLs it References
The xpstar.dll file existed, but a missing runtime component appeared during patch troubleshooting. Investigate the exact dependency and repair its package.
SQL SERVER – Edition Upgrade – Invoke or BeginInvoke Cannot be Called on a Control Until the Window Handle has Been Created
An old client met me at the airport with an edition upgrade error: Invoke or BeginInvoke cannot be called on a control. Here is the workaround.
SQL SERVER – SQL Audit Date Time Does Not Match Machine Date Time – Solution
A bank DBA noticed SQL Audit log times did not match the server clock. Here is why the audit time looks off and how to see it in local time.
SQL SERVER – Event ID 1045 – No Matching Network Interface Found for Resource ‘Cluster IP Address’ IP address ‘10.10.10.10’ (Return Code was ‘5035’)
A new node could not bring an AlwaysOn multi-subnet listener online, with Event ID 1045: no matching network interface found. Here is the cause and the fix.
SQL SERVER – My Thoughts – Autogrow of File ‘SQLAuth_Log’ in Database ‘SQLAuth’ was Cancelled by User or Timed Out After 30020 Milliseconds
Seeing ‘Autogrow of file was cancelled by user or timed out after 30020 milliseconds’ in the ERRORLOG? What it means, why it happens and what to do.