SSRS Reports Development in Simple Terms

Business intelligence, SSRS

The article is dedicated to the fundamentals of SQL Server Reporting Services (SSRS) development...
Read More

Several Ways to Insert Split Delimited Strings in a Column

Database development, Tables

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...
Read More

Microsoft Graph or Azure Active Directory Graph API: Which is better?

Azure, Cloud

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...
Read More

Learn Basic Data Analysis with SQL Window Functions

Database administration, Work with data

This article is about T-SQL (Transact-SQL) Window functions and their basic use in day-to-day data...
Read More

T-SQL SET Operators Part 2: INTERSECT and EXCEPT

Database development, Statements, T-SQL

In my previous article, I explained the basics of set operators, their types, and prerequisites for their use. I also talked about UNION...
Read More

How to Properly Use the T-SQL IsNumeric Function

Languages & Coding, T-SQL

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...
Read More

T-SQL Datetime Data Type

Database administration, Work with data

Introduction Data types are attributes that specify the kind of data that objects such as columns,...
Read More

Advanced SQL: Variations and Different Use cases of T-SQL Insert Statement

Database development, Languages & Coding, Statements, T-SQL

In my previous article, I demonstrated: Insert the output of the table-valued function in the SQL table. Insert the output of the...
Read More

Jenkins Plugin Implementation

Tools & technologies, Utilities & Extensions

Jenkins is an open-source CI/CD solution that software developers use for building, improving, and deploying applications. It is not the...
Read More

.NET: Tools for working with multi-threading and asynchrony – Part 1

ASP .NET CORE, Languages & Coding, Tools & technologies

The need to do things in an asynchronous way – that is, dividing big tasks between multiple...
Read More
Close