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...
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 analysis tasks. There are many...
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...
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, local variables, expressions, and...
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...
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 working units – was present long before the...
Read More

How to Automate the Process of SQL Server Database Schema Synchronization

Automation, Database administration, PowerShell

The goal Keeping two databases in sync is a task we often encounter when working on SQL database development and maintenance. One...
Read More

SQL Vulnerability Assessment

SSMS, Tools & technologies

SQL Vulnerability Assessment is a feature available in the latest versions of SQL Server Management...
Read More
Close