Video

PASS Marathon – Not Just for Europe The Global Impact of GDPR – Session 4

In this session you’ll learn how the GDPR impacts businesses across the globe, and how you can use the guidelines it sets out to not …

Video

Fritchey’s 5 Minute Video – GDPR and the Data Protection Impact Assessment

As you begin to deal with the GDPR, the Data Protection Impact Assessment is going to be a process that you go through again and again.…

Video

Fritchey’s 5 Minute Video – Why Your Customers Care About the GDPR

Your customers might not even know what the GDPR is, but they care about their data, its privacy and protection.

Video

Fritchey’s 5 Minute Video – Why Should DBA’s Care About the GDPR

GDPR is a business problem right? Yes, but it requires quite a bit from your area of expertise. Watch this video to understand more.

Video

How the GDPR will impact your software delivery processes

In this webinar, you'll learn the principles of data protection and what these mean for IT teams, and steps to consider to ensure compl…

Video

SiTC 2018 – Create, Protect and Manage Databases for Compliant DevOps by Steve Jones

In this session Microsoft Data Platform MVP Steve Jones will cover data compliance in software delivery and explain that by applying De…

Video

SiTC 2018 – Keynote: Not Just for Europe: The Global Impact of the GDPR

In this session you’ll learn how the GDPR impacts businesses across the globe, and how you can use the guidelines it sets out to not …

Documentation

SQL Clone Top 21 FAQs

Check out our top 21 FAQ's for installing, creating, managing and working with SQL Clone.

Video

How to create a database clone

SQL Clone provisions database copies in seconds using MB of storage. Once you've prepared your database image, you can start creating m…

Video

SQL Provision Demo

Watch how SQL Provision use the virtualization technology in SQL Clone and masking technology in data masker to distribute sanitized da…

Documentation

Creating a clone from an image

Once you have prepared your image you can create multiple clones. Run through how to create multiple clones from a single image.

Documentation

How to create an image from database backups

A walk through of how to create an image from database backups using SQL Clone

Documentation

How to create an image from a SQL Server database

A walk through of how to create an image from a live SQL server database using SQL Clone

Documentation

Getting started with SQL Clone

A quick overview of how to get started with SQL Clone. Understand the core components and understand more about the architecture of the…

Documentation

What is SQL Clone?

A high level overview of what SQL Clone is, and what it means for database provisioning.

Documentation

Key problems SQL Clone solves

We look at the key problems SQL Clone solves for operational teams, development teams, and the business.

Video

How to create an Image from a database using SQL Clone

This video walks through how to create an image from a SQL Server database, ready for cloning.

Video

How to create an Image from a database backup using SQL Clone

This video walks through how to create an image from a database backup, ready for cloning.

Video

Installing SQL Clone

The video runs through how to install the SQL Clone components to get started.

Video

SQL Change Automation & VSTS: 10 tips and tricks for database migrations – Part 1

Redgate's David Simner, Jon Hickford and Microsoft MVP Steve Jones present 10 tips and tricks for database migrations using SQL Change …

Documentation

SQL Clone Architecture and Requirements

This guide covers the architecture of SQL Clone and product requirements before you install the tool.

Documentation

SQL Clone Installation Guide

This Installation Guide tells you exactly what you need to know to get SQL Clone Installed and set up.

Documentation

SQL Prompt Functionality Finder

This handy reference guide summarizes all great SQL Prompt functionalities and where to find them so you can make the most of the tool.

Case study

Monitoring large SQL Server estates to drive business growth at scale

German IT service provider, Fiducia & GAD IT AG, provides the systems that power 36,000 ATMs and over 80 million bank accounts in Germa…

Documentation

SQL Prompt Treasure Island

It is sometimes best to think of SQL Prompt as if it were a Treasure Island. You tend to come across the good things by setting out to …

Documentation

SQL Prompt Frequently Asked Questions (FAQ)

Check out the Frequently Asked Questions (FAQ) on SQL Prompt for answers to a range of common questions.

Documentation

Data Masker Tech Tips

This Tech Tip is designed to help you get started with Data Masker including the creation of your first set of masking rules.

Documentation

SQL Clone IT Strategy document

A business document describing the impact of SQL Clone on IT processes relating to software delivery.

Case study

