At the end of 2015, we interviewed James Betteley, Head of Education at DevOpsGuys about the role of the database in DevOps. James is a firm believer that DevOps is about people and processes, and that while automation tools are necessary, they are not sufficient for a team to be a DevOps team. Here’s what... Read more
What kind of data model can handle all the planning and activities used in process management? In this article, we discuss one design for a process management database.
Read more
In this era of tough competition, job portals are not just platforms for publishing and finding jobs. They are leveraging advanced services and features to keep their customers engaged. Let’s dive into some advanced features and build a data model that can handle them. Read more
Good question. Redgate recently ran a State of Database DevOps survey among 1,000 software professionals. The survey included developers, database administrators, and those at management level, and over half of the companies involved employed more than 500 people. I took a quick glance at the results in a recent blog post and talked about some surprising findings:... Read more
Bus and train travel hubs are full of activity: the crowd, the rush, the lines, the race to the platform r a terminal. Clearly, such places require a lot of organization! In this article, we’ll describe a database model that could keep a transport hub organized. Read more
What kind of database model does it take to run a gallery or museum? How can it be optimized to manage events, partnerships, and other activities? Read more
At Redgate, we think DevOps is now sufficiently mainstream and that it’s worth businesses thinking of moving to a database DevOps type of world. One of the reasons is the 2016 State of DevOps Report from Puppet Labs. They interviewed 4,500 people about their experiences of DevOps and the report provides some strong evidence... Read more
Here at Redgate, there’s a strong sense of working as a team, even across functions, and that really came through during the preparations for this year’s virtual SQL in the City Streamed. Doing a live stream isn’t something I’ve put my hand to before, but I knew a guy – two guys in fact. They... Read more
In this article, I’ll walk you through some fundamental considerations for working with date- and time-related data in MySQL. We’ll also look at how to handle multiple time zones and daylight saving time changes. Read more
Lots of people talk about DevOps lots of the time. No surprise there. It’s seen as the route to speed up the software delivery cycle, while at the same time improving the efficiency and quality of the development process. But how many companies out there are actually doing DevOps? What are the obstacles to... Read more