In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT: How to Check It Is On
MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT is a database option, so DBCC USEROPTIONS never shows it. This post reads the option from sys.databases and from DATABASEPROPERTYEX, turns it on in a demo database and finds every database that has it. It also shows a guarded script you can reuse in deployments.
Indexes and SELECT Queries: A Coffee Mug, Tested
Indexes and SELECT queries met on a coffee mug from my friend Harvey Powell. Its two sides say indexes slow down SELECT queries and to drop unused indexes. The tests here show when a forced index reads 46 times more pages, what the usage counters report for an unused index, and why zero reads did not mean zero purpose.
SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries
An index can reduce the Performance of SELECT Queries when it changes a particular plan unfavorably. Readers asked three follow-up questions.
SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted
In this blog we would talk about fixing error 15274 – Access to the remote server is denied because the current security context is not trusted.
How to List All Memory Optimized Tables in SQL Server? – Interview Question of the Week #227
Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
Error 5173 in SQL Server: One or More Files Do Not Match the Primary File of the Database
Error 5173 in SQL Server means a database file does not belong to the primary file of its database. I reproduced it twice on SQL Server 2025, once at attach and once at startup, and show the log messages, the checks to run and the fix for a user database and for msdb.
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.