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 Redgate 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

Troubleshooting a painful query using execution plans in Redgate Monitor

How to use Redgate 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 Redgate Monitor with SCOM

This walkthrough shows how to configure SCOM so that it can consume alerts from Redgate 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

Generating test data with localized addresses using SQL Data Generator

With basic grasp of regex expressions, a tool like SQL Data Generator can generate test data with addresses that are realistic for your part of the world. Read more

Comparing SQL Server Databases using DacPacs and SQL Compare

How to compare SQL databases using DACPACs, script out differences and then run a database deployment task to synchronize the schema of the target database. Read more