Efficient Table Migration to a New Schema in T-SQL

This article will explain why and how you can easily move tables to new schemas if the need arisees.

Star Schema vs Snowflake Schema Considerations

Sometimes people say to avoid the snowflake schema and stick to a clean star schema. Why is that? Is something wrong with creating a snowflake schema?

Schema Only Database Backup

Use DBCC CLONEDATABASE to make a Schema Only Database Backup

Default Schemas

Moving a Default Schema

The Schema Name

Setting a default schema

Moving a Table

Being Careful with Schema Ownership

When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.

Renaming a Schema in SQL Server

If you have a schema you want to retire, here's a method for moving all objects inside that schema to a new one.