SQL DB Linked Servers
Introduction: SQL Server Linked Servers is a feature in Microsoft SQL Server that allows you to connect and execute commands against OLE DB data sources on different servers. This functionality…
Read MoreSQL Server Show Plan Permission
Introduction: In this blog, we will explore what Show Plan permission is and how it can help DBAs and developers gain insights into the Estimated and Actual Execution Plans. Show…
Read MoreSQL Server Query Store
Introduction The Query Store is a feature in SQL Server that provides insight into query performance by tracking and storing detailed information about query execution over time. The Query Store…
Read MoreOracle EBS – Query to get Purchase Order Details approved based on Hierarchy
Oracle EBS – Query to get Purchase Order Details approved based on Hierarchy Select * from ( SELECT TO_CHAR (SYSDATE, ‘DD-MON-YYYY HH:MI:SS’) rp_run_date, po.* FROM (SELECT ou, supplier_number, supplier_name, po_number,…
Read MoreOracle EBS – Query to get Open Purchase Order Details
Oracle EBS – Query to get Open Purchase Order Details SELECT org_code, org, operating_unit, buyer, supplier, po_number, line_num line_number, item_code item, item_description description, quantity, unit_price price, need_by_date, shipment_line_num, shipment_qty, shipment_needby_date,…
Read MoreHow to Monitor the Performance of MYSQL Database
How to Monitor the Performance of MYSQL Database Introduction: – Monitoring MySQL performance is crucial for maintaining a healthy and efficient database system. There are several tools and techniques you…
Read MoreHow to Monitor the Performance of Amazon DynamoDB
How to Monitor the Performance of Amazon DynamoDB Introduction: – Monitoring the performance of Amazon DynamoDB involves tracking key metrics, setting up alarms for thresholds, and using tools like AWS…
Read MoreThe Fundamentals of User Interface Design
The Fundamentals of User Interface Design Introduction: In digital experiences, user interface (UI) design is pivotal in shaping how users interact with and perceive a product or service.…
Read MoreDB Alert Log: “Shutdown Waiting for Active Calls to Complete”
DESCRIPTION: When attempting to shut down database, the database hangs and the alert log contains the below messages. “SHUTDOWN: Waiting for active calls to complete” CAUSES: Database is waiting for…
Read MoreConfiguring Select one, Select many page items In oracle Apex
Introduction: – Oracle APEX offers a robust set of page item types to capture user input effectively. Among these, Select One and Select Many items are particularly versatile for…
Read More