Redgate logo for print use
Skip to contentRedgate logo
  • Products
  • Solutions
  • Customers
  • Our company
  • Support
  • Learning & community
  • Buy now
    • See all products
    • Request a quote
    • Contact sales
    • My account
    • Shopping cart
  • Products
    • All products
    • Redgate Flyway
    • Redgate Monitor
    • Redgate Test Data Manager
    • SQL Toolbelt Essentials
    • Productivity
      • SQL Prompt
      • Redgate Data Modeler
      • SQL Search
      • Redgate pgNow
    • Test data management
      • Redgate Test Data Manager
    • Version control
      • Redgate Flyway
      • SQL Source Control
      • Source Control for Oracle
    • Comparison products
      • SQL Compare
      • SQL Data Compare
      • Schema Compare for Oracle
      • Data Compare for Oracle
      • Redgate pgCompare
      • Schema Compare for MySQL
    • .NET
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Performance Profiler
      • ANTS Memory Profiler
      • SmartAssembly
    • All products
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Memory Profiler
      • ANTS Performance Profiler
      • Data Compare for Oracle
      • Data Masker
      • Redgate Data Modeler
      • Redgate Flyway
      • Redgate Monitor
      • Redgate pgCompare
      • Redgate pgNow
      • Redgate Test Data Manager
      • Schema Compare for MySQL
      • Schema Compare for Oracle
      • SmartAssembly
      • Source Control for Oracle
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
      • SQL Toolbelt Essentials
  • Use Cases
    • Overview
    • Security and compliance
    • Database monitoring and observability
    • Database change management
    • Productivity and workflow automation
    • Cloud migration and workload optimization
    • Database modernization
    • Efficiency and cost optimization
    • AI data readiness
  • Customers
  • Our company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Newsroom
    • Leadership
  • Support
  • Learning & community
    • Learning & community | Redgate Hub
    • Product articles
    • University
    • Events
    • Forums
    • Community
    • Simple Talk
  • Buy now
    • See all products
    • Request a quote
    • Contact sales
    • My account
    • Shopping cart

Security and compliance

Ensure data security and compliance with data masking, monitoring, and change traceability

Database monitoring and observability

Monitor and understand your databases with full visibility into performance and change

Database change management

Build, test, and deploy database changes with confidence

Productivity and workflow automation

Simplify and speed up database development workflows

AI data readiness

Prepare reliable data foundations for AI initiatives

Database modernization

Simplify and secure database modernization across platforms

Efficiency and cost optimization

Control costs and boost efficiency in database operations

Cloud migration and workload optimization

Simplify and speed up cloud database transformation

New report2026 State of database landscape cover

2026 State of the Database Landscape − download the report

Get an overview of our solutions

Redgate Flyway

Bring stability and speed to database deployments

Redgate Monitor

Understand server performance in an instant with fast deep-dive analysis

SQL Toolbelt Essentials

10 simple tools for fast SQL Server development

Redgate Test Data Manager

Get test data that catches bugs and passes audits

See all our products

New 2026 State of the Database Landscape report|Get your copy

Redgate Blog

  • All
  • Audit & compliance
  • Database development
  • DevOps
  • Events
  • Software development
  • Working at Redgate
Redgate Data Modeler

Redgate Data Modeler

23 February 2016

Redgate Data Modeler

Redgate Data Modeler

23 February 2016

13 Blog Articles on Database Design Best Practices and Tips

There’s a lot to keep in mind when you’re designing a database, and very few of us can remember every valuable tip and trick we’ve learned. So, let’s take a look at some online resources that feature database design tips and best practices. As we go, I’ll share… Read more
Redgate Data Modeler

Redgate Data Modeler

16 February 2016

Redgate Data Modeler

Redgate Data Modeler

16 February 2016

How to Store Authentication Data in a Database. Part 4

Logging in with one account – Facebook or Google, for example – is extremely popular. Users gain easy access, and developers can delegate the sensitive process of authenticating users to social media services. In this article we'll show you how to implement signing in with Facebook in Python app, using… Read more
Redgate Data Modeler

Redgate Data Modeler

11 February 2016

Redgate Data Modeler

Redgate Data Modeler

11 February 2016

Viewing Holidays With Data Modeler’s Eyes

Celebration!! Family time!! Long drive!! A day at the beach!! All these words buzz into our minds when we think of holidays. Have you ever considered how a multinational company keeps track of holidays across the globe? There must be a data dictionary to maintain all these details so that… Read more
Redgate Data Modeler

