Visual Studio vs JetBrains Rider: A Detailed Comparison
Microsoft’s Visual Studio has been in use for over two decades. It is the default integrated...
A Deeper Dive into AWS IAM
In this article, we are going to explore the Identity and Access Management concepts available in Amazon Web Services. Abbreviated as IAM,...
SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection
Using Structured Query Language (SQL) can seem complicated at first, but further, it will become easier and much more convenient. You only...
Restoring SQL Server Data Warehouse Sample Database AdventureWorksDW2019 Using Azure Data Studio
I explained a step-by-step process to restore the data warehouse sample database AdventureWorks DW...
SQL JOINs Tutorial with Examples
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,...
SQL Server Triggers – Part 2 DDL & LOGON Triggers
In SQL Server, triggers are database objects which will get executed whenever a triggering event happens on the database or server....
Restoring Sample DW Database AdventureWorksDW2019
Sometimes, we need a sample database that has all the required objects along with a large set of...
SQL Server Triggers: DML Triggers
In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Spark SQL – the Most Important Tool for a Big Data Engineer
Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re working with the Spark platform. But what...
Working with Power BI Slicer
Power BI is a data analytics and interpretation tool developed by Microsoft. With Power BI, you can...
