Several Ways to Insert Split Delimited Strings in a Column
In this article, I will demonstrate several ways to split the delimited string and insert it in...
Microsoft Graph or Azure Active Directory Graph API: Which is better?
Are you a .NET developer who is stuck in great confusion when it comes to choosing Azure Active Directory or Microsoft Graph? We all have...
Learn Basic Data Analysis with SQL Window Functions
This article is about T-SQL (Transact-SQL) Window functions and their basic use in day-to-day data analysis tasks. There are many...
T-SQL SET Operators Part 2: INTERSECT and EXCEPT
In my previous article, I explained the basics of set operators, their types, and prerequisites for...
How to Properly Use the T-SQL IsNumeric Function
This article is focused on the T-SQL (Transact-SQL) IsNumeric function and its proper use in day-to-day SQL scripting tasks. We will also...
T-SQL Datetime Data Type
Introduction Data types are attributes that specify the kind of data that objects such as columns, local variables, expressions, and...
Advanced SQL: Variations and Different Use cases of T-SQL Insert Statement
In my previous article, I demonstrated: Insert the output of the table-valued function in the SQL...
Jenkins Plugin Implementation
Jenkins is an open-source CI/CD solution that software developers use for building, improving, and deploying applications. It is not the...
.NET: Tools for working with multi-threading and asynchrony – Part 1
The need to do things in an asynchronous way – that is, dividing big tasks between multiple working units – was present long before the...
How to Automate the Process of SQL Server Database Schema Synchronization
The goal Keeping two databases in sync is a task we often encounter when working on SQL database...
