What is a Relational Database Management System
This article covers the relational database system evolution and covers terms used in relational models such as relation, tuple, attribute, domain, schemas, and key.
2021-01-07
Database Design
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
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,102 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
Blogs
The End of PASS
By Andy Warren
I think our profession was the better for having a professional association, even if...
Platforms for Events
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
Forums
Interview question about CPU
Hello SSC friends, I am a SQL Developer who is learning how to be...
Who is my customer?
Comments posted to this topic are about the item Who is my customer?
Ask SSC