Vendors/3rd-party Products

Article

Maintaining a version of a database opens a lot of possibilities, especially if an automated process can easily grab the current version, at runtime, using just SQL. You might, for example, have a routine that is only appropriate after a particular version. It is also very handy to be able to associate entries in an event log or bug report with the database version. No more desultory quests, when dealing with support issues, or when bug fixing, to find which database version was running when the bug happened.

2022-10-14

Improving the Quality of Data Governance: Where to Start?

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

How do we set about improving the quality of data governance within an organization? What are the priorities? Data Governance is generally considered to mean providing clear roles, responsibilities, policies, principles, and organizational structures that can ensure that data is managed well, in a way that benefits the whole organization. Where do you start?

2022-10-07

Join the EAP: Next-gen database cloning

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Redgate’s database cloning technology is getting an upgrade: Multi-RDBMS, instance-level clones, and support for containerized workflows. Automate DevOps test data for fast quality releases across your software organization. Learn more and gain first access by joining the early access program!

2022-10-03

The Redgate 100: Top Influencers List

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

We're recognizing the individuals in the database community for their work, online influence and thought leadership in our inaugural list of influencers: The Redgate 100.

2022-09-30

Data Governance: Joining the Dots

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Every organization must perform data governance. This requires planning, oversight, and control over the management, security, resilience and quality of data and over the use of data by the organization. In larger organizations, it can be a complex task. William Brewer explains what's involved.

2022-09-21

Managing Static Data in Flyway Database Development

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell.

2022-09-16

Discuss

Monitoring: The ROI of Build vs. Buy

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

There and pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of build vs. buy. In this blog post, Grant Fritchey discusses when you should build, and when you should buy.

2022-09-14

Rollbacks, Undos and Undonts

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Rollback scripts are designed to allow us to recover safely from a failed deployment that leaves the database in an indeterminate state. They must check exactly what needs to be reverted before doing so. If you work with an RDBMS that cannot support transaction DDL rollback they are vital. This article proposes a strategy where you create and test a rollback file, at the same time as the forward migration, and reuse it as a Flyway undo script.

2022-09-09

Managing Datasets for Database Development Work using Flyway

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

A generic way of exporting, deleting and loading data, for database development work. It uses Flyway Teams, a PowerShell framework, JSON files for storage and a table manifest to define the correct order of dependency for each task. It should help a team maintain datasets between database versions, as well as to switch between the datasets required to support different types of testing.

2022-09-05

The Uses of Dependency Information in Database Development

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Dependency information will allow you to avoid errors during a database build or tear-down, by ensuring you create or remove objects in the right order. It will also help you to avoid future 'invalid object' errors, because it will allow you to check that no database alterations have introduced broken references, during Flyway migrations.

2022-09-02

Vendors/3rd-party Products

Finding the Version of a Flyway-managed Database Using SQL

Improving the Quality of Data Governance: Where to Start?

Join the EAP: Next-gen database cloning

The Redgate 100: Top Influencers List

Data Governance: Joining the Dots

Managing Static Data in Flyway Database Development

Monitoring: The ROI of Build vs. Buy

Rollbacks, Undos and Undonts

Managing Datasets for Database Development Work using Flyway

The Uses of Dependency Information in Database Development

Blogs

Monday Monitor Tips: The Jobs Report

Automating SQL Maintenance: How DevOps Principles Reduce Downtime

From Couch-Potato to Triathlete – and What This Means for Your SQL Server

Forums

Find Invalid Objects in SQL Server

Single User SQL Server on Linux

All the Costs of Downtime

Question of the Day

Single User SQL Server on Linux