10 Key Concepts Developers Should Know About the SQL Server model Database
This article covers the 10 key concepts developers should understand to avoid surprises and to use the model database intentionally.
2026-01-02
Model Database
Replace Model SQL Server Database with a User Database
In this tip we look at what happens if we replace the SQL Server model database with a regular user database
2020-01-09
Some tips for working with big data models
The main goal of this article is to present some tips to help professionals that need to work with complex, big, and hard to understand database models that anyone may came across some day.
2012-12-21 (first published: 2011-03-03)
28,848 reads
2010-04-15
3,442 reads
2010-03-15
3,777 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers