SQL Server 2016 added DROP IF EXISTS, but MySQL has had it for years. Here is how to drop table if exists in a MySQL database.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
What is a Self Join? Explain with Example – Interview Question of the Week #064
What is a Self Join? It is a popular interview question for every developer. Here is a simple answer, whether it is inner or outer, and a practical use.
SQL SERVER – Patch Upgrade – Failed to connect to server. Error: 0x80070422
A client’s SQL Server 2008 R2 SP2 patch failed, and the setup logs showed Failed to connect to server, Error: 0x80070422. Here is how we traced and fixed it.
MySQL – ELT() and FILED() Functions to Extract Index Position From List
MySQL’s ELT() returns the value at a given index position in a list, and FIELD() does the reverse. Here is how both functions work, with simple examples.
“I Don’t Know” – DBAs Should Learn to Use This Phrase – Notes from the Field #119
In Notes from the Field #119, Mike Walsh explains one of the most important things DBAs should learn: how and when to say ‘I don’t know’.
SQLAuthority Banner Journey: Five Looks in Ten Years
The SQLAuthority banner journey, told by the banners themselves: the first banner of a blog called Journey to SQL Authority, a green one with an MVP badge, a blue one with a cloud, a poll winner, and the 2016 banner that is still at the top.
SQL SERVER – Extended Events to watch for using ColumnStore Index
Profiler can’t show how ColumnStore indexes work, so a DBA friend asked which extended events to watch. Here are my notes on the events worth tracking.
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.