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 →

Hello everyone! Has anyone passed the Oracle 1Z0-149 exam? I would love to hear your thoughts. I attempted this exam last week and did not reach the required 66% to pass. And it appears I may be the first person posting about this exam online here.... The exam is insanely difficult; 65 questions, 90 minutes, … Continue reading Oracle 1Z0-149 Exam →

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 →