Introducing true team development with SQL Toolbelt Essentials

Find out how introducing SQL Toolbelt Essentials has enabled Paul and his team at Hays Travel to resolve every deployment issue they we…

Blog post

Questions about Data Masking That You Were Too Shy to Ask

The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organi…

Blog post

Personal Data, Privacy, and the GDPR

Now that there have been well-publicised examples of the awful consequences of data breaches and data misuse, there is increasing publi…

Case study

A day in the life of a developer using SQL Prompt

Learn how SQL developer Alice benefits from using SQL Prompt throughout her working day.

Super SQL Tips

Tip #23: How to use code analysis in SQL Prompt

In this Super SQL Tip Redgater Jamie Wallis explains how you can get suggestions to improve as you type with new code analysis rules in…

Documentation

SQL Prompt guide to Templates and Snippets in SSMS

This handy quick reference guide shows you how snippets in SQL Prompt add versatility and flexibility to standard templates and snippet…

Documentation

System Requirements – Data Masker for Oracle

The hardware and software system requirements for Data Masker for Oracle.

Documentation

System Requirements – Data Masker for SQL Server

The hardware and software system requirements for Data Masker for SQL Server.

Whitepaper

Data masking for HIPAA compliance

This paper is focused on the practical issues and techniques involved in the preparation of de-identified HIPAA compliant databases.

Whitepaper

Data masking – What you really need to know before you begin

This paper provides a survey of the practical issues involved in the masking of sensitive data and tells you the things you really need…

Documentation

Data Masker Frequently Asked Questions (FAQ)

Check out the Frequently Asked Questions (FAQ) on Data Masker for answers to a range of common questions.

Video

How to examine differences with SQL Compare Summary View and SQL View

In this short video Data Platform MVP Steve Jones demonstrates how you can use the updated SQL View and the new Summary View in SQL Com…

Video

How to generate a comparison report with SQL Compare

In this quick how-to video, SQL Compare Tech Lead Tugberk Ugurlu shows you how easy it is to generate comparison reports in HTML format…

Super SQL Tips

Tip #22: How to control code completion suggestions in SQL Prompt

In this Super SQL Tip Redgater Jamie Wallis explains how you can easily customize your code completion suggestions to pop-up less frequ…

Video

How to copy the structure of a database using SQL Compare

In this quick how-to video Data Platform MVP Grant Fritchey shows you how easy it is to copy the structure of an existing database to c…

Video

How to create a Snapshot with SQL Compare

In this quick how-to video Data Platform MVP Grant Fritchey shows you how easy it is to create and use a snapshot with SQL Compare.

Video

How to map and unmap tables and columns with SQL Compare

In this quick how-to video Data Platform MVP Grant Fritchey shows you how easy it is to map and unmap tables and columns using SQL Comp…

How to guide

Database backup, restore, and verification

This walkthrough covers scheduling your backup and restore jobs using the new wizards in SQL Backup 7.

How to guide

Log shipping with SQL Backup

This walkthrough will show you how to set up log shipping in two minutes and how to monitor log shipping with the timeline

How to guide

Backing up a database

This walkthrough of SQL Backup Pro will show you how to take a compressed, encrypted backup of a Microsoft SQL Server database

Case study

“SQL Backup Pro’s ease of use and reliability save us around 30 person-hours a week”

Find out how other companies have been using SQL Backup Pro to simplify their SQL Server backup and restore schedules.

Whitepaper

Bulletproof your database backup and recovery strategy

See how to beat the most common holes in SQL Server backup and recovery strategies. Read it to ensure that you can recover any database…

Whitepaper

Handling a full SQL Server transaction log

This whitepaper shows you how best to manage the transaction log, reviews the dangers of common advice from community sites and forums,…

Video

Prepare for when disaster strikes

Steve Jones and Grant Fritchey discuss how to protect your data, and your business, covering hardware problems, how to reduce response …

Video

Verify your backups – NOW!

Grant Fritchey explains why you need to verify and restore your SQL Server backups regularly, to avoid being hit by data corruption whe…

How to guide

Object Level Recovery

This walkthrough will show you how to work with OLR to recover objects from SQL Backup .sqb files.

Article

How to convince your boss you need SQL Server monitoring

