We will look at how these two options can streamline things for users when they connect and change passwords. Let us discuss the login experience.
SQL SERVER – Fix Error – Cannot execute as the database principal because the principal “dbo” does not exist
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.Â
SQL SERVER – Change Password at the First Login
Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
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.Â
SQL SERVER – Query to List All Jobs with Owners
During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in their system with the Job’s owner.
Can Admin Rename SA Account in SQL Server? – Interview Question of the Week #256
Question: Can Admin Rename SA Account in SQL Server?
Answer: Yes, of course. The syntax for to rename SA account is very simple:
SQL SERVER – Security Risk of Public Role – Very Little
During the Comprehensive Database Performance Health Check, I do receive questions about pretty much anything like Public Database Role.Â