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.
Setup Error 0x84CF0004: REBUILDDATABASE Permission Update Failed
Setup error 0x84CF0004 appeared when clients rebuilt system databases with SQL Setup. The log said the permission setting update failed for a job history file. Moving the JOBS folder aside and creating an empty one fixed it.
Plan Cache Memory by Cache Store: Where Plans Use Your RAM
Break down plan cache memory by cache store and object type, compare memory clerks, and investigate unused plans without cache clearing.
DevOps for DBAs: Build, Test, Release and Monitor
DevOps for DBAs means bringing development and operations together for the whole software lifecycle. Here is a simple definition, the four steps of the loop, and what they mean for SQL Server.
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.
When was Table Accessed Last By User? – Interview Question of the Week #226
When was a table accessed last by a user? When clients say a table is rarely used, I run this report to check before we create or drop indexes.
Setup Error 0x851A0012: REBUILDDATABASE Needs the sa Password
Setup error 0x851A0012 appeared while I helped a customer rebuild corrupted system databases after a hardware failure. The command had no SAPWD parameter, and the instance used SQL Authentication Mode. Adding SAPWD let setup finish.