Should the SQL Server Service Account be a local or domain admin? No. Best practices from a client Q&A on service accounts, permissions and passwords.
When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093
Error 1069, logon failure, often means the service account password changed in the domain. Here is how to find when a Domain Account Password was last changed.
SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065
Who changed the password of your SQL Login? It is a real world question every DBA faces one day. Bookmark this post, here is how to find the answer.
Contained Database Users: Logins That Move With the Database
Use contained database users to move authentication with a database, inspect prerequisites, test connections, and review access ownership.
Renaming or Disabling the sa Login
Renaming or disabling the sa login requires a dependency inventory, tested alternate admin access, and monitoring after the change.