Monitoring Amazon RDS SQL Servers to Optimize Performance and Manage Costs

Israel Valverde explains the triple benefits of using Redgate Monitor to cover your SQL Server instances running on Amazon RDS, for SQL Server performance optimization, controlling AWS-hosting costs, and in providing a single, unified view of the health of all your SQL Servers, regardless of where they are hosted. Read more

Database Build Blockers: Four-part Object References

Cross-server references keep cropping up as a problem for development and build. Phil Factor demonstrates how using linked server 'aliases' can get around these issues, even if the individual databases use four-part references within the code rather than synonyms. Read more

Database Updates: Roll Back or Fix Forward?

Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update. Read more

Sharing SQL Code Snippets with Coworkers, The World and Yourself

Louis Davidson explains how he manages and shares several different sources of SQL Prompt code snippets, in a single Snippet library, using Dropbox and source control. Read more

What is a Data Catalog?

A data catalog allows an organization to discover and record the facts about its data, where that data is held and how it used. William Brewer explains the details. Read more

Effective Data Governance: Being Grown Up About Data

William Brewer explains how to make data governance a continuous organizational activity, based on well-established standards and practices, rather than a knee-jerk response, and which skills and tools will help you achieve compliance, including SQL Data Catalog for discovery and classification of data held in SQL Server. Read more

Database DevOps for Pragmatists: A Datafaction Case Study

Ami Adler, a Software Development Manager at Datafaction explains how they used Redgate tools, and others, to introduce automation and testing into their Database DevOps processes and so achieved a faster and more reliable deployment process for their application. Read more

Managing Cross-Database Object References (EI016, EI026, EI027)

Phil Factor explains cross database and cross-server references, how to find them in your code, and when it's better to avoid hard-coding these references and use synonyms instead. Read more

Creating a SQL Code Snippet in SQL Prompt and SSMS

Phil Factor's "getting started" guide for turning all your trusted and most frequently used queries into SQL code snippets. Read more

Questions about SQL Prompt you were too shy to ask

Phil Factor answers some questions you've been itching to ask about SQL Prompt, covering ranked code completion suggestions and auto-fixing SQL code smells, and suggesting where in the tool to find other nuggets of hidden treasure. Read more

Redgate Test Data Manager

Redgate Flyway

Redgate Monitor

Overview

Protect

Automate

Monitor

Product articles