In this blog we would learn how to fix Msg 4353 – Conflicting file relocations have been specified for the file. We solve this error very quickly.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Maximize Execution Plan Space in SSMS With Two Settings
To maximize execution plan space in SSMS, send the results to their own tab and switch to full screen mode. This post lists the two settings, the shortcuts that go with them and the zoom controls for a large plan on a small screen.
Page and Row Compression in SQL Server: Estimate, Enable, Remove
Page and row compression shrink a table or index, and each one is a single ALTER statement. This post estimates the savings first, turns each level on and off in a demo, and measures what the page rebuild costs in CPU.
SQL SERVER – Difference Between Login Vs User – Security Concepts
In this blog post, we discuss the difference between Login Vs User – Security Concepts. They look the same but actually, they are totally different.
SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)
I recently had a very simple and interesting error received while I was performing an upgrade mode with Docker and Persistence Storage for my upcoming workshop.
When Was SQL Server Last Restarted? – Interview Question of the Week #225
When was SQL Server last restarted? It is my first question in every Health Check, because a restart empties the DMVs and their performance history.
Docker Run Without Pull: Start SQL Server in One Command
Docker run without pull works because docker run downloads the image when it is not on your machine. This post shows how to check which images you already have and how the pull option changes the behavior. It also explains when an explicit pull is the better habit.
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.