A Deeper Dive into AWS IAM

AWS, Cloud

In this article, we are going to explore the Identity and Access Management concepts available in...
Read More

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

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

Azure, Cloud

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

SQL JOINs Tutorial with Examples

Database development, Statements

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

SQL Server Triggers – Part 2 DDL & LOGON Triggers

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

Database administation

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

SQL Server Triggers: DML Triggers

Database development, Triggers

In SQL Server, triggers are database objects which get executed whenever a triggering event happens...
Read More

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

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

Business intelligence, Power BI

Power BI is a data analytics and interpretation tool developed by Microsoft. With Power BI, you can create various types of static and...
Read More

Drop Temp Table in SQL Server and PostgreSQL

Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the...
Read More
Close