How to Auto-trigger AWS Lambda Functions
When we think about a cloud solution provider, we often consider the most popular ones, i.e. Amazon...
Financial Dashboard With Oracle Visualization Desktop
Oracle Analytics Cloud (OAC) is a single cloud-based platform for data preparation, in-depth analytics, and comprehensive detailed...
How to Create a Table with Multiple Foreign Keys and Not Get Confused
Understanding Table Relations SQL server adds foreign keys to implement relations between tables in a relational database. A table can have...
How to Create Data Flow in Oracle Analytics
The traditional approach to the transformation process (Extract, Load, Transform) requires that...
Advanced Analytics with Oracle Data Analytics – Handling with Express Builder Functionality
This article completes the series of posts dedicated to Advanced Analytics with Oracle Data Analytics. Previously, we explored such metrics...
SQL Server Replication Monitor: Scripts for Checking Replication Status
Replication is one of the oldest technologies on MS SQL Server, loved by every database administrator. It is a great and reliable...
How to Check Status Of SQL Agent Jobs using PowerShell Tool
From a certain point in my career, I started to play around with PowerShell. But I never imagined...
How to Get Backup Status in SQL Server using Stored Procedure
Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data...
How to Delete Entire MySQL Database
In some cases, we need to drop the entire database from the MySQL community server. This is simple but irreversible. Thus, the DROP...
Easy Answers to 5 Vital Questions about Composite Index in SQL
Imagine you need to query a table with a WHERE clause on columns a, b, and c. Sometimes, you filter...
