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
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 a database like a series of micro-services? Steve draws an analogy today.
2021-11-12
111 reads
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,429 reads
Learning to be a better database developer can be hard. Today Steve asks how you might suggest someone learn.
2021-01-22
228 reads
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
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
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
In this tip we walk through an exercise of developing a data model based on the characteristics of the data requirements.
2020-11-04
Learn how to use Git with SQL Server Data Tools to allow branching for development and how to merge development changes.
2020-10-13
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
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...
By James Serra
When using Power BI and pulling data from Azure Synapse, you will use the...
hi, I am trying to execute ssis package from command line. I also tried...
Hello I need to migrate existing sql server 2012 replication to the SQL Server...
Hello, I cant understand what this code is doing, can some one please...