Over the years, our SQL in the City events have proved enormously popular in offering SQL Server training to hundreds of database professionals. Now in its fifth year, SQL in the City attracts Database Administrators and developers (as well as other professionals who work with SQL Server) who want to hear the world’s top SQL Server speakers... Read more
Trying to tame complexity Over the last few years my team (“DevOps” – the name’s not entirely accurate, but close enough) have been putting together a handful of charter-like documents that we can agree on and work to. This isn’t an especially new idea and we shamelessly cribbed the initial version from one of the other teams.... Read more
If you haven’t heard of DLM Dashboard, let me fill you in – it’s a new free tool for helping SQL Server DBAs and developers know what database schema is deployed where. One of the main ways DLM Dashboard does this is by sending an email notification as soon as it spots any unexpected... Read more
We’ve just finished the acquisition of ReadyRoll, a database migrations and deployment tool that makes it easy for software teams to develop SQL Server databases within Visual Studio. That’s the headline news, but why did we do it, and are our customers really ready for it? I’ll answer the second question first. Yes. With... Read more
As I’ve been speaking and training people on Database Lifecycle Management (DLM), I’ve learned one thing. Trying to implement version control, and Continuous Integration (CI), and automated releases of code is hard. The concept is simple, but all of the various processes, tools, and links that need to be connected can be hard. I’ve... Read more
This week at Redgate HQ we’ve been lucky enough to have a visit from Dave Farley, Continuous Delivery evangelist and co-author of the book Continuous Delivery. In one of our discussions we started talking about database unit testing. Pretty soon we realized we both meant something fundamentally different when we called something a database... Read more
Hopefully you’ve already heard about DLM Dashboard? It’s Redgate’s new free tool for helping anyone who’s responsible for knowing what database schema is deployed where. If you hadn’t heard of it please feel free to download it, set it up, and come back to reading this post in about half an hour… Back with... Read more
If not, why don’t give it a go? As a company which adopts an agile methodology, testing is an integral part of the development process at Redgate. Team exploratory testing is an approach we take so that everyone on a team, from the developers to the support engineers as well as the project and... Read more
As a project manager, the process of deploying software can be fraught with anxiety and dread. I can think about numerous times in my career where, in the shadow of an approaching release deadline, the thought of having to deploy our application was akin to contemplating an imminent visit to the dentist. In fact,... Read more
A question we often get asked is how to deploy specific variations of a database to different customers. Or how to deploy different static configuration data to each customer, and how to version control, test and deploy this per customer in an automated way. In the post below I’m going to run through an... Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
