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
The long-awaited generation of SQL migration scripts is now a part of Vertabelo! You can use these scripts to easily move from one database model version to another. Read this article to learn more. Read more
Vertabelo has a great new feature: a model documentation auto-generator. You can now create and export documentation for your current model with just a few clicks. Read more