A reader still got Msg 35250 after my first post, with no mirroring login error in the ERRORLOG. Here are the endpoint and service account checks I asked for.
Finding User Objects in master Created by Accident
Find user objects in master, inspect their purpose and dependencies, and prepare a safe move without removing deliberate server helpers.
How to Count Week Days Between Two Dates? – Interview Question of the Week #132
How do you count Week Days between two dates in SQL Server? Here is a short script I built from scratch using spt_values and DATEPART.
Finding Which Network Protocol Each Session Uses
Before you switch off a protocol, find out who still uses it. Two short queries show how each session connected, and why the address is not a person.
SQL SERVER – Invalid Object Name ‘master.dbo.spt_values’ in Management Studio
A client ran U_tables.sql from the Install folder by hand and then hit Invalid Object Name ‘master.dbo.spt_values’ in Management Studio. Here is why.
SQL SERVER – Can I Delete Always On Availability Groups Initial Sync Folder?
Can you delete the shared folder used for the initial sync of Always On availability groups? A client asked, and yes, you can remove it without any impact.
SQL SERVER – Interesting Observation – Count of Temporary Table Re-generations
A workshop attendee asked how to know the count of temporary table re-generations for a single temp table. Here is how I find it.