Redgate Blog

10 December 2015

Tip #10 – How to use a data type that is not listed in the data types panel

Redgate Data Modeler will never let you get stuck in a data type dead end. Even if the type you need is not listed, it doesn’t mean you cannot use it. Data types you can find in the data types panel are just the most popular ones. Read more

Redgate Data Modeler

9 December 2015

Redgate Data Modeler

9 December 2015

Tip #9 – How to create multiple references between two tables

Relationships in the real world may not be as easy as we would like them to be. Sometimes we want to model a situation where one table is refering to the other more than once. Luckily, with Redgate Data Modeler, this is a piece of cake. Read more

Redgate Data Modeler

8 December 2015

Redgate Data Modeler

8 December 2015

Tip #8 – Setting Your Own Names for Primary Key

Sometimes the naming convention you use requires a specific pattern for the primary keys’ names. That’s why you may want to set your own names for each primary key in your database model instead of using default ones. Go on reading to get to know how to do this in… Read more

Matt Hilbert

7 December 2015

Matt Hilbert

7 December 2015

Smaller software releases are big news too

This has been a good year for Redgate customers. Major software releases of SQL Prompt, SQL Compare, Redgate Monitor, and SQL Source Control have introduced new features, added support for the latest versions of SQL Server Management Studio and Visual Studio, and made them even easier and more intuitive to… Read more

SQL Toolbelt

Redgate Data Modeler

7 December 2015

Redgate Data Modeler

7 December 2015

Tip #7 – How to include comments in SQL script

You can comment on your database objects (tables, columns, views) in Redgate Data Modeler. You can also include this metadata in your database, where it can be accessed by your SQL developers or DBAs. Read more

Redgate Data Modeler

6 December 2015

Redgate Data Modeler

6 December 2015

Tip #6 – How to Create a Multicolumn Primary Key

Primary keys may contain more than one column. Multicolumn primary keys are frequently used for junction tables, which are used to model many-to-many relationships. Read more

Redgate Data Modeler

5 December 2015

Redgate Data Modeler

5 December 2015

Tip #5 – How to quote table names in generated SQL script

Sometimes, you want all identifiers in your SQL script to be quoted. For example, you want them to have a particular case. Luckily, Redgate Data Modeler allows you to quote all SQL identifiers in your generated script to prevent you from any SQL name conflicts. Read more

Redgate Data Modeler

4 December 2015

Redgate Data Modeler

4 December 2015

Tip #4 – How to Make a Column Unique

Sometimes there are columns in a table that don’t belong to primary key, but are still unique. To mark them as a unique, you have to create an alternate (unique) key containing it. Read more

Redgate Data Modeler

3 December 2015

Redgate Data Modeler

3 December 2015

Tip #3 – How to copy table between models

Did you know that you can copy tables between models in Redgate Data Modeler? It's useful for instance with tables that appear in almost every database model like user_account, address, client or product, or with tables that are specific for your domain. You don't have to create all tables from… Read more

Redgate Data Modeler

3 December 2015

Redgate Data Modeler

3 December 2015

How Does Database Design Help Organize Teachers, Lessons, and Students?

In this article we will show you how to design a database structure for an educational institution to store information about students, lecturers, classes, attendance, students’ achievements, etc. 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 Test Data Manager

Redgate Blog

Tip #10 – How to use a data type that is not listed in the data types panel

Tip #9 – How to create multiple references between two tables

Tip #8 – Setting Your Own Names for Primary Key

Smaller software releases are big news too

Tip #7 – How to include comments in SQL script

Tip #6 – How to Create a Multicolumn Primary Key

Tip #5 – How to quote table names in generated SQL script

Tip #4 – How to Make a Column Unique

Tip #3 – How to copy table between models

How Does Database Design Help Organize Teachers, Lessons, and Students?

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

Redgate Test Data Manager

Cookies on red-gate.com