How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
2022-09-14
Database Design
One or Many Databases
When you have multiple clients in your application, do you want one or many databases?
2022-06-08
223 reads
SQL Server and Oracle Create Table Comparison
In this article we look at a comparison of different things you can specify when creating tables in SQL Server and in Oracle.
2022-04-01
Is the Database a Series of Microservices?
Is a database like a series of micro-services? Steve draws an analogy today.
2021-11-12
126 reads
Missing Data
When we don't have all the information needed to model data, we often use NULL. However, that causes other issues.
2021-04-12
2,495 reads
A Beginning Project
Learning to be a better database developer can be hard. Today Steve asks how you might suggest someone learn.
2021-01-22
233 reads
Gitflow Workflow Feature Branching for SQL Database Projects
Learn how to use Gitflow workflow to meet the needs of developing new database related features and how to deploy these database changes.
2021-01-21
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
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
Blogs
PGSQL Phriday #001: Two Truths and a Lie
As a part of my own journey of learning within PostgreSQL, I’ve decided that...
Daily Coping 7 Oct 2022
By Steve Jones
Today’s coping tip is to be willing to share how you feel and ask...
T-SQL Tuesday #155 –The Dynamic Code Invitation
By Steve Jones
Apologies for the late invitation. A minor snafu has me hosting again. This is...
Forums
How to display original part and recommende part with each other but must recome
I work on sql server 2019 i face issue on slow running when I...
Any reason to use AWS WAF over Cloudflare?
I'm primarily using Cloudflare for security. I was wondering if AWS WAF is any...
OP identification
In lengthy discussions and in developing trial and error scenarios I sometimes find it...
Ask SSC