In 2018 we ran the industry’s first ever state of SQL Server monitoring survey. We received an excellent response from over 600 people in a range of sectors, in organizations of every size across the globe. They provided valuable insights into what they thought the biggest challenges were for them and their estates over... Read more
In the R&D division of Redgate, Foundry, we’re working on a new tool, SQL Census, in an effort to make your SQL Server permissions more manageable by seeing who has access to your servers and restructuring existing access rights into a simpler and more compliant format. We’re now building out the SQL Census preview... Read more
If developers and testers work with a database that has similar data characteristics and is of a similar size to production, it will lead to fewer surprises when deploying database changes and help the team troubleshoot urgent production bugs or performance issues. Likewise, if developers have an easy way to spin up multiple database... Read more
2018 will be remembered as the year the world stood up and took note of how slack some organizations were being with their data. The EU enacted the GDPR – the most far reaching data protection law so far – which seemed to lead to a snowball effect. Japan, Australia, India, and US states... Read more
In 2018, PASS was faced with the challenge of complying with the General Data Protection Regulation (GDPR), which affects any organization that collects, processes and stores the data of European citizens. Personally identifiable information has be protected, access to it restricted, and organizations have to demonstrate they have made every effort to comply with... Read more
DevOps is gathering pace. More and more organizations are recognizing that by encouraging collaboration, cooperation, and communication, they can release features faster and offer advantages to customers sooner. That’s the promise, but in order to adopt DevOps, organizations need to be able to embrace the openness it requires, change the way they function, encourage... Read more
At Redgate, encouraging personal development in our teams is fundamental to building amazing products. As well as developing new skills for employees to apply to their current work, personal development has a huge impact on job satisfaction. Drive by Daniel H. Pink discusses the principals behind what motivates us. He suggests that three main... Read more
SQL Server configuration plays a vital role in the health of your SQL Estate. Your needs may vary depending on the purpose of the server, or its role within a business, but a healthy configuration ensures availability and performance for your customers. We’ve been thinking hard about SQL server configuration in Foundry, Redgate’s R&D... Read more
Enforcement of the GDPR began in May 2018 and across the EU it seems to have been a relatively quiet period, with few fines handed down for non-compliance. Indeed, most organizations probably think all of their preparations have been worth the effort, and are well prepared for complaints from customers or investigations by regulatory... Read more
Database DevOps has been a ‘thing’ for a while now. Introducing practices like version control and continuous integration to database development reduces errors, speeds up deployments, and can help in demonstrating compliance with data protection regulations. A measure of its increasing importance was also highlighted in DORA’s latest State of DevOps Report which, for... Read more
Compliant Database DevOps
