HOW TO VERIFY IF A BACKUP FILE IS CORRUPTED?
There are times when we do a backup as a DBA, we come across problems when we restore the backup
–DB Blog
There are times when we do a backup as a DBA, we come across problems when we restore the backup
There are times a DBA gets a request to see the user account got locked or the user is unable
There are many ways to transfer logins between instances under the same domain like 1. Scripting out logins 2. Logins
Using STUFF function in sql serevr a column values can be retrieved as single value row, values seperated by comma’s.
Today I was messing with the SQL Server root folder in program files in looking for tablediff .exe utility that
I have been asked several times to delete multiple logins in a day in my environment then initially I was
Would you ever asked to find all administrators with sysadmin access in your server then there is a very symple
This script is very useful when you have large tables and queries against those table usually runs slow then you
Track DML Changes Using after Trigger for Update, Delete and Insert rows There is out lot many options to track
I was asked to list the Primary keys in our databases then I listed using the below script. This is very