Introduction to Synonyms in SQL Server

Database administration, SQL Server, Work with data • One Comment

A synonyms in SQL Server are database objects that give an alternative name to the database objects...
Read More

How to Auto-trigger AWS Lambda Functions

AWS, Cloud

When we think about a cloud solution provider, we often consider the most popular ones, i.e. Amazon Web Services, Microsoft Azure, and...
Read More

Financial Dashboard With Oracle Visualization Desktop

Business intelligence, Oracle BI

Oracle Analytics Cloud (OAC) is a single cloud-based platform for data preparation, in-depth analytics, and comprehensive detailed...
Read More

How to Create a Table with Multiple Foreign Keys and Not Get Confused

Constraints, Database development, Tables

Understanding Table Relations SQL server adds foreign keys to implement relations between tables in...
Read More

How to Create Data Flow in Oracle Analytics

Business intelligence, Oracle BI

The traditional approach to the transformation process (Extract, Load, Transform) requires that technical users get involved directly. They...
Read More

Advanced Analytics with Oracle Data Analytics – Handling with Express Builder Functionality

Business intelligence, Oracle BI

This article completes the series of posts dedicated to Advanced Analytics with Oracle Data Analytics. Previously, we explored such metrics...
Read More

SQL Server Replication Monitor: Scripts for Checking Replication Status

Database administration, Transaction Log

Replication is one of the oldest technologies on MS SQL Server, loved by every database...
Read More

How to Check Status Of SQL Agent Jobs using PowerShell Tool

Languages & Coding, Microsoft Azure, PowerShell, SQL Server, Tools & technologies

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...
Read More

How to Get Backup Status in SQL Server using Stored Procedure

Database development, Stored Procedures

Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data...
Read More

How to Delete Entire MySQL Database

Database administration, MySQL, Work with data

In some cases, we need to drop the entire database from the MySQL community server. This is simple...
Read More
Close