This procedure will help you to automation of link server failure status check with help of SQL agent job scheduling. Job query :-
exec proc_check_linked_servers 'profiler name','E-mail ID'
2018-02-07 (first published: 2018-01-30)
756 reads
2018-01-26 (first published: 2018-01-18)
12,176 reads
During a database migration or a side by side database upgrade project we need to migrate the MS SQL Server Agent jobs. This script compare jobs by names and shows unmatched jobs.
2018-01-25 (first published: 2018-01-20)
3,369 reads
How to insert data into a SQL Server Table using Powershell using Invoke-SQLcmd Commandlet
2018-01-24 (first published: 2018-01-11)
30,921 reads
Often we need to know on which stage is a maintenance operation such as: backup, restore, check database. You can get this information using my script.
2018-01-17 (first published: 2018-01-12)
616 reads
Show the difference between two dates (from, to) in format #d HH: MM: SS
2018-01-03 (first published: 2017-12-18)
490 reads
Powershell utility for
generating scripts for db tables with / without identity columns.It can also produce scripts for fixed number of rows
2018-01-02 (first published: 2017-12-18)
1,140 reads
2017-12-29 (first published: 2017-12-27)
1,643 reads
This script capture INSERTs / UPDATEs / DELETEs on SQL Server table and logs to single table in JSON Format.
2017-12-22 (first published: 2017-12-01)
2,892 reads
Here is a script that can give the DBA a SQL Instance quick quality check.
2017-12-21 (first published: 2015-01-02)
7,048 reads
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Not sure if this is a tech mistake I've made or a lack of...
Several times now, I've seen a post asking for a solution. I've replied, and...
Comments posted to this topic are about the item Data > Hype
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers