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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
How to Find SQL Server Memory Use by Database and Objects? – Interview Question of the Week #121
Which database uses the most buffer pool? Queries on sys.dm_os_buffer_descriptors to find SQL Server Memory use by database and by object.
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.
SQL SERVER – Maintenance Plan – Backup Files Not Getting Deleted
A client’s maintenance plan ran fine, but old backup files were never deleted. The answer was in the documentation. Here is what to check.
SQL Azure Database – Msg 40197, Level 20 – The Service has Encountered an Error Processing Your Request. Please Try Again. Error Code 40549
A bulk insert from Azure Blob Storage failed hours in with Msg 40197, error processing your request, code 40549. Why long transactions get killed, and the fix.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.