- How to set up mail notification for SQL Server job failuresWhen we set up SQL Server Job, its is a very common requirement 'need to get email notification once Job is failed'. It's not … Read more
- SSIS Catalog MigrateInstall ' SSIS Catalog Migration Wizard ' from Visual Studio Marketplace Once Installation is done, we can find 'SSIS Cataloger' under 'Tools' menu Choose … Read more
- 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