Posts Categorized in Building

At Redgate, we like building stuff. We build software products, tools, devices, LEGO, and more. We like building stuff so much, we built this blog to talk about building stuff. Here you’ll find posts on what stuff we’re building, how we go about building that stuff, and what we value and encourage in our people who build stuff for us. You might even see a post about building LEGO soon.

SQL Prompt 7’s new snippet manager

Posted by:
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

The why (and more importantly the how) of automated database deployment

Posted by:
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

Source controlling your database permissions

The problem A common question we encounter when working with SQL Source Control is about database permissions. Different environments require different permissions, so should you just omit them entirely from Source Control? Or perhaps include only permissions for your production environment? Permissions are extremely important, so not source controlling them at all doesn’t seem... read more

Two different types of release branch

Posted by:
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 did some Googling and... read more

Database continuous integration made easier with Redgate SQL CI and Bamboo

Posted by:
Most application developers are used to the benefits of continuous integration. With tools like Bamboo you can bring your application’s continuous integration and delivery pipeline together in a single workflow. What if you could include your databases in that same workflow? SQL CI is part of the DLM Automation Suite, a suite of tools... read more