Voice Command Navigation in Oracle APEX
Introduction: – Voice technology is no longer just for virtual assistants like Alexa or Siri—it can now be used inside your Oracle APEX applications to provide hands-free navigation. This trial…
Read MoreExport Data to Excel Instantly in Oracle APEX Without Displaying Any Report
Introduction: – In Oracle APEX, exporting data to Excel is often tied to Interactive Reports or Grids, requiring the data to be displayed before download. But what if you could…
Read MoreCopying table data from source to destination in SQL Server
PURPOSE AND SCOPE: This document explains how to transfer table data from source server to destination server. Prerequisites Database Access Permissions: Ensure that you have the necessary permissions to access…
Read MoreUsing TKPROF to Enable SQL Trace and Analyze Query Performance for Identifying Slowness in the Database
Introduction In Oracle databases, performance issues often stem from inefficient SQL queries. TKPROF is a powerful utility that formats the output of SQL trace files, making it easier to interpret…
Read MoreEnabling Query Store on SQL Server 2019
Introduction: When it comes to database performance tuning, that’s where Query Store appears. Introduced in 2017 version and significantly enhanced in 2019, Query Store acts like a “flight recorder” for…
Read MoreArchiving and Deleting Data From MS SQL Server Database
Archiving and Deleting Data From SQL Server Database Server: SERVER1 Main Database: DB1 Archive Database: DB1_archive Target Table: dbo.PerformanceCounters Objective: To archive and delete data older than 90 days from…
Read MoreTroubleshooting Query Plan Optimization Using Query Store
Introduction SQL Server Query Store is enabled to assist in monitoring query performance and identifying query plan regressions. Query Store captures a history of query plans, making it an excellent…
Read MoreWhen tempdb Won’t Shrink
Introduction In SQL Server, the tempdb system database can grow significantly due to heavy workloads, temporary objects, or large queries. Sometimes, even after reducing workload or removing temporary data, tempdb…
Read MoreResolving Error ORA-00955: name is already used by an existing object
Introduction While working with Oracle databases, you may encounter the error ORA-00955: name is already used by an existing object when trying to create objects like tables, indexes, or materialized…
Read MoreResolving ORA-39405: Upgrading Target Database Time Zone File to Match Source in Oracle Data Pump Imports
Introduction When performing an Oracle Data Pump import, mismatched database Time Zone File (TSTZ) versions between the source and target databases can cause an ORA-39405 error. This issue occurs because Oracle…
Read More