Redgate Blog

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 had to log all... 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 with your current workflow... 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 frightening a prospect that... 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 system. I will show... 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 get a big, bad... Read more

SQL Change Automation

Elizabeth Ayer

10 August 2015

Elizabeth Ayer

10 August 2015

The why (and more importantly the how) of automated database deployment

Reliability, traceability, speed: these are the top three motivators for automating the deployment of database changes. Especially when it comes to production, there is no compromising on the level of scrutiny that may just prevent something disastrous happening in production. This need for quality has a strange effect. We talked recently to 30 teams at various stages... Read more

6 August 2015

6 August 2015

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

I like to use a domain driven approach for designing a data model. It makes me put technology obsession aside and concentrate primarily on modeling the subject area revolving around its associated entities and relationships amongst themselves. I need to design a data model for a reservation system that will be implemented in a... Read more

Redgate Data Modeler

5 August 2015

Redgate Data Modeler

5 August 2015

Upcoming Changes in Vertabelo Team Account

We listened to your feedback and improved managing Vertabelo team accounts. No more confusing switching back and forth between personal and team accounts! The changes will be implemented in the next couple of days, so if you have a team account in Vertabelo, this article is the must-read for you. Read more

Redgate Data Modeler

31 July 2015

Redgate Data Modeler

31 July 2015

How to Design a Database Model for a Movie Theater Reservation System

Do you like going to the movies? Have you ever considered what the database design behind their reservation system looks like? In this article we’ll prepare an example database model for a movie theater. Read more

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

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 Blog

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

The why (and more importantly the how) of automated database deployment

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

Upcoming Changes in Vertabelo Team Account

How to Design a Database Model for a Movie Theater Reservation System

2025 State of the Database Landscape

Introduction to PostgreSQL for the data professional