If you hold ‘personally identifiable information’ (PII) about EU citizens, the new General Data Protection Regulation (GDPR) applies to you. That’s true even if you aren’t in the EU, since this law is extra-territorial. This is significant for various reasons, including the fact that the maximum penalties for failing to comply would probably bankrupt... Read more
Research shows that cars remain parked for 95% of their lifetime, suggesting that parking lot management systems should be smart, efficient, and robust. In this article, we’ll construct a data model for such a system. Read more
Designing a data platform for a new product or service is a fascinating and exciting challenge. It’s also a daunting one. Instead of plugging a new feature into an existing platform that is proven and reliable, the onus is on you. You have to start from scratch and create a platform that becomes just... Read more
You may already have heard about Microsoft’s new DevOps platform for database development, SQL Operations Studio, or “SQL Ops Studio”. The preview version was announced at PASS Summit on 1 November, and Foundry, the R&D division of Redgate has been researching the feasibility, practicality and appeal of cross-platform data tools for a while. You... Read more
We’re once again running our popular SQL in the City event online, so that the Redgate and data platform community can benefit from free training in a virtual setting. On December 13, we’ll be live-streaming from Redgate HQ from 11am-4pm GMT, and again from 6pm-11pm GMT. Technical sessions will dive into the latest Microsoft... Read more
DevOps is moving into the mainstream, and the database is now being included, but what still holds some organizations back is the thorny issue of calculating the Return on Investment. If you’re a decision-maker in charge of running software development teams, you need to know that the investment you make in adopting new processes... Read more
Weddings are often accompanied by merriment and celebration, with numerous guests, food, drinks, music, and dancing. But all of this can’t happen without the proper preparation and coordination. Let’s take a closer look at how data modeling can help us better organize a wedding so everything runs smoothly. Read more
A major new data governance survey from Redgate demonstrates there are important GDPR compliance issues that need to be addressed – and that a DevOps approach to database development can provide the answers. A first glimpse into the results of the 2017 Data Governance Implementation survey, which questioned more than 500 SQL Server professionals,... Read more
Life insurance is something we all hope we won’t need, but as we know, life is unpredictable. In this article, we’ll focus on formulating a data model that a life insurance company may use to store its information. Read more
If you’re struggling to set up a reliable, repeatable release process you’re not alone. The good news is that most of the problems you’ll encounter have been solved before. There are many smart strategies you can use to create a fast, smooth release process that will give your entire team a competitive edge. Tip... Read more
