When you’ve got a great idea for transforming software development or IT processes in your organization, it can be frustrating. You might have a clear picture of what you can achieve, but often you’re not sure how to get buy-in from key stakeholders, or how to change your company culture. It can be made... Read more
SQL Server 2008 and SQL Server 2008 R2 are out of extended support as of July 2019, but the end of bug fixes, security updates and ongoing support has far-reaching data privacy implications, as James Boother from Microsoft Gold Partner, Coeo, explains. Microsoft products typically have five years of mainstream support, followed by five... Read more
On Tuesday 19th March 2019, Redgate held our second annual internal product development conference, Level Up 2019. The conference took place at the Imperial War Museum Duxford, and involved 120 Redgaters coming together to share skills, knowledge, and ideas with their colleagues. At Redgate, learning and development is important to us. We believe encouraging... Read more
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