ChatGPT: SQL as a Religion

I have noticed that ChatGPT is quite adept at refining my technical writing and providing insights for creative composition (and really horrible at answering SQL quiz questions). Recently, I came across individuals sharing their ChatGPT generated texts that create religions based on various subjects, so I thought it would be interesting to ask ChatGPT to … Continue reading ChatGPT: SQL as a Religion

Attributes, Fields, and Columns

In the context of databases, the terms attribute, field, and column are often used interchangeably, especially in relational databases. However, there are slight nuances in the way they're used within different contexts. Here, I create a blog post to quickly define the differences and nuances of these terms. If you are unfamiliar with ERD, Conceptual, … Continue reading Attributes, Fields, and Columns

Understanding Different Key Types in SQL

In the realm of database design, there are a total of twelve distinct keys to be taken into account. Primary, foreign, and unique keys are typically well-known among SQL developers, as they are implemented through SQL syntax and serve as constraints. However, when undertaking database design, it is important to consider additional key types that … Continue reading Understanding Different Key Types in SQL

What are the different SQL Server databases used for?

In Microsoft SQL Server, several different types of databases can be created and used for different purposes. Here is a brief overview of some of the most common types of databases in SQL Server and the scenarios in which they are typically used. Databases are categorized into two different types, User and System: User databases: … Continue reading What are the different SQL Server databases used for?