At the end of 2016, we interviewed Bob Walker, a Lead Application Developer, to find out how he went about setting up automated database deployments using Redgate tools and what lessons he’d learned. The highlights make interesting reading. You describe the time before Redgate database automation as ‘truly the Wild…Read more
Ever use Craigslist or some other online classified ad website to sell or buy something? Did you wonder how it worked? In this article, we talk about how an online classifieds data model can be designed using a relational database.Read more
Live streaming events is something that’s rather new to Redgate, the first one being SQL in the City back in December, which was a great success. So with the launch of our new tool SQL Clone looming, we thought we’d do it again. There’s good reason too. While meeting people…Read more
What’s SQL Data Mask? SQL Data Mask is the latest product from Foundry to be graduated to the prototype phase. It copies your database while anonymizing personal data. You can use it to mask your databases right now, free of charge, and there’s a full tutorial below. You can also…Read more
Have you ever wondered how electricity gets from the power station to your home or office? In this article, we’ll look at a database model that could work for an electricity distribution system. Read more
On Friday, March 10, I attended the Working Effectively with Legacy Code workshop hosted by Michael Feathers, along with a few other members of my team. We maintain a difficult legacy code base and we were eager to do some practice and learn some useful techniques. The most important lesson I…Read more
Foundry is Redgate’s research and development division. We develop products and technologies for the Microsoft data platform. Each project progresses through Foundry’s four-stage product development process: Research, Concept, Prototype, Beta. At each stage, the Foundry team is exploring the scope and potential for Redgate to develop a product. One of…Read more
In Foundry – Redgate’s research division – we’re focused on exploring new products and technologies for the Microsoft data platform. Over the last few months, we’ve been taking a close look at the problems people face when auditing and meeting regulatory compliance for SQL Server. An introduction to compliance and SQL Server…Read more
Even with the right tooling, it can be tricky figuring out how to get an automated database deployment pipeline up and running. That’s why each month we host an hour-long DevOps webinar with an end-to-end demo of our database automation tools, showing how to check a database change into version…Read more
In this post, I’d like to introduce you to the Universal Architecture idea described by J.B. Rainsberger in the podcast Unit Testability and the Universal Architecture. Everyone wants to deliver software that works and delivers value to our customers. That’s a fact! Everyone wants our software to be easy to change and maintain.…Read more