Visual Studio vs JetBrains Rider: A Detailed Comparison

15:59 Uncategorized

Microsoft’s Visual Studio has been in use for over two decades. It is the default integrated...
Read More

A Deeper Dive into AWS IAM

11:22 AWS, Cloud

In this article, we are going to explore the Identity and Access Management concepts available in Amazon Web Services. Abbreviated as IAM,...
Read More

SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection

11:04 Database development, Statements

Using Structured Query Language (SQL) can seem complicated at first, but further, it will become easier and much more convenient. You only...
Read More

Restoring SQL Server Data Warehouse Sample Database AdventureWorksDW2019 Using Azure Data Studio

11:01 Azure, Cloud

I explained a step-by-step process to restore the data warehouse sample database AdventureWorks DW...
Read More

SQL JOINs Tutorial with Examples

10:18 Database development, Statements

In this article, we are going to takes a close look at SQL Server JOINs. We will review all supported SQL Server JOIN types with syntax,...
Read More

SQL Server Triggers – Part 2 DDL & LOGON Triggers

14:26 Database development, Triggers

In SQL Server, triggers are database objects which will get executed whenever a triggering event happens on the database or server....
Read More

Restoring Sample DW Database AdventureWorksDW2019

14:02 Database administation

Sometimes, we need a sample database that has all the required objects along with a large set of...
Read More

SQL Server Triggers: DML Triggers

11:20 Database development, Triggers

In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Read More

Spark SQL – the Most Important Tool for a Big Data Engineer

10:44 Frameworks, Languages & Coding

Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re working with the Spark platform. But what...
Read More

Working with Power BI Slicer

13:56 Business intelligence, Power BI

Power BI is a data analytics and interpretation tool developed by Microsoft. With Power BI, you can...
Read More
Close