Cambridge, UK
Jul 28, 2021   |  By Greg Dodd
In the IT team at Redox, I wear two hats: Software Development Manager and DBA. I’m the only DBA in the team, so if anything goes wrong it’s my job to identify and fix it. As you might imagine, this can be challenging when being a DBA isn’t your full-time role. Based in Sydney, Redox is one of the leading chemical and ingredients distributors in the world, with over 350 employees across our locations in Australia, New Zealand, Malaysia, and the US.
Jul 23, 2021   |  By Edwin Side
These are interesting – and challenging – times to be a Managed Service Provider. When it first published its Managed Services Market Size Forecast, Mordor Intelligence valued the market at US$152 billion in 2020, and predicted it to reach US$274 billion by 2026, a compound annual growth rate of 11.2%. Over a year later, following a pandemic which has changed the way most of us work and which will probably see permanent changes going forward, Mordor is sticking by its prediction.
Jul 22, 2021   |  By Kendra Little
How do we help Database Administrators (DBAs) embrace DevOps in a way that can be really productive and part of a rich DevOps team that delivers value to customers quickly and continuously? That’s an important question to ask right now because there’s a common view among DBAs that DevOps isn’t for them. They’re responsible for documentation and maintenance and deployments, they have internal customers, and they serve internal requests.
Jul 19, 2021   |  By Grant Fritchey
Flyway is an open-source database deployment tool that also includes a paid tier called Teams. Since it’s open-source, you can just download Flyway and run it for free. You’ll get a robust DevOps tool to assist you in deploying your databases just like you deploy your code. It just works. So, why would you even bother to pay for Teams? Actually, there are a number of reasons why people pay for advanced tiers of open-source software in general.
Jul 19, 2021   |  By Louise Domeisen
In the latest DBAle podcast episode our hosts, Chris and Chris, tackled what they really mean by cataloging a database and how taking a ‘giraffe’s eye view’ approach to compliance is not enough. That’s because the most common data concerns for managers and execs center around where your sensitive data is, the risk it poses and, if you’re migrating to the cloud, how much sensitive data is being stored on that database or that instance.
Jul 13, 2021   |  By Ben Emmett
It’s never been more critical to protect your data infrastructure against malicious actors, with organizations dealing with an ever-expanding number of increasingly sophisticated attacks. Monitoring solutions represent part of your infrastructure’s attack surface area – they enjoy highly privileged access to the systems they help manage, and store sensitive information about the workloads running on them.
Jul 6, 2021   |  By Edwin Side
For many businesses, using a Managed Services Provider (MSP) makes sense, particularly when it comes to database management, monitoring and security. They can control costs while still having access to expert resources, and dial up or down the service as required.
Jul 6, 2021   |  By Grant Fritchey
This question comes up all the time: How do you migrate between monitoring systems? The answer is both simple and complicated. In order to understand this better, rather than just rely on my own knowledge, I reached out to a number of people to see how they accomplished this. I’m going to summarize their process for you here in order to help others who may find themselves in need of this information.
Jun 29, 2021   |  By Howard Stredwick
This year we’ve been expanding SQL Monitor’s capabilities around the theme of Estate Management and we’ve just released a new capability – the discovery of on-premises SQL Servers and instances. We started on this journey with basic instance configuration observability and alerting earlier this year. While gathering feedback and finding ways to improve our new configuration features, we worked on and released an Instance Discovery Tool as a preview feature.
Jun 10, 2021   |  By Stephen Fontanella
A new case study shows how Desjardins uses Flyway Teams to standardize the way migration scripts are created and versioned across its multi-database estate, which includes Oracle, SQL Server and PostgreSQL. With assets of over $350 billion and seven million members and clients, Desjardins is the leading financial cooperative in North America.
Jul 1, 2021   |  By Redgate
Join Andrew Pierce, a Redgate Solution Engineer, as he takes you through how to use SQL Clone to prepare environments with subtle changes and requirements as part of the non-Prod provisioning process.
Jun 21, 2021   |  By Redgate
How do you ensure best coding practices are being adopted and reinforce this approach in your entire pipeline? In this video we show you how the same best practices are unified in the Code Analysis functionality offered by SQL Prompt, SQL Change Automation and SQL Monitor to ensure your team are making the best possible changes.
Jun 14, 2021   |  By Redgate
Data Masker for SQL Server is an incredibly powerful solution for de-identifying any sensitive PII that exists within your SQL Server Databases, but with great power, comes great configuration & customizability (and responsibility, of course). Join Chris, a Redgate Solution Engineer as they walk you through some of the common issues people can face when running masking sets, and how to easily start troubleshooting any failed runs yourself.
May 25, 2021   |  By Redgate
We are frequently asked about how to incorporate Test Driven Development Practices to current deployment processes. On this video I'll guide you on a step-by-step journey of how to create a new test project and align it with your existing SQL Change Automation database code pipeline.
May 17, 2021   |  By Redgate
It's hard to know where to start with Database Classification and many choose to go column-by-column. In this video join Chris as they show you how to get AdventureWorks classified in under 20 minutes using clever rules, bulk filters and a logical approach with Redgate SQL Data Catalog.
May 5, 2021   |  By Redgate
Is it possible to set up an end-to-end deployment pipeline from Dev through to Production in Azure DevOps, with SQL Change Automation and Azure SQL DB in just 10 minutes? Join Chris Unwin, a Redgate Solution Engineer, as they try to break the record for setting up a migrations-first pipeline with SQL Change Automation from Dev to Continuous Integration and finally, deployment.
Apr 30, 2021   |  By Redgate
Spawn let's you quickly spin up database instances in containers. This is great for dev environments, testing, continuous integration, training, and more. There's also a new extension for Azure Data Studio that makes connecting to the container super easy.
Apr 26, 2021   |  By Redgate
In this session, Anderson is going to walk us through the phases in our database development lifecycle, in which we can benefit from the use of Static Code Analysis, in order to prevent and reduce technical debt in our codebase as well as increase our deployment success rate.
Apr 16, 2021   |  By Redgate
As a part of the #GlobalAzure initiative, come learn how to implement DevOps as a DBA. We'll be using Azure DevOps as a demo of just how it's possible to control and automate database deployments.
Apr 12, 2021   |  By Redgate
Ever wanted to get a look at SQL Monitor? Chris Kerswell from Redgates Solution Engineering team takes us through the easiest way there is - using the SQL Monitor demo site! In this video, Chris shows us how to access the site and some of the key features available or interesting things to have a closer look at.

Our solutions make life easier for development, operations, and IT leaders by solving the database challenges in delivering software at speed.

Solutions for every stage in your Compliant Database DevOps journey:

  • Standardize team-based development: Prevent rework and conflicts, build consistency and quality into your code, and gain time for development that adds value, with standardized best practices for database development.
  • Automate database deployments: Unlock agility and performance across the full software lifecycle, with database continuous integration, continuous delivery, and shift-left testing that let you rapidly respond to user requirements.
  • Monitor performance and availability: Avoid performance issues, minimize downtime, and support efficient recovery with proactive visibility and insight into your database estate.
  • Protect and preserve data: Decrease the risk of breaches, protect business critical data, and meet compliance requirements while supporting data demands from developers and testers.

Discover how Compliant Database DevOps empowers your team.