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.
SQL SERVER – FIX: Msg 7416 – Access to the Remote Server is Denied Because No Login-mapping Exists
In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.
SQL SERVER – REBUILDDATABASE Error: 0x84CF0004 – While updating permission setting for folder The Permission Setting Update Failed for File
While updating the permission setting for the folder, the permission setting update failed for the file with the error REBUILDDATABASE.