In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.
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.