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...
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 share, copy, or distribute data to multiple...
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,...
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 Microsoft SQL Server Integration Service,...
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,...
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, and I highly recommend deploying Azure...
How to Connect an Oracle ADW with Power BI and Create Sales Dashboard
Oracle Autonomous Data Warehouse (ADW) is a fully managed and high-performance solution, turned and...
