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.
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.
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 – REBUILDDATABASE Error: 0x84CF0004 – While updating permission setting for folder The Permission Setting Update Failed for File
While updating the permission setting for the folder, the permission setting update failed for the file with the error REBUILDDATABASE.
SQL SERVER – The Future of DevOps for DBA
Unless you live under a rock, you have heard the word DevOps. Here I define it simply and share my thoughts on the future of DevOps for the DBA.
Every Second Item Free: Pricing Promotions With ROW_NUMBER
Price every second item as free with ROW_NUMBER, expand quantities into units, and calculate basket discounts without double counting.
SQL SERVER – REBUILDDATABASE Error: 0x851A0012 – Missing sa Account Password. The sa Account Password is Required for SQL Authentication Mode
The plan was to first rebuild system databases and then restore ALL databases from the backup. Today we will discuss an error about REBUILDDATABASE.