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
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, easing the implementation... Read more
Diversity is one of the most prominent issues faced by digital businesses today. Research from industry body Tech Nation shows that women in IT are outnumbered by men 4:1 and make up just 19% of the UK digital workforce. The lack of young women taking up IT courses is a big cause of this... Read more
For most application developers, it’s unthinkable to work without version control. The benefits of tracking and retaining an incremental history of code changes are long understood in the world of software development. No surprise then that the overwhelming majority of respondents in our 2019 State of Database DevOps survey confirmed they’re already using this... Read more
I recently did some research on the source of data breaches and in this article, I’m going to talk a bit about my current favorite source for breach information, and what I learned. Verizon publishes the Data Breach Investigations Report annually and the latest report is the 11th edition, so they’ve had some practice.... Read more
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change. The study quizzed 3,958 leaders globally and explored the causes of the tech skills gap – particularly... Read more
Following the inaugural SQL in the City Summit in London, we’re excited to take the event on tour over the coming weeks, bringing major industry figures together to present in Los Angeles, Austin, Australia and New Zealand. Redgate’s Summits aim to demonstrate how data professionals can deliver value faster, while keeping data safe, by... Read more
Ever since the GDPR was introduced, the subject of data breach notifications has worried a lot of people. How do you write one? What do you need to include? What will the ramifications be? Will it make your customers run for the hills? Will it get you fired? I’ve got news for you, courtesy... Read more
Compliant Database DevOps
