Redgate Blog

Redgate Data Modeler

6 September 2017

Redgate Data Modeler

6 September 2017

A Song of Ice and Databases: A Game of Thrones Data Model

No plot spoilers – just a data model based on the Game of Thrones TV series. Read more

Redgate Data Modeler

30 August 2017

Redgate Data Modeler

30 August 2017

An Online Auction Data Model

Bidding sites are a popular way to buy and sell many products. In this post, we look at these online auctions from a buyer’s perspective. What does our data model need to handle the bidding process? Read more

Matt Hilbert

29 August 2017

Matt Hilbert

29 August 2017

DevOps and the database: what’s going on?

If you’re doing DevOps differently for your database and the rest of your system, there’s something wrong. There shouldn’t be a separate conversation about it, says Microsoft’s Donovan Brown. When DevOps was first talked about in Flickr’s seminal ’10 deploys per day’ Velocity presentation in 2009, it was regarded by… Read more

23 August 2017

23 August 2017

Why don’t you unit test SQL Server code?

The download count of the tSQLt unit testing framework is surprisingly low, yet this outstanding open source software can revolutionize your SQL Server development process. Hopefully, this post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. This simple technique can… Read more

23 August 2017

23 August 2017

A Marketing Agency Data Model

What goes into marketing a business? And what data model could a marketing agency use to run their organization? Read this article to find out! Read more

Redgate Data Modeler

9 August 2017

Redgate Data Modeler

9 August 2017

Part 4 – How to Use It

In the first two parts of this series we have installed SuiteCRM locally, imported its model into the Redgate Data Modeler database, and created relationships based on assumptions. In Part 3 we took a closer look at the most important parts of the CRM, how to use them, and how… Read more

Redgate Data Modeler

4 August 2017

Redgate Data Modeler

4 August 2017

Clinic Management System Data Model

Visiting a hospital or a clinic is never a pleasant situation. But it would be even worse if nothing was automated. Not so long time ago almost all documents were in a paper form. That not only polluted the environment but slowed down a process a lot. In some cases,… Read more

Jonathan Roberts

27 July 2017

Jonathan Roberts

27 July 2017

How might classification and better documentation improve data safety?

In this post, we imagine how auto-classification of data can be used to build better documentation that helps you trust that your organization can use data without posing a risk or compromising regulatory compliance. You may have read recently about how we’ve spent the last month exploring the theme of… Read more

27 July 2017

27 July 2017

Build Your Own City: An Open-Ended Building Game Data Model

City-building and management games have been very popular for decades. If you were to build your own city management game, what kind of data model would you need to run it? Let’s find out. Read more

Coeo

26 July 2017

Coeo

26 July 2017

Removing sensitive data from a database

Not too long ago I was assisting a client with an issue they were experiencing while running some compliance software to check for sensitive data. Sensitive data was picked up in the SQL Server data file but when the DBAs checked, the data was nowhere to be found in the… Read more

sensitive data

Previous Next

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Blog

A Song of Ice and Databases: A Game of Thrones Data Model

An Online Auction Data Model

DevOps and the database: what’s going on?

Why don’t you unit test SQL Server code?

A Marketing Agency Data Model

Part 4 – How to Use It

Clinic Management System Data Model

How might classification and better documentation improve data safety?

Build Your Own City: An Open-Ended Building Game Data Model

Removing sensitive data from a database

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Cookies on red-gate.com