T-SQL Query to change Integration Services Catalog (SSISDB) database Master Key encryption password
Learn how to change the Master Key encryption password for an SQL Server Integration Services Catalog (SSISDB) database in SQL Server.
top of page
rajendra gupta
- Jan 28, 2022
- 1 min
SQL Server agent jobs without notification using T-SQL
This article will describe how to get a list of SQL Server agent jobs without notifications using T-SQL . Read more here
655 views0 comments
rajendra gupta
- Jan 27, 2022
- 1 min
Display dates between two input dates using SQL DATEDIFF function in SQL Server
SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he
2,539 views0 comments
rajendra gupta
- Jan 25, 2022
- 1 min
T-SQL query to change the job owners for all jobs owned by a specific login
Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about the underlying T-SQL scripts being run. This blog shows how to u
3,277 views0 comments
bottom of page