What are the conceptual, logical, and physical data models? Learn the difference between those models and how to create each one. Read more
A comprehensive list of easy-to-use tools that let you generate ER (Entity Relationship) diagrams online. Read more
Options for filtering when generating migrations and when reporting on database drift help teams make the best of tricky database environments. Read more
Like every industry sector, 2020 has been a tough year in tech. The pandemic has changed the way we work, it’s changed the way our customers work, and it’s been a rollercoaster ride. In August 2020, IDC’s Global ICT Spending Forecast 2020 – 2023 predicted 2020 revenue in the sector would fall to $4.8... Read more
December 1 saw the introduction in New Zealand of the Privacy Act 2020 which not only brings increased protection for individuals but also has some new implications for businesses, including increased fines for non-compliance and the reporting of serious privacy breaches. However, the changes and impact may be less than organizations fear because the... Read more
Are you interested in cloud-data warehouses? This is a comprehensive introduction to one of the most popular ones: Amazon Redshift. Read more
18 months ago, Redgate embarked on a new and ambitious journey with the acquisition of Flyway. It’s been quite a ride since then and we thought we’d end 2020 with an update on what’s been happening with the world’s most popular open source migrations framework for database deployments. We’ve learned a lot, and I... Read more
Looking to level up your performance tuning game? Check out three new videos on tempdb, unstable query plans, and identifying blocking chains with SQL Monitor. Read more
18 months ago, Flyway was acquired by Redgate. It’s been quite a ride since then and we thought we’d end 2020 with an update on what’s been happening with the world’s most popular open source migrations framework for database deployments. We’ve learned a lot, and I wanted to share that with you in this... Read more
An entity-relationship diagram, also known as an ER Diagram, is a visual blueprint of a data model based on entities, attributes, and relationships. Read more