Redgate Blog

15 September 2015

Tackling Your Troubles – Building a Bug and Problem Database

Death and taxes – add “software problems” to that list of the inevitable. There is always a new issue, a new failure, a new key opportunity that an organization must address. And to avoid repeating the problems, or to revise your prior fixes, it is critical to capture… Read more

Jose Neto

14 September 2015

Jose Neto

14 September 2015

Using PhantomJS to improve UI automated testing

Test automation is a major part of the testing effort conducted at Redgate, and all our teams work hard to continuously improve existing practices. In this post, I’ll describe one of the problems we faced – and our approach for solving it. Scenario: A set of UI automated tests with… Read more

10 September 2015

10 September 2015

Defining Identifying and Non-Identifying Relationships in Redgate Data Modeler

Various data modeling tools allow modelers to define relationships in a data model as identifying or non-identifying. We can define a relationship as identifying or non-identifying in Redgate Data Modeler as well. This article will explain the way to do so. Read more

Redgate Data Modeler

8 September 2015

Redgate Data Modeler

8 September 2015

Managing Roles and Statuses in a System

There are many ways to solve a problem, and that’s the case with administering roles and user statuses in software systems. In this article you’ll find a simple evolution of that idea as well some useful tips and code samples. Read more

Redgate Data Modeler

1 September 2015

Redgate Data Modeler

1 September 2015

Database Model for a Driving School’s Reservation System. Part 2

Let’s build further changes into the data model, which I created in my earlier blog post, such as having an automated approach to assigning an instructor and vehicle to a lesson, invoicing to customers and tracking of them. Read more

Redgate Data Modeler

27 August 2015

Redgate Data Modeler

27 August 2015

How to Keep Track of What the Users Do

In several of the projects we have worked on, customers have asked us to log more user actions in the database. They want to know all of the actions the users perform in the application, but capturing and recording all human interactions can be challenging. We… Read more

Alasdair Daw

26 August 2015

Alasdair Daw

26 August 2015

SQL Prompt 7’s new snippet manager

During the development of SQL Prompt 7, we overhauled the snippet manager to make it more powerful and customizable. The snippet manager documentation lives here but there are some subtleties that I wanted to cover in in this post. Everyone writes SQL differently and we want SQL Prompt to work… Read more

24 August 2015

24 August 2015

Birds, Bees, and Honeycomb

Had I ever been asked the question “What animal would you like to be and why?” (apparently it was a common interview brainteaser), I would have answered “A penguin”. I like water, I also like sardines. I don’t care much for flying (in fact, the older I get, the more… Read more

Redgate Data Modeler

20 August 2015

Redgate Data Modeler

20 August 2015

Designing a Data Model for a Hotel Room Booking System

It’s common knowledge that the best way to learn something is to practice it in a real-life scenario. Obviously, the same applies to database modeling. Therefore, in this article I decided to teach you how to create a simple database structure, taking a textbook example of a hotel room reservation… Read more

Michael Clark

11 August 2015

Michael Clark

11 August 2015

Improving ReadyRoll performance, one line at a time

In our latest release, we sped up ReadyRoll’s performance more than x10 on large databases in two key areas of the product: script generation and project packaging. If you are new to a codebase and haven’t done any performance work on the application before, it is a good idea to… Read more

SQL Change Automation

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 Assistant

Redgate Blog

Tackling Your Troubles – Building a Bug and Problem Database

Using PhantomJS to improve UI automated testing

Defining Identifying and Non-Identifying Relationships in Redgate Data Modeler

Managing Roles and Statuses in a System

Database Model for a Driving School’s Reservation System. Part 2

How to Keep Track of What the Users Do

SQL Prompt 7’s new snippet manager

Birds, Bees, and Honeycomb

Designing a Data Model for a Hotel Room Booking System

Improving ReadyRoll performance, one line at a time

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 Assistant

Cookies on red-gate.com