Redgate Blog

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… 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… Read more

Redgate Data Modeler

5 August 2015

Redgate Data Modeler

5 August 2015

Upcoming Changes in Redgate Data Modeler Team Account

We listened to your feedback and improved managing Redgate Data Modeler 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 Redgate Data Modeler, this article is… 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

Annabel Bradford

29 July 2015

Annabel Bradford

29 July 2015

Why I get excited about SQL in the City …

It’s been four years since Redgate’s first SQL in the City and in that time we’ve hosted the event 16 times in a range of cities. It’s become something of a well-oiled machine and I’m pretty confident we’ve got the dynamic down to a ‘tea’. What I most look forward… Read more

SQL in the City

Amy Burrows

22 July 2015

Amy Burrows

22 July 2015

The key to avoiding database version control problems

It’s a familiar story. Two developers are working on a database, they’re using version control, and there’s a problem. The bigger problem is, they don’t even know they have a problem. As far as they’re concerned, they’re doing everything right. They’ve been using version control, so they can deploy the… Read more

22 July 2015

22 July 2015

Email Confirmation and Recovering Passwords

Modern applications have plenty of authentication features beside registration and login. In this article we will take a look at how to design the database for two such features: email confirmation and password recovery. Read more

Alex Yates

21 July 2015

Alex Yates

21 July 2015

Two different types of release branch

When devising the first workshop for the new Redgate DLM training program, Steve Jones and I got into a bit of a debate about branching. Upon reflection, it’s obvious why. People often use the term ‘release branch’, but they can mean different things. It is important to be clear. I… Read more

Release Branch

Redgate Data Modeler

17 July 2015

Redgate Data Modeler

17 July 2015

7 Common Database Design Errors

The art of designing a good database is like swimming. It is relatively easy to start and difficult to master. If you want to learn to design databases, you should for sure have some theoretic background, like knowledge about database normal forms and transaction isolation levels. But you should also… Read more

Redgate Data Modeler

15 July 2015

Redgate Data Modeler

15 July 2015

Adding More Advanced Features Like Managing Categories and Voting on Threads and Posts

In this next article in the series on designing a database model for an online discussion forum, I continue to add features to the model. Firstly, I will enhance the post table. Then, I will deal with post categories and up/downvoting functionality. Read more

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

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 Redgate Data Modeler Team Account

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

Why I get excited about SQL in the City …

The key to avoiding database version control problems

Email Confirmation and Recovering Passwords

Two different types of release branch

7 Common Database Design Errors

Adding More Advanced Features Like Managing Categories and Voting on Threads and Posts

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