- 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 …
Continue reading “How to set up mail notification for SQL Server job failures”
- SSIS Catalog MigrateInstall ‘ SSIS Catalog Migration Wizard ‘ from Visual Studio Marketplace Once Installation is done, we can find ‘SSIS Cataloger’ under ‘Tools’ menu Choose …
- 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 …
- 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 …
Continue reading “SQL SERVER How to deleting big volume of data from very huge table”
- 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 …
Continue reading “PowerShell : How to replace string in files”