Redgate Blog

9 June 2016

Identifying the Bill of Materials (BOM) Structure in Databases

The bill of materials (BOM) design pattern is deceptively simple, yet incredibly powerful. Historically, it’s been employed to model product structures, but the pattern can be used to do much more than simply define a hierarchy. This article will introduce three very different examples to help you to recognize the… Read more

David Atkinson

7 June 2016

David Atkinson

7 June 2016

Is your SQL code covered?

No, it almost certainly isn’t. Besides, how would you know either way? Let me explain. Most modern software development today includes some form of automated testing. While comprehensive unit testing is still sorely lacking in many organizations, it’s often mitigated by other forms of automated testing conducted later on in… Read more

continuous integration

SQL Change Automation

SQLCover

Redgate Data Modeler

7 June 2016

Redgate Data Modeler

7 June 2016

A Simple Online Store Model: Sell, Ship, and Get Paid

A lot has changed over the last 30 years, especially in IT-related domains, but few things have changed as much as how we shop. We still mostly buy milk and groceries at physical stores, but widespread online stores have led most of us to try some form of e-shopping.… Read more

Roger Hart

6 June 2016

Roger Hart

6 June 2016

Introducing user account licensing

We’ve been talking about licensing system changes for a while, and over the next few weeks they start rolling out in the first batch of products. This means that when you update to the next versions of our products, you’ll be asked to log in with a Redgate ID: Logging in… Read more

Kate Duggan

2 June 2016

Kate Duggan

2 June 2016

Teamwork is the key to developing SQL Source Control as well as using it

The long-awaited release of SQL Server Management Studio (SSMS) 2016 is approaching, bringing with it a more modern look and feel, more features, and more advantages for users. At Redgate, we’ve been working closely with Microsoft to make sure the latest version of SQL Source Control supports SSMS 2016 from launch… Read more

SQL Source Control

Redgate Data Modeler

2 June 2016

Redgate Data Modeler

2 June 2016

Beverly Hills 90210 and ZIP+4: Handling Addresses in Data Models

In my last post, I wrote about ensuring that your data model properly handles global information: numbers, currencies, phone numbers, addresses, dates, and time zones, among other things. However, I’ve realized that many example data models have exactly the “self-centric” or “Amero-centric” approach that I cautioned against. Read more

Redgate Data Modeler

24 May 2016

Redgate Data Modeler

24 May 2016

Merging Multiple User Accounts

Social media surrounds us, so it’s not unusual for applications to require some kind of social media integration. The most common is signing in with Facebook, Twitter, or another service. Users expect to be able to log in with different social accounts. So, applications meet these expectations by offering… Read more

Kate Duggan

18 May 2016

Kate Duggan

18 May 2016

Managing environments in DLM Dashboard

DLM Dashboard is a free tool that lets you track schema changes as they progress through the different stages of your database lifecycle. With DLM Dashboard you can start to get a much better picture of your workflow and see where you might need to take remedial action. DLM Dashboard categorizes… Read more

DLM Dashboard

Redgate Data Modeler

12 May 2016

Redgate Data Modeler

12 May 2016

7 Key Things to Remember About Data Model Globalization

Very few database authors mention the challenges of globalization and localization in any meaningful way. There’s a similar lack of foresight from database architects. The fact is that many authors and designers are frequently very ‘self-centric’: they create (or write about) data models that only properly handle their local time… Read more

Redgate Data Modeler

5 May 2016

Redgate Data Modeler

5 May 2016

What Do Poker, Blackjack, Belot and Préférence Have to Do with Databases?

How to design a database flexible enough to accommodate several very different card games. Read more

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

Identifying the Bill of Materials (BOM) Structure in Databases

Is your SQL code covered?

A Simple Online Store Model: Sell, Ship, and Get Paid

Introducing user account licensing

Teamwork is the key to developing SQL Source Control as well as using it

Beverly Hills 90210 and ZIP+4: Handling Addresses in Data Models

Merging Multiple User Accounts

Managing environments in DLM Dashboard

7 Key Things to Remember About Data Model Globalization

What Do Poker, Blackjack, Belot and Préférence Have to Do with Databases?

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