Oracle Database Security: Database Auditing
In this article, I will continue with Oracle Database Security and I will present some important...
Database Security in Oracle
There is no secret that information makes the world go around currently. If an enterprise takes care of its intellectual property and each...
Azure SQL Database Automatic Tuning
Microsoft has recently announced an incredible new feature – automatic tuning in Azure SQL Database. To be honest, I am thoroughly...
The Art of Aggregating Data in SQL from Simple to Sliding Aggregations
Let us start our SQL journey to understand aggregating data in SQL and types of aggregations...
Understanding the Importance of Memory Setting in SQL Server
Memory is one among the resources forming the performance triangle—CPU and storage being the other two. If one is hit, the other two take...
Oracle Database Security – Encryption and Decryption
Data encryption is very important because it’s a way to protect the current and the archived data in order to ensure its confidentiality....
Struggling with Data Export from Microsoft Dynamics 365 CRM to External Portals
Though Microsoft Dynamics 365 does not offer any built-in feature to export the CRM data to...
Grouping Data using the OVER and PARTITION BY Functions
The OVER and PARTITION BY functions are both functions used to portion a results set according to specified criteria. This article explains...
Implementing Incremental Load using Change Data Capture in SQL Server
This article will be interesting to those who often have to deal with data integration. Introduction Assume that there is a database where...
Using Indexes in SQL Server Memory-Optimized Tables
Introduction In this article, we will discuss how different types of indexes in SQL Server...
