SQL Database Project with Git Feature Branch Workflow
In this tip we look at how to work with SQL Database Projects using Git source control and using branching to work on different features.
2020-11-17
Database Design
Explore the Role of Normal Forms in Dimensional Modeling
In this tip we walk through an exercise of developing a data model based on the characteristics of the data requirements.
2020-11-04
Branching in Git with SQL Database Projects
Learn how to use Git with SQL Server Data Tools to allow branching for development and how to merge development changes.
2020-10-13
Bad Idea Cowboy Hat: Using a foreign key to prevent updates
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading
The post Bad Idea Cowboy Hat: Using...
2019-05-20
Understanding Data Modeling Part 1: Models, Models Everywhere, Nor Any Time to Think
“... I needed to know what the constituent parts of data models really are. Across the board, all platforms, all models etc. Is there anything similar to atoms and...
2019-04-14
Designing Highly Scalable Database Architectures
While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario....
2019-04-09
Graph Databases: They Who Forget the Past...
Out of the plethora of misconceptions common in the industry, quite a few are squeezed into this paragraph "The relational databases that emerged in the 80s are efficient at storing and analyzing tabular data but their underlying data model makes..."
2019-03-30
2020-07-24 (first published: 2018-12-27)
4,755 reads
Degree of Duplication
Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe Celko reminisces about the history of database design and how it relates to the concept of ‘Degree of Duplication’ in this article.
2018-02-22
3,419 reads
Using Super Keys to Enforce Database Constraints
Example of Using Super Keys to Enforce Database Constraints, instead of procedural code
2017-08-07
2,411 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers