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.
SQL SERVER – Getting Started with DBCC FLUSHAUTHCACHE on SQL Azure
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.