How much will it cost and what are the benefits to your business? We take a look at the costs and benefits involved in using a SQL Serv…

Video

SQL Compare in 30 seconds

Watch how quickly it is to use SQL Compare to compare & deploy SQL Server database schemas, find and fix errors, and create deployment …

Article

Is SQL Server killing your .NET application performance?

When a .NET application suffers from performance problems, it's common to assume the database is at fault. Ben Emmett examines why this…

Case study

Monitoring more servers, more closely, with SQL Monitor

Managed IT services provider Claranet, switched to SQL Monitor to cover their large SQL Server estate when they were having issues with…

Article

Using baselines and custom metrics in SQL Monitor

SQL Monitor Technical Author Anne Edwards explains how to check baselines for SQL Server performance metrics, and how to set up a new c…

Super SQL Tips

Tip #21: Create your style using the new formatting options in SQL Prompt

In this Super SQL Tip Software Engineer Andrei Rusitoru explains the fantastic new formatting options available in SQL Prompt 8 from Re…

Top 20 Toolbelt Tips

Tom Austin shares his top 20 tips for improving productivity, effectiveness and consistency across your development team with the help …

eBook

The Redgate Guide to Working with a Personal Assistant

by Lottie Mackintosh A truly effective assistant knows their manager’s priorities, concerns and responsibilities as well as they do themselves. They know how to...

Video

Using SQL Compare with Row Level Security (RLS)

Row Level Security (RLS) is one of many new features in SQL Server 2016. It provides an easier, consistent, and maintainable solution f…

Video

Using SQL Compare with Dynamic Data Masking (DDM)

Dynamic Data Masking (DDM) is an exciting new feature in SQL Server 2016 that means you can centrally set a mask that's returned for a …

Video

Using SQL Compare with In-Memory OLTP tables

If you’ve decided to implement In-Memory OLTP tables, Redgate SQL Compare is ready to safely handle your database changes.

Video

Success stories with SQL Compare

Chris Yates, Serge Krasnay, Lindsay Clark, Arthur Daniels, Nick Fry, and Tjay Belt explain how useful they find SQL Compare every day, …

Video

Compare and synchronize SQL Server schemas with SQL Compare

An introduction to SQL Compare from Redgate, the industry's most trusted SQL Server comparison and synchronization tool.

Super SQL Tips

Welcome to Super SQL Tips

In this series of short videos Data Platform MVPs and SQL Server experts share their tips for getting the most out of SQL Prompt. We ar…

Super SQL Tips

Tip #20: Know which environment you are working in with Tab Coloring

In this Super SQL Tip Data Platform MVP Grant Fritchey explains how to use SQL Prompt to color your tabs so you always know which envir…

Video

SQL Clone 60-second intro

New Redgate SQL Clone enables rapid SQL Server provisioning while making efficient use of disk space.

Video

SQL Clone demo video

A short introduction to SQL Clone, Redgate's tool for cloning SQL Server databases in seconds, saving up to 99% disk space.

Documentation

SQL Clone Technology Overview

There are 2 key concepts that underpin SQL Clone: data images and clones. Learn more about them in this short document.

Video

Tip #19: Restore closed tabs with Tab History

In this tip Data Platform MVP Grant Fritchey explains how to use SQL Prompt to restore your tabs, even if you closed them by mistake!

Case study

Republic Bank – Streamlining database deployments with SQL Compare

Find out how Republic Bank freed up 70-80% of their DBA team's time by switching to SQL Compare for SQL Server database deployments.

Case study

Lumidata – Managing over 500 SQL Server databases

Lumidata uses SQL Compare Pro as part of the SQL Toolbelt. Find out how John Trumbul saved a half-year of a developer's salary in his f…

SQL Prompt Tips – #1 Selecting in the Object Explorer

How to jump to objects and columns in the Object Explorer straight from your query, with SQL Prompt.

Documentation

SQL Prompt vs. SQL Server IntelliSense

Compare SQL Prompt feature-by-feature with SQL Server's native IntelliSense.

Documentation

SQL Prompt quick reference guide

This handy quick reference guide includes our top 12 snippets, and shortcuts and tips for code-completion, formatting, navigation, and …

Super SQL Tips

Tip #18: Write SQL quickly in Visual Studio: save time with code snippets

