The Cartesian Product in SQL
Cartesian product in SQL is a term from the set theory of mathematics. However, we can also find...
Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021
If you deal with SQL infrastructure, especially Microsoft SQL Servers, you deal with SSMS. The SQL Server Management Studio is the default...
Clustered and Non Clustered Index: 7 Top Points Explained
Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what does it mean and where should you apply...
SQL Server Transactional Replication Internals
SQL Server Transactional Replication is one of the most common Replication techniques used to...
NoSQL vs SQL: Which One is Better for Big Data Management?
Nowadays, customer behavior becomes more complex and market trends continue to shift rapidly. Thus, businesses need specialized...
Introduction to Layers in AWS Lambda Functions
AWS Lambda is an event-driven, serverless cloud computing service provided by Amazon, a part of the Amazon Web Services. It responds to...
Oracle Data Integrator (ODI) Tutorial: How to Import Files into Oracle Autonomous Data Warehouse (ADW)
When you build an ETL / ELT enterprise system, you need the Data Integration tools, such as...
Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages
In professional work scenarios, we often need to load data from one report to several destinations, such as Excel files and SQL databases....
Simple SQL Server Functions to Solve Real-World Problems
Introduction Today’s article comes from a scenario we experienced in practice some time ago. We managed a card transaction system...
How to Connect to Azure SQL Database Securely
As a database administrator, I started my journey in deploying managed SQL databases on the cloud,...
