Hi All, Today I am sharing a situation which we have faced issue in which maintenance tasks on Vault SQL server kind of hung. We had waited for hours but it was still running, We generally run these tasks by setting the application to read-only mode. I had contacted my SQL friend to assist me…
Hi Readers, I have been given a below task which needs to be done due to some security issue:- Critical APP send invoice(pdf) to mailbox User than reads the email address of vendor from body After that fwd that email to Vendor. This manual process needs to be automated. below is the screen shot on…
Hi All, Today I am sharing a method that We can use –> connect Excel to SQl server database. Steps to follow:- 1. open excel 2. From data Tab select –>From other Sources –>From SQL server 3. Enter server Name & authentication mechanism 4. Select database & then select the table 5. Click finish 6. click…
Hi All, Today I am sharing my old script that I had used for updating the group members from CSV file. I was performing the same activity today so thought of sharing it. You just have to Prepare CSV as below:- after that just define group name inside the script. ############################# $grp = ##############################…
Hi All, Today I am sharing a powershell method for exporting the content of SQL Table to CSV file. This can be used from remote server or machine as well if you have sql powershell installed. Download & install sql management tools from MS site on your admin server. This will install management studio as…
Tech Wizard 