Data Platform MVP Steve Jones explains how to use SQL Prompt in Visual Studio to write SQL quickly and accurately with the help of code…

Super SQL Tips

Tip #17: Write SQL quickly in Visual Studio: reorder $placeholders$

Data Platform MVP Steve Jones explains how to use SQL Prompt in Visual Studio to write SQL quickly and accurately with the help of plac…

Super SQL Tips

Tip #16: Write SQL quickly in Visual Studio: make the most of $placeholders$

Data Platform MVP Steve Jones explains how to use SQL Prompt in Visual Studio, to write SQL quickly and accurately with the help of pla…

Super SQL Tips

Tip #15: Pick just the columns you need for speedy results

Data Platform MVP Steve Jones explains how to use SQL Prompt to retrieve just the columns you need in a SELECT statement for speedy res…

Super SQL Tips

Tip #14: Pay it forward – avoid ambiguity by renaming variables clearly

Data Platform MVP Grant Fritchey explains how to use SQL Prompt to rename all uses of a variable in one quick step.

Super SQL Tips

Tip #13: Script objects as ALTER in two clicks

Data Platform MVP Steve Jones explains how to use SQL Prompt to script out objects as an ALTER statement in just a couple of clicks.

Super SQL Tips

Tip #12: Safely refactor stored procedures in a flash

Data Platform MVP Ike Ellis explains how you can refactor SQL code quickly by creating a new stored procedure from within an existing s…

Super SQL Tips

Tip #11: Quick SQL Prompt actions at your fingertips

Redgate product marketing manager Carly Meichen explains how to quickly jump to some really handy SQL Prompt actions in the query windo…

Super SQL Tips

Tip #10: Don’t get lost in SQL – highlight all matching objects intelligently

Data Platform MVP Grant Fritchey explains how to use SQL Prompt to highlight matching objects, which'll help you clearly differentiate …

Super SQL Tips

Tip #9: Popular snippets: II (INSERT INTO)

Data Platform MVP Steve Jones explains how to make best use of one of SQL Prompt's most popular snippets, II, for INSERT INTO statement…

Super SQL Tips

Tip #8: Safely refactor SQL code with Smart Rename

Redgate product marketing manager Carly Meichen explains how to use SQL Prompt to quickly and safely refactor SQL code.

Super SQL Tips

Tip #7: Find invalid objects to catch problems early

Data Platform MVP Ike Ellis explains how to use SQL Prompt to find invalid objects, so you can catch problems earlier in development an…

Super SQL Tips

Tip #6: #StopBadSQL: expand the wildcard and only retrieve columns you need

Data Platform MVP Steve Jones explains how to use SQL Prompt to expand wildcards and select only the columns you need, so you retrieve …

Super SQL Tips

Tip #5: Work quickly with data from the Results grid

Data Platform MVP Cathrine Wilhelmsen explains how to use SQL Prompt to quickly work with data from the Results grid in SQL Server Mana…

Super SQL Tips

Tip #4: Popular snippets: CDB (CREATE DATABASE)

Data Platform MVP Steve Jones explains how to make best use of one of SQL Prompt's most popular snippets, CDB, to create new databases …

Super SQL Tips

Tip #3: Are you sure you want to execute that UPDATE statement?

Bob Pusateri explains how SQL Prompt execution warnings can prevent you from making a costly change to your database.

Super SQL Tips

Tip #2: Popular snippets: SSF (SELECT * FROM)

Data Platform MVP Steve Jones explains how to make best use of one of SQL Prompt's most popular snippets, SSF.

Super SQL Tips

Tip #1: Save, customize, and share frequently used SQL snippets

Data Platform MVP Steve Jones explains how to use SQL Prompt to create and customize snippets for frequently used code, to save you tim…

Article

Learning .NET memory management

In this free 6-part article series, Ricky Leeks gathers together the top tips and techniques for understanding .NET memory management, …

Article

How to improve SQL Server query performance in .NET

14 tips on working with SQL Server, Entity Framework, LINQ, and other database technologies, as part of a .NET application.

Article

5 .NET code optimization techniques

5 advanced code optimization techniques from .NET developer Bartosz Adamczewski.

Article

How to improve .NET application performance – 11 tips

11 general tips on improving .NET application performance, from .NET MVPs and other members of the .NET community.