Your Agent Forgets Everything. I Measured What I Forgot to Write Down.
An agent session ends and the context is gone. Everything it learned about your environment, every approach it tried and discarded, every decision you talked through together, and whatever it was about to do next….
sql-login-syncer: Copy SQL Server Logins Without Losing SIDs or Passwords
The spent three posts building up to a practical conclusion: SQL Server maps database users to logins by SID, not by name, and any login you recreate from scratch gets a new SID. showed the…
Service Broker Queue Monitor
My previous post shows how to configure an Event Notification to fire whenever a login event occurs. The post uses Service Broker to receive those Event Notifications into a queue, which is then processed by…
Tool for scripting SQL Server Agent Jobs
I recently created an open-source tool that will create a T-SQL script file containing code to recreate whatever jobs you presently have in SQL Server Agent for any given SQL Instance, up to SQL Server…