SSRS Reports Development in Simple Terms
The article is dedicated to the fundamentals of SQL Server Reporting Services (SSRS) development...
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 into a column of a table in SQL Server. You...
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...
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 their use. I also talked about UNION...
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,...
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 table. Insert the output of the...
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...