Database Design

Valuable SQL Server Database Design tips, tutorials, how-to’s, scripts, and more for SQL Server Developers.

Title Author Date
Create Table SQL Server vs Oracle Pablo Echeverria2026-06-02
SQL Server Database Diagram Tool in Management Studio Jim Evans2026-05-21
SQL Server DROP TABLE IF EXISTS Examples Joe Gavin2026-05-03
Microsoft SQL Server Data Warehouse Data Quality, Cleansing, Verification and Matching Ray Barley2026-04-23
What is a Relational Database Eric Blinn2026-03-25
Drop All Tables SQL Server Joe Gavin2026-01-18
Add New Columns Versus New Table in SQL Server Jared Westover2025-02-04
SQL Create Database Valuable Tutorial with T-SQL and SSMS Nisarg Upadhyay2024-12-11
Build Polymorphic Associations in SQL Server with Foreign Keys Jared Westover2024-12-06
GUID in SQL Server​ Rick Dobson2024-11-22
Building an Enterprise Resource Planning (ERP) Database System Sebastiao Pereira2024-08-07
Normalization in SQL to Reduce Data Redundancy Daniel Calbimonte2024-07-15
Modify SQL Server database tables to keep similar columns together Greg Robidoux2024-05-30
SQL Server Table Design Guide – Data Types, Primary Keys and more Jared Westover2023-11-01
SQL Script for Table and Column Properties in a SQL Server Database Hadi Fadlallah2023-09-29
Append SQL Table with New Columns and Add New Data Rajendra Gupta2023-08-08
Insight into Rowstore and Columnstore Indexes in SQL Server Jared Westover2023-06-08
Star Schema vs Snowflake Schema for Dimensional Modeling Koen Verbeeck2023-04-24
Snowflake Schema Overview and Usage in Power BI Koen Verbeeck2023-04-04
Star Schema Data Modeling for Power BI Koen Verbeeck2023-03-16
SQL Create Schema to Organize Objects, Permissions and Management Joe Gavin2023-01-09
How to Build an ERD for Database Applications David Ekete2022-12-15
Getting Started with SQL Schemas Aubrey Love2022-12-12
Determine SQL Server Page Counts for Tables, Indexes and Objects Jared Westover2022-12-09
Drop All Tables in SQL Server and Generate a List of Objects with Type Aubrey Love2022-10-19
Add a Column in a Table in SQL Manvendra Singh2022-09-26
SQL ALTER TABLE to Add, Delete and Change Columns in a Table John Miner2022-09-19
Create SQL Server Database Tables, Foreign Keys and Data Jan Potgieter2022-08-18
Create Table SQL Server with Foreign Key Constraints Jan Potgieter2022-08-09
Create Table SQL Server Step by Step Jan Potgieter2022-07-28
Create Database SQL Server with SSMS or T-SQL Jan Potgieter2022-07-05
Reduce Size of SQL Server Logging Tables with Dimension Tables Aaron Bertrand2022-04-08
Cleanup and Enhance Data in SQL Server Dimension Tables Aaron Bertrand2022-04-08
CREATE TABLE SQL Server Syntax Examples Aubrey Love2022-03-15
Surrogate Key vs Natural Key Differences and When to Use in SQL Server Ben Snaidero2022-01-31
Generate SQL Server Sparse Columns Script Svetlana Golovko2022-01-18
SQL Server Sparse Columns Identifying Columns For Conversion Ken Simmons2022-01-14
Find and Remove Duplicate Rows from a SQL Server Table Sergey Gigoyan2021-07-20
SQL Drop Column Examples Joe Gavin2021-04-15
Gitflow Workflow Feature Branching for SQL Database Projects Haroon Ashraf2020-12-30
What is a Relational Database Management System Nai Biao Zhou2020-12-11
SSMS Database Diagram Support Objects Cannot Be Installed Sergey Gigoyan2020-12-02
Basics of Gitflow Workflow for SQL Database Projects Haroon Ashraf2020-11-17
Git Branch for New Features in SQL Database Project Haroon Ashraf2020-10-30
SQL Server Data Tools in Visual Studio with GIT Source Control Haroon Ashraf2020-10-20
Explore the Role of Normal Forms in Dimensional Modeling Nai Biao Zhou2020-10-06
Git Branch with SQL Server Database Project Haroon Ashraf2020-09-29
Alter Table Modify Column ONLINE Issues in SQL Server Aaron Bertrand2020-08-19
Create Table in SQL Server using Excel Template Greg Robidoux2020-07-29
SQL Server Performance Testing for Check Constraint vs Foreign Key Ben Snaidero2020-04-21
Dealing with a No NULL Requirement for Data Modeling in SQL Server K. Brian Kelley2020-01-28
Create Tables in SQL Server with T-SQL Gauri Mahajan2019-12-23
SQL Server Create Database Examples Joe Gavin2019-12-11
SQL Server Foreign Key Hierarchy Order and Dependency List Script Eduardo Pivaral2019-09-24
Find SQL Server Integer Columns to Make Skinnier Aaron Bertrand2019-07-25
What is a GUID in SQL Server Siddharth Mehta2019-04-23
Query Extended Properties from Multiple SQL Server Databases Aaron Bertrand2019-04-05
SQL Server IOT Database Design Example Semjon Terehhov2019-02-18
Reverse Engineer SQL Server Databases with Visual Studio John Miner2019-02-07
Float vs Numeric for SQL Server CPU Usage Arithmetic Operations Ben Snaidero2018-12-11
Add Primary Key to Prepopulated Table using SQL Server Object Explorer Haroon Ashraf2018-10-30
Create Star Schema Data Model in SQL Server with Microsoft Toolset Nai Biao Zhou2018-09-17
Data Modeling: Understanding First Normal Form in SQL Server K. Brian Kelley2018-08-16
Why Surrogate Keys are Needed for a SQL Server Data Warehouse Dinesh Asanka2018-07-24
CRUD Operations in SQL Server Jeffrey Yao2018-07-19
The Pros and Cons of Using T-SQL Soft Transactions Tim Smith2018-07-18
Working with SQL Server Extended Properties Jayendra Viswanathan2018-04-13
Compare SQL Server Page Splits for INT vs BIGINT vs GUID Data Types Ben Snaidero2017-11-16
SQL Table Join Performance for INT vs BIGINT vs GUID Data Types Ben Snaidero2017-10-19
SQL Server Performance Comparison INT versus GUID Ben Snaidero2017-09-29
Easy way to compare SQL Server table schemas Matteo Lorini2017-04-18
Remodel Poorly Designed SQL Server Database Tables Derek Colley2016-05-11
Identify and Correct SQL Server Forwarded Records Brady Upton2013-06-25
Solving the SQL Server Multiple Cascade Path Issue with a Trigger Ben Snaidero2012-08-07
Using DELETE CASCADE Option for Foreign Keys Ben Snaidero2012-08-01
Using Hashbytes to track and store historical changes for SQL Server data Christian Allaire2012-07-19
Storing E-mail addresses more efficiently in SQL Server – Part 2 Aaron Bertrand2012-04-12
Storing E-mail addresses more efficiently in SQL Server Aaron Bertrand2012-03-13
Optimal Storage of IP addresses in a SQL Server database Brent Shaub2011-11-28
Creative Uses for Extended Properties in SQL Server Brent Shaub2011-07-11
Understanding First Normal Form in SQL Server K. Brian Kelley2011-06-28
SQL Server Database Design with a One To One Relationship Brent Shaub2011-05-16
SQL Server Data Type Consistency Aaron Bertrand2010-09-29
Using Microsoft Quadrant for data analysis and modeling Siddharth Mehta2010-04-05
Create a Simple SQL Server Database Server Object Report Siddharth Mehta2010-02-01
Getting started with SQL Server database diagrams Atif Shehzad2009-08-14
Identifying Object Dependencies in SQL Server Ashish Kumar Mehta2009-06-09
Using Computed Columns in SQL Server with Persisted Values Atif Shehzad2009-02-06
Script to build a SQL Data Dictionary and report with Microsoft Excel Kun Lee2008-12-02
SQL Server User Defined Data Types, Rules and Defaults Atif Shehzad2008-11-17
Build a SQL Server Data Dictionary with the Extended Properties Kun Lee2008-11-04
Create SQL Server Data Dictionary in Seconds Ken Simmons2008-05-15
Calculating Table Width in SQL Server Jeremy Kadlec2007-12-12
Retrieving SQL Server Column Properties with COLUMNPROPERTY Greg Robidoux2007-06-28
Identify All SQL Server Tables with Columns of a BLOB Data Type Jeremy Kadlec2007-06-15
Data model access after a SQL Server database restore Jeremy Kadlec2006-11-13
SQL Server Data Modeling Tools Jeremy Kadlec2006-10-06
SQL Server 2005 Data Modeling Tools Jeremy Kadlec2006-09-20