- SQL SERVER How to deleting big volume of data from very huge tableIssue We one of very huge database which running out of server disk space. I was asked to remove millions of historical data from … Read more
- PowerShell : How to replace string in filesIssue How can we replace text in multiple files and folders quickly if folder name and file name are dynamically change. Solution Using PowerShell … Read more
- Why left join not returning nulls?Issue I am trying to get all products and category name if category is still active with below left join script. But I cannot … Read more
- SSIS Converting date to YYYYMMDDSSIS Expression format date to YYYYMMDD Mostly, when we create an auto file creation SSIS package we want to have timestamp in file name. … Read more
- Powershell copy or move files from multiple folder to another folderIn the daily data processing task, we always need to copy or move files from multiple source place to one destination folder. In this … Read more