Introduction to Synonyms in SQL Server
A synonyms in SQL Server are database objects that give an alternative name to the database objects...
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 Web Services, Microsoft Azure, and...
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...
How to Create Data Flow in Oracle Analytics
The traditional approach to the transformation process (Extract, Load, Transform) requires that technical users get involved directly. They...
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...
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 that it would become such an essential...
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...