- How To Get Day Of Week In SQL Server?SQL Server has a couple of inbuilt functions to get the day of week from the given date. To get the name of the … Read more
- 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