Hey, everyone. Thank you for checking out my blog. I can't find an option in WordPress to auto-approve comments, but please add a comment, and I will approve it. I also have a really cool GitHub here of all sorts of puzzles and database writings. I have noticed that ChatGPT is quite adept at refining my … Continue reading ChatGPT: SQL as a Religion →

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 →

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 →

The ANY, ALL, and SOME operators in SQL Server are used to compare a value to a set of values. The SOME operator is a synonym for ANY and can be used interchangeably. These operators can be used in various ways, such as with subqueries, to filter and retrieve specific data from a table. It's … Continue reading ANY, ALL, and SOME equivalents →

Does ChatGPT Know SQL? The short answer is "Yes, but not entirely". While ChatGPT may not be proficient in all aspects of SQL (actually, many aspects of SQL), it can generate executable code and perform certain tasks. However, I found it unreliable when I asked about various database topics, such as normalization forms and implicit … Continue reading Does ChatGPT Know SQL? →

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? →

Last updated 09/11/2023 I have moved this list to my GitHub, as it is easier to maintain there. Please use the following link! GitHub - Database Certification List If anyone wants a list of Database related certifications, I created a list. A couple of things first.... In my list below, I have tried to include … Continue reading Database Certification List →

Here is a fun puzzle that I was recently challenged with. We need to determine if a string is balanced if there is a matching opening and closing parenthesis, bracket, or brace. The string must have a matching parenthesis, bracket, or brace, and the matching object must also be in the correct order. Let's look … Continue reading Unbalanced String Puzzle →

For this article, we are going to examine the benefit of using stored procedures that simply return a result set (i.e. a stored procedure that has a SELECT statement). Before we do a shallow dive into this functionality, it is worth noting that SQL Server has three methods of returning data from a stored procedure: … Continue reading Stored Procedures: Returning Data Using a Result Set →