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,749 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,406 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers