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
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
For a long time, SQL Compare has been the industry standard for comparing and deploying SQL Server database schemas. Packed with features that can be used to maintain a history of deployments, it makes it possible to build up a record of which objects were changed, when a change was applied, who made it,... Read more
Continuous delivery brings big business benefits to application development – it’s time to give the database the same benefits, says Simon Galbraith, chief executive and co-founder of Redgate. Microsoft’s recent announcement that Windows 10 will be the last big-bang release for the operating system was a surprise to many. But what on Earth is... Read more
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
Compliant Database DevOps