Redgate Data Modeler

9 February 2016

Redgate Data Modeler

Redgate Data Modeler

9 February 2016

“Is It Secret? Is It Safe?” Handling Sensitive Data in Your Data Modeling

This is the second in a multi-part series on how to apply information security principles and techniques as part of data modeling. This series uses a simple data model designed to manage non-commercial clubs as an example of security approaches. In later articles, we will address modeling for fine-grained… Read more
Redgate Data Modeler

Redgate Data Modeler

4 February 2016

Redgate Data Modeler

Redgate Data Modeler

4 February 2016

The Reference Data Pattern: Extensible and Flexible

Having reference tables in your database is no big deal, right? You just need to tie a code or ID with a description for each reference type. But what if you literally have dozens and dozens of reference tables? Is there an alternative to the one-table-per-type approach? Read on to… Read more
Redgate Data Modeler

Redgate Data Modeler

28 January 2016

Redgate Data Modeler

Redgate Data Modeler

28 January 2016

19 Online Resources for Learning About Database Design Errors

We all make mistakes, and we can all learn from other people’s mistakes. In this post, we’ll take a look at numerous online resources for avoiding poor database design that can lead to many problems and cost both time and money. And in an upcoming article, we’ll tell you where… Read more
John Walley

John Walley

27 January 2016

John Walley

John Walley

27 January 2016

Octopus Deploy and ReadyRoll in under 5 minutes

When it comes to deploying SQL Server databases, Octopus Deploy and ReadyRoll make a great team. And with our new plugin you can get set up in record time! You can use Octopus Deploy Step Templates to provide a user interface for common tasks. We’ve created a ReadyRoll step template… Read more

Octopus Deploy

SQL Change Automation

Redgate Data Modeler

Redgate Data Modeler

26 January 2016

Redgate Data Modeler

Redgate Data Modeler

26 January 2016

WordPress – Behind the Scenes, Part 2

In Part 1 of this series, I demonstrated how to install WordPress locally and how to import a WordPress database into Redgate Data Modeler. In this article, we’ll take a look at the tables in the WordPress database. Read more
Redgate Data Modeler

Redgate Data Modeler

21 January 2016

Redgate Data Modeler

Redgate Data Modeler

21 January 2016

WordPress – Behind the Scenes, Part 1

How often have you wondered about the structure of an existing database? It could be a 5-year-old legacy system or a brand-new open-source project. Let’s take a look at the ERD diagram of the database behind the most famous content management system: WordPress. Read more
Redgate Data Modeler

Redgate Data Modeler

14 January 2016

Redgate Data Modeler

Redgate Data Modeler

14 January 2016

Logging in With External Services

Inputting a username and password is one way of accessing an account, but it’s not the only one. In this article, we’ll see how to enable external services (like Google or Facebook) when logging in to a database. Read more
PreviousNext
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
The 2026 State of Database Landscape report cover

New report for 2026

2026 State of the Database Landscape

Database teams are under pressure to move faster than ever – without losing control. The State of the Database Landscape reveals how teams are responding in 2026.

Download the report

The "Introduction to PostgreSQL for the data professional" front cover

Free book

Introduction to PostgreSQL for the data professional

From getting your first instance, to server configurations, we cover the PostgreSQL basics.

Get your free copy

Products

  • Redgate Monitor
  • Redgate Flyway
  • Redgate Test Data Manager
  • SQL Toolbelt Essentials
  • SQL Prompt
  • SQL Compare

Solutions

  • Security and compliance
  • Database monitoring and observability
  • Database change management
  • Productivity and workflow automation
  • Cloud migration and workload optimization
  • Database modernization
  • Efficiency and cost optimization
  • AI data readiness

Support

  • Forums
  • Contact product support
  • Find my licenses
  • Download older versions

Our company

  • Careers
  • Contact us
  • Redgate Blog
  • Our values
  • Leadership

Trust Center

  • License agreement
  • Privacy and cookies
  • Modern slavery statement
  • CCPA
  • Accessibility

Community

  • Podcast
  • Simple Talk
  • Redgate Advocates
  • SQL Server Central

Learning

  • Product Articles
  • Events
  • University
  • Books

Partners

  • Resellers
  • Consulting partners

Follow us

Redgate on TwitterRedgate on LinkedInRedgate on YouTube
  • Copyright 1999 - 2026 Red Gate Software Ltd

Cookies on red-gate.com

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy.

  • Customize additional cookies