Identifying and Fixing Forwarded Records Performance Issue
Before going through the Forwarded Records performance issue and resolving it, we need to review...
Implementing Failover in MS SQL Server 2017 Standard
Introduction Often, we need to ensure fault tolerance of MS SQL Server DBMS, especially, when there is no Enterprise edition, but only the...
SQL Server Database Scoped Configurations and Automatic Plan Correction
In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan Correction. Microsoft added new features...
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...
