Generating realistic dates using SQL Data Generator and Python

How to generate more realistic dates, in your SQL Server test data. Read more

How to monitor backups and other SQL Agent jobs using SQL Monitor

How to monitor any SQL job that runs on the SQL Server Agent so that you're alerted quickly if SQL Agent goes offline, or if a job fails, or fails to start, or is running slow. Read more

Deploying schema changes to multiple databases using the SQL Compare command line

How do you push out the schema changes to ten copies of the database on ten different servers, as part of a deployment? Read more

Quickly rename variables all at once with SQL Prompt

Grant Fritchey demonstrates a quick and easy way to rename all variables in a SQL script. Read more

Troubleshooting a painful query using execution plans in SQL Monitor

How to use SQL Monitor to identify an unusual set of behaviors on the server, then narrow down the cause of the behaviors to a particular query. Within that query we have the starting point for tuning the query to get better performance. Read more

How to build multiple database versions from the same source: object filters

How to use filters in SQL Compare to avoid deploying objects that exist only in the source to databases where they may not be required or appropriate. Read more

How to version control a database using GitHub and SQL Source Control

This article explains some simple steps to create a GitHub database repository and then version control your SQL Server database, for team development work, using SQL Source Control. Read more

Using SQL Monitor with SCOM

This walkthrough shows how to configure SCOM so that it can consume alerts from SQL Monitor. Read more

Quick SQL Prompt tip – using the CDB snippet

SQL Prompt includes a number of snippets by default that can help you quickly write T-SQL code. These are templates of code that users use regularly. One of the more popular snippets is the ‘cdb’ snippet that helps with quickly creating a new database for development work. This can also be used to ensure production Read more

Integrating SQL Monitor alerts with other systems

One of SQL Monitor’s most valuable capabilities is raising alerts when bad things happen in SQL Server. The alerts are listed within SQL Monitor but can also be sent out as emails. However, many of our customers have said they’d like to see those alerts in their other systems too. The latest version of SQL Read more

Redgate Test Data Manager

Redgate Flyway

Redgate Monitor

Overview

Protect

Automate

Monitor

Product articles