In my last post, I looked at the first stage of our maturity model, the Manual level. In this post we move to the S2 level, which is characterized by the use of a formal Version Control System (VCS) and process. S2 – Automated Version Control Many software development organizations have implemented a VCS... Read more
At Redgate Software, we’ve been trying to build tools that help developers work with software better. One of our areas of focus in the last few years has been streamlining database development and deployment. To help customers migrate to a smoother workflow and a better engineered software development pipeline, we’ve built our own maturity... Read more
One of the ways in which many software development teams have tried to improve the quality of their output is by examining what has worked in other organizations and projects in the past. They look to experiment with new techniques and ideas, and implement those items that work. This practice has allowed Agile, Scrum,... Read more
Test automation is a major part of the testing effort conducted at Redgate, and all our teams work hard to continuously improve existing practices. In this post, I’ll describe one of the problems we faced – and our approach for solving it. Scenario: A set of UI automated tests with Selenium were not trustable.... Read more
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
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
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
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
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 to is seeing everyone... Read more
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 database changes they’ve been... Read more
