Redgate Blog

Posts by
Tony Davis

21 April 2020

A Hybrid Approach to Database DevOps

A flexible approach to Database DevOps where the team maintain the current state of the database in version control, during development, and then at key stages generate and test the migrations script that will deploy the changes to the target database, safely. Read more

Tony Davis

5 November 2019

Tony Davis

5 November 2019

SQL Prompt 10: What’s New?

Tony Davis reviews the major new features of SQL Prompt 10, included improved 'ranking' of its code auto-completion suggestions, tab history improvements to make it easier to find 'lost' code, and auto-fixing of code that breaks code analysis rules. Read more

Tony Davis

13 February 2019

Tony Davis

13 February 2019

Scaling Redgate Monitor to Large SQL Server Estates

Tony Davis describes the features and capabilities of Redgate Monitor that allow it to scale smoothly to monitor a growing estate of servers and databases, while still providing a single, simple dashboard that gives the team all of the essential SQL Server metrics and alerts, establishes baselines, and detects trends… Read more

5 February 2019

5 February 2019

Avoid running out of Disk Space ever again using Redgate Monitor

Redgate Monitor not only collects all the disk and database growth tracking data you need, automatically, but also analyses trends in this data to predict accurately when either a disk volume will run out of free space, or a database file will need to grow. Read more

monitoring database growth

tracking free disk space

Tony Davis

8 January 2019

Tony Davis

8 January 2019

The Database DevOps Challenges SQL Provision Solves

SQL Provision helps to accelerate the delivery of database changes, by enabling an organization to provide database copies, and the right data, to all parts of the deployment pipeline that need it, with a light footprint, and securely. Tony Davis explains how. Read more

Compliant database DevOps

Tony Davis

22 December 2018

Tony Davis

22 December 2018

Picking over the Bones of a SQL Injection Attack

The best way to learn how to protect your databases from SQL Injection is to to see it in action and confront its consequences. This article tells the story of an attack on a vulnerable SQL Server REST interface, explaining how the attack unfolds, the mistakes that made it possible,… Read more

SQL Server security monitoring

Tony Davis

28 September 2018

Tony Davis

28 September 2018

Merging a Conflict with SQL Source Control and Beyond Compare

Tony Davis explains how to resolve simple merge conflicts, such as conflicting changes to the same stored procedure, using SQL Source Control and a merge tool such as Beyond Compare. Read more

database source control

Tony Davis

14 June 2018

Tony Davis

14 June 2018

Troubleshooting Blocking in SQL Server using Redgate Monitor

Redgate Monitor tells us immediately when significant blocking occurs, and where, during busy periods, and provides the full blocking chain, in an easy-to-digest graphical format, so we can diagnose and resolve the blocking quickly. Read more

10 March 2018

10 March 2018

Monitoring and Troubleshooting Deadlocks with Redgate Monitor

This article explains what SQL Server deadlocks are, why they occur, why they require immediate investigation, and the diagnostic data required to troubleshoot them. It then demonstrates an "Update Order" deadlock condition and shows how to find the cause quickly, in Redgate Monitor, using the Extended Events deadlock graph provided… Read more

15 January 2018

15 January 2018

Create, protect and manage non-production databases with SQL Provision

SQL Provision allows users to create copies of SQL Server databases in seconds, using a fraction of disk space, and mask any sensitive data to help address data privacy and protection concerns. It serves as a gateway between production and non-production environments, to ensure the safe distribution of database copies from… Read more

data protection and privacy

Database DevOps

database provisioning

Previous Next

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

Posts by
Tony Davis

A Hybrid Approach to Database DevOps

SQL Prompt 10: What’s New?

Scaling Redgate Monitor to Large SQL Server Estates

Avoid running out of Disk Space ever again using Redgate Monitor

The Database DevOps Challenges SQL Provision Solves

Picking over the Bones of a SQL Injection Attack

Merging a Conflict with SQL Source Control and Beyond Compare

Troubleshooting Blocking in SQL Server using Redgate Monitor

Monitoring and Troubleshooting Deadlocks with Redgate Monitor

Create, protect and manage non-production databases with SQL Provision

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Posts byTony Davis

Cookies on red-gate.com

Posts by
Tony Davis