Tag Archives: Redgate

Monday Monitor Tips: Am I Patched?

One of the things that I think is neat is that Redgate Monitor helps you track patching on your systems. This is something that has been challenging in every position I’ve had, with some systems being forgotten or remaining unpatched … Continue reading

Posted in Blog | Tagged , , | Comments Off on Monday Monitor Tips: Am I Patched?

Adding Test data to msdb.sysjobhistory

One of our internal people was looking to test some process in (I assume) Redgate Monitor and needed more job history than they had in msdb.sysjobhistory. They wanted to use SQL Data Generator to help, but couldn’t make it work. … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Adding Test data to msdb.sysjobhistory

Using SQL Compare with Read-only Access

Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some tools that create temp tables or do some other work in … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Using SQL Compare with Read-only Access

Monday Monitor Tips: Tracking The Cost of Instances

One of the things that I’ve been asked in every operations situation is what licenses do we need for our servers. This is a rare request, often once a year, but it results in a bunch of work to figure … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Monday Monitor Tips: Tracking The Cost of Instances