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 a variety of ways, such as with subqueries, to filter and retrieve specific data from a … 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, a lot of aspects of SQL), it is able to generate executable code and perform certain tasks. However, I found it unreliable when I asked about various database topics such as … Continue reading Does ChatGPT Know SQL? →

In Microsoft SQL Server, there are several different types of databases that 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 … Continue reading What are the different SQL Server databases used for? →

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 list the certification that is most relevant to a Database Developer, Data Engineer or a Database Administrator role. Most vendor certifications are now role based focused (rather than being … Continue reading Database Certification List →

Here is a fun puzzle that I was recently challenged with. Here we need to determine if a string is balanced if there is a matching opening and closing parenthesis, bracket or brace. Not only does the string need to have a matching parenthesis, bracket or brace, but the matching object also needs to be … 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 3 methods of returning data from a stored procedure: … Continue reading Stored Procedures: Returning Data Using a Result Set →

If you have always wondered what the different symbols and formatting mean when viewing syntax examples, Microsoft has the following page. Transact-SQL Syntax Conventions (Transact-SQL) - SQL Server | Microsoft Docs It's always a good exercise to go through the DDL statements like below and take stock of which options you understand or need to … Continue reading SQL Syntax Conventions →

Welcome to a new year. I haven't utilized the blog portion of my website yet, but I figured a nice year-end review would be a good topic. I'm not expecting a lot of people to read this, so if you are, hello and welcome! This site has become quite popular considering its niche subject of … Continue reading Happy New Year: 2022 →