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...
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 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...
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 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...
.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 development and maintenance. One...
SQL Vulnerability Assessment
SQL Vulnerability Assessment is a feature available in the latest versions of SQL Server Management...