Over the last few years we’ve seen a shift in customer concerns around personal data, brought about by frequent reports of breaches involving famous brands and the growth in new legislation designed to combat this trend. The Facebook Cambridge Analytica scandal in early 2018 was a wakeup call for many. Here was a platform that we’d... Read more
You may have heard the news about Amazon being sued recently for storing recordings of children talking to Alexa, without first asking for consent. Two suits were filed in Seattle and Los Angeles, ironically on the day before the company released its new Echo Dot Kids Edition smart speaker. The lawsuits allege Amazon failed... Read more
Here in the Redgate Foundry, we’ve been conducting research to understand ways to help data professionals manage their server estates more effectively. Our aim is to support you in providing a single source of truth about what is happening in your estate, provide a foundation for you to build and plan from, and empower... Read more
You might have heard of the concept of containers, at least in passing – or maybe you’re already using them widely in both dev/test and production. Containers are a great way to isolate your application code from the environment it’s running in, and they offer a range of benefits from easier deployments and scaling... Read more
One of the most common processes in software development is using a copy of production data to help develop new features or troubleshoot an issue. This typically involves creating a database backup by copying backup files to a local development server or the developer’s computer. In this process there are several risks involving the... Read more
Many organizations have taken a more proactive approach to IT security rather than waiting for something bad to happen. Recognizing the immense cost of a data breach (an average of $3.86 million according to the Ponemon Institute’s 2018 Cost of a Data Breach Study) and the time it takes to contain a breach (an... Read more
In this step-by-step guide, we’ll be walking through the process of moving data from an on-premises SQL Server to Azure SQL Data Warehouse using the Copy Data feature in Azure Data Factory. The use case we’ll focus on is the first-time loading of data. Skip to instructions A note to Data Platform Studio users... Read more
Bloor has published its 2019 Market Update for Test Data Management, listing Redgate as an innovator, and scoring SQL Provision 4.5 stars out of 5 for test data provisioning. If you’re not familiar with Bloor, it’s an independent research and analyst house founded to help organizations choose optimal technology solutions. As database teams grapple with... Read more
There is constant pressure in software delivery to release at speed and often. To take an idea or fix and deliver it into the hands of customers in as little time as possible. However, releasing faster isn’t beneficial if what you’ve developed is of no value to the customer or business or, worse, contains... Read more
Updated June 2020 Development and IT departments face increasing demands to deliver changes faster, often with increasing complexity and less tolerance for downtime, and without a corresponding growth in team size to handle the extra work. Standardizing database development practices by establishing coding standards can help achieve this by removing blockers to understanding code,... Read more