One of my clients recently sent me an email with the following error. The error was visible in the error log and was about the database principal.
I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today.
Question: Can Admin Rename SA Account in SQL Server?
Answer: Yes, of course. The syntax for to rename SA account is very simple:
During the Comprehensive Database Performance Health Check, I do receive questions about pretty much anything like Public Database Role.
First thing first – the command DBCC FLUSHAUTHCACHE only is supported on SQL Azure. The behavior of change of password is a bit different on SQL Azure.