Configuring dBMail involves 3 main steps Step 1: Creating Mail Profile Step2: Creating Mail Account Step3: Mapping Account to Profile. Below
There might be times for audit to list all the service accounts from all SQL Servers, In order get this
You will see how much is powershell is useful for DBA after using this script. Step 1: Create a text
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.