Tag Archives: Redgate

Adding Test data to msdb.sysjobhistory

Posted on November 27, 2024 by way0utwest

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

Posted on November 20, 2024 by way0utwest

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

Posted on November 11, 2024 by way0utwest

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

Monday Monitor Tips: Projecting Disk Space

Posted on October 28, 2024 by way0utwest

One of the things that many DBAs struggle with is managing space across an estate. There might be one or two servers that you watch closely, or that are a constant problem, but it’s easy to run out of space … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Monday Monitor Tips: Projecting Disk Space