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.
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.
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 – Stored Procedure sp_datatype_info to Get Supported Data Types
Forget which data types your SQL Server version supports? I run sp_datatype_info, which lists every supported type with precision, nullability and searchability.