The fledgling computer industry did not invent version control. It merely adopted practices that were already well established in industrial manufacturing and design, where large, complex machines such as aircraft, tanks or motor cars required a great deal of discipline, particularly in the technical drawing of components. It all started with engineering The engineering... Read more
If you ran a MOOC online learning platform like edX or Coursera, how would you keep it organized? In this article, we’ll look at a database model that would do the job. Read more
Call them taxis or cabs, these convenient rides for rent have been around for centuries. Nowadays, it’s a lot more complicated to run a taxi service. In this article, we’ll look at a database model designed to meet the needs of a cab company. Read more
When writing SQL, you can use SQL Prompt to quickly jump to some really handy formatting and refactoring actions. This little button right here is called the Actions List and it contains over 20 functions and snippets you can use in just a few keystrokes. Simply highlight your block of code and hit Ctrl,... Read more
In general, people do not like receiving unsolicited e-mails. Nevertheless, they sometimes subscribe to newsletters in order to get a discount or to keep up-to-date with new products. This article will present one approach to designing a newsletter database. Read more
Sheep jokes aside, we’re excited to announce the launch of our SQL Clone beta, which will be released on 28 November. We’ve spent the best part of 2016 gathering requirements, getting a technical preview into the wild, and listening to feedback from the 1,500 people who signed up to the early access program. We’re... Read more
Redgate is a Silver Sponsor at this year’s PASS Summit and we have a number of exciting activities and events planned for the conference. Come to our Breakout Session Faster Provisioning with SQL Clone Database provisioning requests are the bane of many DBA’s working lives. Developers want to work with realistic data, DBAs want to... Read more
There have been a few changes recently in the way Redgate develops software. In a deliberate move to address ongoing requests and requirements from users, the product teams who develop each of the products have been joined by a team dedicated to developing the SQL Toolbelt. To find out what they do, how it affects... Read more
As a DevOps engineer at Redgate, I’m one of those responsible for keeping the systems going behind the scenes. That’s everything from the internal systems and databases to the infrastructure that keeps our websites up and running. As you might imagine, I don’t have a lot of free time, so if there’s a tool... Read more
A recurring event, by definition, is an event that recurs at an interval; it’s also called a periodic event. There are many applications which allow their users to setup recurring events. How does a database system manage recurring events? In this article, we’ll explore one way that they are handled. Read more
